jam2003y
شنبه 22 فروردین 1388, 10:46 صبح
من یه برنامه به زبان سی شارپ نوشتم قبلا همه چیز خوب کار می کرد تا اینکه 2 فیلد جدید به یکی از تیبل هام اضافه کردم حالا وقتی یک فیلد رو آپدیدت میکنم تغییرات بدون هیچ گونه اخطاری ذخیره نمیشه لطفا اگه کسی اطلاعاتی داره دریغ نکنه
OleDbCommand objCommand = new OleDbCommand();
OleDbConnection objConnection = new OleDbConnection();
objConnection.ConnectionString = CONSTR;
intPosition = objCurrencyManager.Position;
objCommand.Connection = objConnection;
objCommand.CommandText = "UPDATE [MOSHKHASAT]" +
" SET [kelasa]=@kelasa,[TARIKH_BAZDIDA]=@TARIKH_BAZDIDA, [name_chah]=@name_chah," +
"[loc_ID]=@loc_ID, [ID_SHAHRESTAN]=@ID_SHAHRESTAN," +
"[NAME_BAKHSH]=@NAME_BAKHSH,[NAME_ROSTA]=@NAME_ROSTA,[num_zone_utm]=@num_zone_utm,[utm_X]=@utm_X,[utm_y]=@utm_y,[utm_Z]=@utm_Z,[y_loc]=@y_loc," +
"[h_loc] =@h_loc,[NAME_MALEK]=@NAME_MALEK,[SH_PARVANEH]=@SH_PARVANEH,[TARIKH_PARVANEH]=@TARIKH_PARVANEH,[SH_MOJAVEZ]=@SH_MOJAVEZ,[TARIKH_MOJAVEZ]=@TARIKH_MOJAVEZ,[HP_MOJAZ]=@HP_MOJAZ,[KW_MOJAZ]=@KW_MOJAZ," +
"[GH_PIPE_ABE]=@GH_PIPE_ABE,[ID_akharin_mojavez_type]=@ID_akharin_mojavez_type," +
"[akharin_mojavez_no]=@akharin_mojavez_no,[akharin_mojavez_date]=@akharin_mojavez_date,[OMEGH]=@OMEGH,[GHOTER_POMP]=@GHOTER_POMP,[TABAGHE_NO]=@TABAGHE_NO," +
"[OMEGH_POMP]=@OMEGH_POMP,[ID_type_masraf]=@ID_type_masraf,[NEMAYANDE_NAME]=@NEMAYANDE_NAME,[HAFR_SAL]=@HAFR_SAL,[LITER_MOJAZ]=@LITER_MOJAZ,[TIME_SALANE_MOJAZ]=@TIME_SALANE_MOJAZ,[SH_SAHRAII]=@SH_SAHRAII," +
"[DATETAKMIL]=@DATETAKMIL,[LOC_CHANG_ID]=@LOC_CHANG_ID,[TEDAD]=@TEDAD,[status_ghabli]=@status_ghabli,[TYPE_BAHRABARDARY_ID]=@TYPE_BAHRABARDARY_ID," +
"[TYPE_CHAH_ID]=@TYPE_CHAH_ID,[GH_PIPE_JEDAR]=@GH_PIPE_JEDAR,[GH_PIPE_ABE_feli]=@GH_PIPE_ABE_feli,[GH_PIPE_SARRIZ]=@GH_PIPE_SARRIZ," +
"[KONTOR_HAJMI_ID]=@KONTOR_HAJMI_ID,[TYPE_KONTOR_ID]=@TYPE_KONTOR_ID,[NIRO_id]=@NIRO_id," +
"[NO_GHERA_KONTOR]=@NO_GHERA_KONTOR,[MOTOR_NAME]=@MOTOR_NAME ," +
"[Type_motor]=@Type_motor," +
"[GHODRAT_MOTOR]=@GHODRAT_MOTOR,[DANDE_NAME]=@DANDE_NAME," +
"[TYPE_DANDA_id]=@TYPE_DANDA_id ,[DANDA_GHODRAT]=@DANDA_GHODRAT," +
"[TYPE_POMP_id]=@TYPE_POMP_id," +
"[ABDEHI]=@ABDEHI," +
"[havadehi]=@havadehi,[navasan]=@navasan,[zolal]=@zolal,[gelalod]=@gelalod," +
"[TYPE_ANDAZE]=@TYPE_ANDAZE," +
"[KARKARD_ROZANEH]=@KARKARD_ROZANEH,[TAKHLIYA]=@TAKHLIYA," +
"[TYPE_MASRAF_FELI]=@TYPE_MASRAF_FELI," +
"[HEDAYAT]=@HEDAYAT,[OMEGH_FELI]=@OMEGH_FELI,[d1]=@d1,[h1]=@h1,[d2]=@d2,[h2]=@h2,[d3]=@d3,[h3]=@h3,[d4]=@d4,[h4]=@h4,[d5]=@d5,[h5]=@h5,[d6]=@d6,[h6]=@h6,[d7]=@d7,[h7]=@h7,[d8]=@d8,[h8]=@h8,[d9]=@d9,[h9]=@h9,[d10]=@d10,[h10] =@h10," +
"[d11] =@d11,[h11]=@h11,[d12]=@d12,[h12]=@h12," +
"[gandom_jo] =@gandom_jo,[yonja]=@yonja,[sifi]=@sifi,[pesta]=@pesta,[bagh]=@bagh,[sayer_text]=@sayer_text,[sayer]=@sayer,[tedad_rozhae_karkard]=@tedad_rozhae_karkard,[tozihat]=@tozihat,[pelak]=@pelak" +
" WHERE [id]=@strid;";
objCommand.CommandType = CommandType.Text;
objCommand.Parameters.AddWithValue("@kelasa", TXT_KELASE.Text);
objCommand.Parameters.AddWithValue("@TARIKH_BAZDIDA", TXT_DATE.Text);
objCommand.Parameters.AddWithValue("@name_chah", TXT_NAME_CHAH.Text);
objCommand.Parameters.AddWithValue("@loc_ID", TXT_LOC_NAME.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@ID_SHAHRESTAN", TXT_SHAHRESTAN.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@NAME_BAKHSH", TXT_BAKHSH.Text);
objCommand.Parameters.AddWithValue("@NAME_ROSTA", TXT_ROSTA.Text);
objCommand.Parameters.AddWithValue("@num_zone_utm", TXT_NUM_ZONE.Text);
objCommand.Parameters.AddWithValue("@utm_X", TXT_X.Text);
objCommand.Parameters.AddWithValue("@utm_y", TXT_Y.Text);
objCommand.Parameters.AddWithValue("@utm_Z", TXT_Z.Text);
objCommand.Parameters.AddWithValue("@y_loc", TXT_LOC_Y.Text);
objCommand.Parameters.AddWithValue("@h_loc", TXT_LOC_X.Text);
objCommand.Parameters.AddWithValue("@NAME_MALEK", TXT_MALEK.Text);
objCommand.Parameters.AddWithValue("@SH_PARVANEH", TXT_PARVANEH.Text);
objCommand.Parameters.AddWithValue("@TARIKH_PARVANEH", TXT_PARVANEH_DATE.Text);
objCommand.Parameters.AddWithValue("@SH_MOJAVEZ", TXT_MOZAVEZ_NO.Text);
objCommand.Parameters.AddWithValue("@TARIKH_MOJAVEZ", TXT_MOJAVEZ_DATE.Text);
objCommand.Parameters.AddWithValue("@HP_MOJAZ", TXT_HP.Text);
objCommand.Parameters.AddWithValue("@KW_MOJAZ", TXT_KW.Text);
objCommand.Parameters.AddWithValue("@GH_PIPE_ABE", TXT_ABDE.Text);
objCommand.Parameters.AddWithValue("@ID_akharin_mojavez_type", CMB_MOJAVEZ.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@akharin_mojavez_no", TXT_AKH_MOZAVEZ_NO.Text);
objCommand.Parameters.AddWithValue("@akharin_mojavez_date", TXT_AKH_MOJAVEZ_DATE.Text);
objCommand.Parameters.AddWithValue("@OMEGH", TXT_OMEGH.Text);
objCommand.Parameters.AddWithValue("@GHOTER_POMP", TXT_GH_POMP.Text);
objCommand.Parameters.AddWithValue("@TABAGHE_NO", TXT_TA_POMP.Text);
objCommand.Parameters.AddWithValue("@OMEGH_POMP", TXT_OMEGH_POMP.Text);
objCommand.Parameters.AddWithValue("@ID_type_masraf", CMB_MASRAF.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@NEMAYANDE_NAME", TXT_NEMAYAND.Text);
objCommand.Parameters.AddWithValue("@HAFR_SAL", TXT_SAL.Text);
objCommand.Parameters.AddWithValue("@LITER_MOJAZ", TXT_BAHRABAR.Text);
objCommand.Parameters.AddWithValue("@TIME_SALANE_MOJAZ", txt_salmojaz.Text);
objCommand.Parameters.AddWithValue("@SH_SAHRAII", TXT_NO_SAHRAII.Text);
objCommand.Parameters.AddWithValue("@DATETAKMIL", TXT_DATE_TAKMIL.Text);
objCommand.Parameters.AddWithValue("@LOC_CHANG_ID", CMB_TAGHIR.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@TEDAD", txt_tedad.Text);
objCommand.Parameters.AddWithValue("@status_ghabli", CMB_STATUS_GH.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@TYPE_BAHRABARDARY_ID", CMB_STSTUS_BAH.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@TYPE_CHAH_ID", CMB_CHAH_TYPE.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@GH_PIPE_JEDAR", GH_LOLA.Text);
objCommand.Parameters.AddWithValue("@GH_PIPE_ABE_feli", txt_gh_abde.Text);
objCommand.Parameters.AddWithValue("@GH_PIPE_SARRIZ", TXT_LOLA_SAR.Text);
objCommand.Parameters.AddWithValue("@KONTOR_HAJMI_ID", CMB_HAJMI.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@TYPE_KONTOR_ID", CMB_KONTOR.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@NIRO_id", CMB_MOHRAKA.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@NO_GHERA_KONTOR", txt_kontor_no.Text);
objCommand.Parameters.AddWithValue("@MOTOR_NAME", TXT_MOTOR_NAME.Text);
objCommand.Parameters.AddWithValue("@Type_motor", CMB_MOTOR_TYPE.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@GHODRAT_MOTOR", TXT_GHODRAT.Text);
objCommand.Parameters.AddWithValue("@DANDE_NAME", TXT_DANDA.Text);
objCommand.Parameters.AddWithValue("@TYPE_DANDA_id", TXT_DANDA_TYPE.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@DANDA_GHODRAT", TXT_DANDA_GH.Text);
objCommand.Parameters.AddWithValue("@TYPE_POMP_id", CMB_TYPE_POMP.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@ABDEHI", TXT_ABE.Text);
objCommand.Parameters.AddWithValue("@havadehi", k1).DbType = DbType.Int32;
objCommand.Parameters.AddWithValue("@navasan", k2).DbType = DbType.Int32;
objCommand.Parameters.AddWithValue("@zolal", k3).DbType = DbType.Int32;
objCommand.Parameters.AddWithValue("@gelalod", k4).DbType = DbType.Int32;
objCommand.Parameters.AddWithValue("@TYPE_ANDAZE", CMB_ANDAZA.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@KARKARD_ROZANEH", TXT_KARKARD_ROZANA.Text);
objCommand.Parameters.AddWithValue("@TAKHLIYA", TXT_TAKHLI_SAL.Text);
objCommand.Parameters.AddWithValue("@TYPE_MASRAF_FELI", CMB_TYPE_MASRAF_FELI.SelectedValue.ToString()).Ole DbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@HEDAYAT", TXT_HEDAYAT.Text);
objCommand.Parameters.AddWithValue("@OMEGH_FELI", TXT_OMEGH_FELI.Text);
objCommand.Parameters.AddWithValue("@d1", TXT_D1.Text);
objCommand.Parameters.AddWithValue("@h1", TXT_H1.Text);
objCommand.Parameters.AddWithValue("@d2", TXT_D2.Text);
objCommand.Parameters.AddWithValue("@h2", TXT_H2.Text);
objCommand.Parameters.AddWithValue("@d3", TXT_D3.Text);
objCommand.Parameters.AddWithValue("@h3", TXT_H3.Text);
objCommand.Parameters.AddWithValue("@d4", TXT_D4.Text);
objCommand.Parameters.AddWithValue("@h4", TXT_H4.Text);
objCommand.Parameters.AddWithValue("@d5", TXTH5.Text);
objCommand.Parameters.AddWithValue("@h5", TXT_D5.Text);
objCommand.Parameters.AddWithValue("@d6", TXT_D6.Text);
objCommand.Parameters.AddWithValue("@h6", TXT_H6.Text);
objCommand.Parameters.AddWithValue("@d7", TXT_D7.Text);
objCommand.Parameters.AddWithValue("@h7", TXT_H7.Text);
objCommand.Parameters.AddWithValue("@d8", TXT_D8.Text);
objCommand.Parameters.AddWithValue("@h8", TXT_H8.Text);
objCommand.Parameters.AddWithValue("@d9", TXT_D9.Text);
objCommand.Parameters.AddWithValue("@h9", TXT_H9.Text);
objCommand.Parameters.AddWithValue("@d10", TXT_D10.Text);
objCommand.Parameters.AddWithValue("@h10", TXT_H10.Text);
objCommand.Parameters.AddWithValue("@h11", TXT_H11.Text);
objCommand.Parameters.AddWithValue("@d11", TXT_D11.Text);
objCommand.Parameters.AddWithValue("@h12", TXT_H12.Text);
objCommand.Parameters.AddWithValue("@d12", TXT_D12.Text);
objCommand.Parameters.AddWithValue("@gandom_jo", TXT_GANDOM.Text);
objCommand.Parameters.AddWithValue("@yonja", TXT_YONJA.Text);
objCommand.Parameters.AddWithValue("@sifi", TXT_SIFI.Text);
objCommand.Parameters.AddWithValue("@pesta", TXT_PESTA.Text);
objCommand.Parameters.AddWithValue("@bagh", TXT_BAGH.Text);
objCommand.Parameters.AddWithValue("@sayer_text", TXT_SAYER_TXT.Text);
objCommand.Parameters.AddWithValue("@sayer", TXT_SAyer.Text);
objCommand.Parameters.AddWithValue("@strid", strid2.ToString()).OleDbType = OleDbType.Integer;
objCommand.Parameters.AddWithValue("@tedad_rozhae_karkard", txt_rozha_karkard. Text);
objCommand.Parameters.AddWithValue("@tozihat", TXT_TOZIHAT. Text).OleDbType=OleDbType.Char ;
objCommand.Parameters.AddWithValue("@pelak", "23/" + TXT_LOC_ID.Text + "/" + CMB_MASRAF.SelectedValue + "/" + TXT_KELASE.Text).OleDbType=OleDbType.Char;
objConnection.Open();
OleDbException EX;
objCommand.ExecuteNonQuery();
objConnection.Close();
OleDbCommand objCommand = new OleDbCommand();
OleDbConnection objConnection = new OleDbConnection();
objConnection.ConnectionString = CONSTR;
intPosition = objCurrencyManager.Position;
objCommand.Connection = objConnection;
objCommand.CommandText = "UPDATE [MOSHKHASAT]" +
" SET [kelasa]=@kelasa,[TARIKH_BAZDIDA]=@TARIKH_BAZDIDA, [name_chah]=@name_chah," +
"[loc_ID]=@loc_ID, [ID_SHAHRESTAN]=@ID_SHAHRESTAN," +
"[NAME_BAKHSH]=@NAME_BAKHSH,[NAME_ROSTA]=@NAME_ROSTA,[num_zone_utm]=@num_zone_utm,[utm_X]=@utm_X,[utm_y]=@utm_y,[utm_Z]=@utm_Z,[y_loc]=@y_loc," +
"[h_loc] =@h_loc,[NAME_MALEK]=@NAME_MALEK,[SH_PARVANEH]=@SH_PARVANEH,[TARIKH_PARVANEH]=@TARIKH_PARVANEH,[SH_MOJAVEZ]=@SH_MOJAVEZ,[TARIKH_MOJAVEZ]=@TARIKH_MOJAVEZ,[HP_MOJAZ]=@HP_MOJAZ,[KW_MOJAZ]=@KW_MOJAZ," +
"[GH_PIPE_ABE]=@GH_PIPE_ABE,[ID_akharin_mojavez_type]=@ID_akharin_mojavez_type," +
"[akharin_mojavez_no]=@akharin_mojavez_no,[akharin_mojavez_date]=@akharin_mojavez_date,[OMEGH]=@OMEGH,[GHOTER_POMP]=@GHOTER_POMP,[TABAGHE_NO]=@TABAGHE_NO," +
"[OMEGH_POMP]=@OMEGH_POMP,[ID_type_masraf]=@ID_type_masraf,[NEMAYANDE_NAME]=@NEMAYANDE_NAME,[HAFR_SAL]=@HAFR_SAL,[LITER_MOJAZ]=@LITER_MOJAZ,[TIME_SALANE_MOJAZ]=@TIME_SALANE_MOJAZ,[SH_SAHRAII]=@SH_SAHRAII," +
"[DATETAKMIL]=@DATETAKMIL,[LOC_CHANG_ID]=@LOC_CHANG_ID,[TEDAD]=@TEDAD,[status_ghabli]=@status_ghabli,[TYPE_BAHRABARDARY_ID]=@TYPE_BAHRABARDARY_ID," +
"[TYPE_CHAH_ID]=@TYPE_CHAH_ID,[GH_PIPE_JEDAR]=@GH_PIPE_JEDAR,[GH_PIPE_ABE_feli]=@GH_PIPE_ABE_feli,[GH_PIPE_SARRIZ]=@GH_PIPE_SARRIZ," +
"[KONTOR_HAJMI_ID]=@KONTOR_HAJMI_ID,[TYPE_KONTOR_ID]=@TYPE_KONTOR_ID,[NIRO_id]=@NIRO_id," +
"[NO_GHERA_KONTOR]=@NO_GHERA_KONTOR,[MOTOR_NAME]=@MOTOR_NAME ," +
"[Type_motor]=@Type_motor," +
"[GHODRAT_MOTOR]=@GHODRAT_MOTOR,[DANDE_NAME]=@DANDE_NAME," +
"[TYPE_DANDA_id]=@TYPE_DANDA_id ,[DANDA_GHODRAT]=@DANDA_GHODRAT," +
"[TYPE_POMP_id]=@TYPE_POMP_id," +
"[ABDEHI]=@ABDEHI," +
"[havadehi]=@havadehi,[navasan]=@navasan,[zolal]=@zolal,[gelalod]=@gelalod," +
"[TYPE_ANDAZE]=@TYPE_ANDAZE," +
"[KARKARD_ROZANEH]=@KARKARD_ROZANEH,[TAKHLIYA]=@TAKHLIYA," +
"[TYPE_MASRAF_FELI]=@TYPE_MASRAF_FELI," +
"[HEDAYAT]=@HEDAYAT,[OMEGH_FELI]=@OMEGH_FELI,[d1]=@d1,[h1]=@h1,[d2]=@d2,[h2]=@h2,[d3]=@d3,[h3]=@h3,[d4]=@d4,[h4]=@h4,[d5]=@d5,[h5]=@h5,[d6]=@d6,[h6]=@h6,[d7]=@d7,[h7]=@h7,[d8]=@d8,[h8]=@h8,[d9]=@d9,[h9]=@h9,[d10]=@d10,[h10] =@h10," +
"[d11] =@d11,[h11]=@h11,[d12]=@d12,[h12]=@h12," +
"[gandom_jo] =@gandom_jo,[yonja]=@yonja,[sifi]=@sifi,[pesta]=@pesta,[bagh]=@bagh,[sayer_text]=@sayer_text,[sayer]=@sayer,[tedad_rozhae_karkard]=@tedad_rozhae_karkard,[tozihat]=@tozihat,[pelak]=@pelak" +
" WHERE [id]=@strid;";
objCommand.CommandType = CommandType.Text;
objCommand.Parameters.AddWithValue("@kelasa", TXT_KELASE.Text);
objCommand.Parameters.AddWithValue("@TARIKH_BAZDIDA", TXT_DATE.Text);
objCommand.Parameters.AddWithValue("@name_chah", TXT_NAME_CHAH.Text);
objCommand.Parameters.AddWithValue("@loc_ID", TXT_LOC_NAME.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@ID_SHAHRESTAN", TXT_SHAHRESTAN.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@NAME_BAKHSH", TXT_BAKHSH.Text);
objCommand.Parameters.AddWithValue("@NAME_ROSTA", TXT_ROSTA.Text);
objCommand.Parameters.AddWithValue("@num_zone_utm", TXT_NUM_ZONE.Text);
objCommand.Parameters.AddWithValue("@utm_X", TXT_X.Text);
objCommand.Parameters.AddWithValue("@utm_y", TXT_Y.Text);
objCommand.Parameters.AddWithValue("@utm_Z", TXT_Z.Text);
objCommand.Parameters.AddWithValue("@y_loc", TXT_LOC_Y.Text);
objCommand.Parameters.AddWithValue("@h_loc", TXT_LOC_X.Text);
objCommand.Parameters.AddWithValue("@NAME_MALEK", TXT_MALEK.Text);
objCommand.Parameters.AddWithValue("@SH_PARVANEH", TXT_PARVANEH.Text);
objCommand.Parameters.AddWithValue("@TARIKH_PARVANEH", TXT_PARVANEH_DATE.Text);
objCommand.Parameters.AddWithValue("@SH_MOJAVEZ", TXT_MOZAVEZ_NO.Text);
objCommand.Parameters.AddWithValue("@TARIKH_MOJAVEZ", TXT_MOJAVEZ_DATE.Text);
objCommand.Parameters.AddWithValue("@HP_MOJAZ", TXT_HP.Text);
objCommand.Parameters.AddWithValue("@KW_MOJAZ", TXT_KW.Text);
objCommand.Parameters.AddWithValue("@GH_PIPE_ABE", TXT_ABDE.Text);
objCommand.Parameters.AddWithValue("@ID_akharin_mojavez_type", CMB_MOJAVEZ.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@akharin_mojavez_no", TXT_AKH_MOZAVEZ_NO.Text);
objCommand.Parameters.AddWithValue("@akharin_mojavez_date", TXT_AKH_MOJAVEZ_DATE.Text);
objCommand.Parameters.AddWithValue("@OMEGH", TXT_OMEGH.Text);
objCommand.Parameters.AddWithValue("@GHOTER_POMP", TXT_GH_POMP.Text);
objCommand.Parameters.AddWithValue("@TABAGHE_NO", TXT_TA_POMP.Text);
objCommand.Parameters.AddWithValue("@OMEGH_POMP", TXT_OMEGH_POMP.Text);
objCommand.Parameters.AddWithValue("@ID_type_masraf", CMB_MASRAF.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@NEMAYANDE_NAME", TXT_NEMAYAND.Text);
objCommand.Parameters.AddWithValue("@HAFR_SAL", TXT_SAL.Text);
objCommand.Parameters.AddWithValue("@LITER_MOJAZ", TXT_BAHRABAR.Text);
objCommand.Parameters.AddWithValue("@TIME_SALANE_MOJAZ", txt_salmojaz.Text);
objCommand.Parameters.AddWithValue("@SH_SAHRAII", TXT_NO_SAHRAII.Text);
objCommand.Parameters.AddWithValue("@DATETAKMIL", TXT_DATE_TAKMIL.Text);
objCommand.Parameters.AddWithValue("@LOC_CHANG_ID", CMB_TAGHIR.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@TEDAD", txt_tedad.Text);
objCommand.Parameters.AddWithValue("@status_ghabli", CMB_STATUS_GH.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@TYPE_BAHRABARDARY_ID", CMB_STSTUS_BAH.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@TYPE_CHAH_ID", CMB_CHAH_TYPE.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@GH_PIPE_JEDAR", GH_LOLA.Text);
objCommand.Parameters.AddWithValue("@GH_PIPE_ABE_feli", txt_gh_abde.Text);
objCommand.Parameters.AddWithValue("@GH_PIPE_SARRIZ", TXT_LOLA_SAR.Text);
objCommand.Parameters.AddWithValue("@KONTOR_HAJMI_ID", CMB_HAJMI.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@TYPE_KONTOR_ID", CMB_KONTOR.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@NIRO_id", CMB_MOHRAKA.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@NO_GHERA_KONTOR", txt_kontor_no.Text);
objCommand.Parameters.AddWithValue("@MOTOR_NAME", TXT_MOTOR_NAME.Text);
objCommand.Parameters.AddWithValue("@Type_motor", CMB_MOTOR_TYPE.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@GHODRAT_MOTOR", TXT_GHODRAT.Text);
objCommand.Parameters.AddWithValue("@DANDE_NAME", TXT_DANDA.Text);
objCommand.Parameters.AddWithValue("@TYPE_DANDA_id", TXT_DANDA_TYPE.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@DANDA_GHODRAT", TXT_DANDA_GH.Text);
objCommand.Parameters.AddWithValue("@TYPE_POMP_id", CMB_TYPE_POMP.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@ABDEHI", TXT_ABE.Text);
objCommand.Parameters.AddWithValue("@havadehi", k1).DbType = DbType.Int32;
objCommand.Parameters.AddWithValue("@navasan", k2).DbType = DbType.Int32;
objCommand.Parameters.AddWithValue("@zolal", k3).DbType = DbType.Int32;
objCommand.Parameters.AddWithValue("@gelalod", k4).DbType = DbType.Int32;
objCommand.Parameters.AddWithValue("@TYPE_ANDAZE", CMB_ANDAZA.SelectedValue.ToString()).OleDbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@KARKARD_ROZANEH", TXT_KARKARD_ROZANA.Text);
objCommand.Parameters.AddWithValue("@TAKHLIYA", TXT_TAKHLI_SAL.Text);
objCommand.Parameters.AddWithValue("@TYPE_MASRAF_FELI", CMB_TYPE_MASRAF_FELI.SelectedValue.ToString()).Ole DbType = OleDbType.Decimal;
objCommand.Parameters.AddWithValue("@HEDAYAT", TXT_HEDAYAT.Text);
objCommand.Parameters.AddWithValue("@OMEGH_FELI", TXT_OMEGH_FELI.Text);
objCommand.Parameters.AddWithValue("@d1", TXT_D1.Text);
objCommand.Parameters.AddWithValue("@h1", TXT_H1.Text);
objCommand.Parameters.AddWithValue("@d2", TXT_D2.Text);
objCommand.Parameters.AddWithValue("@h2", TXT_H2.Text);
objCommand.Parameters.AddWithValue("@d3", TXT_D3.Text);
objCommand.Parameters.AddWithValue("@h3", TXT_H3.Text);
objCommand.Parameters.AddWithValue("@d4", TXT_D4.Text);
objCommand.Parameters.AddWithValue("@h4", TXT_H4.Text);
objCommand.Parameters.AddWithValue("@d5", TXTH5.Text);
objCommand.Parameters.AddWithValue("@h5", TXT_D5.Text);
objCommand.Parameters.AddWithValue("@d6", TXT_D6.Text);
objCommand.Parameters.AddWithValue("@h6", TXT_H6.Text);
objCommand.Parameters.AddWithValue("@d7", TXT_D7.Text);
objCommand.Parameters.AddWithValue("@h7", TXT_H7.Text);
objCommand.Parameters.AddWithValue("@d8", TXT_D8.Text);
objCommand.Parameters.AddWithValue("@h8", TXT_H8.Text);
objCommand.Parameters.AddWithValue("@d9", TXT_D9.Text);
objCommand.Parameters.AddWithValue("@h9", TXT_H9.Text);
objCommand.Parameters.AddWithValue("@d10", TXT_D10.Text);
objCommand.Parameters.AddWithValue("@h10", TXT_H10.Text);
objCommand.Parameters.AddWithValue("@h11", TXT_H11.Text);
objCommand.Parameters.AddWithValue("@d11", TXT_D11.Text);
objCommand.Parameters.AddWithValue("@h12", TXT_H12.Text);
objCommand.Parameters.AddWithValue("@d12", TXT_D12.Text);
objCommand.Parameters.AddWithValue("@gandom_jo", TXT_GANDOM.Text);
objCommand.Parameters.AddWithValue("@yonja", TXT_YONJA.Text);
objCommand.Parameters.AddWithValue("@sifi", TXT_SIFI.Text);
objCommand.Parameters.AddWithValue("@pesta", TXT_PESTA.Text);
objCommand.Parameters.AddWithValue("@bagh", TXT_BAGH.Text);
objCommand.Parameters.AddWithValue("@sayer_text", TXT_SAYER_TXT.Text);
objCommand.Parameters.AddWithValue("@sayer", TXT_SAyer.Text);
objCommand.Parameters.AddWithValue("@strid", strid2.ToString()).OleDbType = OleDbType.Integer;
objCommand.Parameters.AddWithValue("@tedad_rozhae_karkard", txt_rozha_karkard. Text);
objCommand.Parameters.AddWithValue("@tozihat", TXT_TOZIHAT. Text).OleDbType=OleDbType.Char ;
objCommand.Parameters.AddWithValue("@pelak", "23/" + TXT_LOC_ID.Text + "/" + CMB_MASRAF.SelectedValue + "/" + TXT_KELASE.Text).OleDbType=OleDbType.Char;
objConnection.Open();
OleDbException EX;
objCommand.ExecuteNonQuery();
objConnection.Close();