//#region 列表存盘 protected void YscqfListSave() { string userID = AppService.GetUserID(); string dw_list = Request.Form["dw_list"].ToString(); SafeDS ds_list = new SafeDS("dw_hddz_hdfyyscqfy_list"); try { ds_list.SetChanges(dw_list); ds_list.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (ds_list.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 Response.Write("存盘成功"); ////数据上传生鲜港 //Thread t1 = new Thread(new ThreadStart(delegate //{ //HddzIF serv = new HddzIF(); for (int row = 1; row <= ds_list.RowCount; row++) { string zt = ds_list.GetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary).ToString(); if (zt == "NotModified") { string ywbh = ds_list.GetItemString(row, "ywbh"); int cxh = ds_list.GetItemInt32(row, "jzxxx_cxh"); string zdmc = "yscqfqrrq"; string strErr; Interfaces.GeneralPortal.DataToFreshPort("yw_hddz_jzxxx", zdmc, ywbh, out strErr, new string[] { cxh.ToString() }); } ; } ; //})); //t1.IsBackground = true; //t1.Start(); } else { this.DBHelp.Rollback();; this.SetErrorInfo("应收超期费保存失败!\n\n详细错误信息:\n" + ds_list.DBError); } } catch (Exception ex) { this.SetErrorInfo(ex.Message); } finally { ds_list.Dispose(); ds_list = null; } }
//单据保存 protected void Save() { string userID = AppService.GetUserID(); string dw_master = Request.Form["dw_master"].ToString(); string dw_jzxxx = Request.Form["dw_jzxxx"].ToString(); string dw_rwxz = Request.Form["dw_rwxz"].ToString(); string dw_lsjl = Request.Form["dw_lsjl"].ToString(); string ywbh = Request.Form["ywbh"].ToString(); string cxh = Request.Form["cxh"].ToString(); string dw_log = Request.Form["dw_log"].ToString(); string sj = "Y"; string sftj = "Y"; SafeDS ds_master = new SafeDS("dw_wlgz_edit"); SafeDS ds_jzxxx = new SafeDS("dw_wlgz_edit_cmd"); SafeDS ds_rwxz = new SafeDS("dw_wlgz_jzxxx"); SafeDS ds_lsjl = new SafeDS("dw_wlgz_edit_wldz_lsjl"); SafeDS ds_log = new SafeDS("dw_s_log_list"); try { ds_master.SetChanges(dw_master); ds_jzxxx.SetChanges(dw_jzxxx); ds_rwxz.SetChanges(dw_rwxz); ds_lsjl.SetChanges(dw_lsjl); ds_log.SetChanges(dw_log); #region MyRegion ////TODO 在服务器端,最好是重做一次数据校验,Demo简化处理,不再重复校验了。 //if (rwbh == null || rwbh == "" || rwbh == null) //{ // if (ds_master.GetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary) == Sybase.DataWindow.RowStatus.NewAndModified) // { // var year = System.DateTime.Now.ToString("yyyyMMdd"); // SqlCommand cmd = this.DBHelp.GetCommand("select max(right(rwbh,4)) from yw_hddz_wlgz where substring(rwbh,1,8) = '" + year.Substring(0, 8) + "' "); // object value = cmd.ExecuteScalar(); // if (Convert.IsDBNull(value) || value == null) // { // rwbh = year.Substring(0, 8) + "0001"; // } // else // { // rwbh = year.Substring(0, 8) + String.Format("{0:0000}", (long.Parse((string)value) + 1)); // } // ds_master.SetItemString(1, "rwbh", rwbh); // } // else // { // rwbh = ds_master.GetItemString(1, "rwbh"); // } //} //for (int row = 1; row <= ds_jzxxx.RowCount; row++) //{ // ds_jzxxx.SetItemString(row, "rwbh", rwbh); //} //if (ds_rwxz.RowCount > 0) //{ // var gq_sfxz = ds_rwxz.GetItemString(1, "gq_sfxz"); // if (gq_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "gq_rwbh", rwbh); // } // else if (gq_sfxz == "N") // { // ds_rwxz.SetItemString(1, "gq_rwbh", ""); // } // var gq_c_sfxz = ds_rwxz.GetItemString(1, "gq_c_sfxz"); // if (gq_c_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "gq_c_rwbh", rwbh); // } // else if (gq_c_sfxz == "N") // { // ds_rwxz.SetItemString(1, "gq_c_rwbh", ""); // } // var hgcyd_sfxz = ds_rwxz.GetItemString(1, "hgcyd_sfxz"); // if (hgcyd_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "hgcyd_rwbh", rwbh); // } // else if (hgcyd_sfxz == "N") // { // ds_rwxz.SetItemString(1, "hgcyd_rwbh", ""); // } // var hgcyd_c_sfxz = ds_rwxz.GetItemString(1, "hgcyd_c_sfxz"); // if (hgcyd_c_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "hgcyd_c_rwbh", rwbh); // } // else if (hgcyd_c_sfxz == "N") // { // ds_rwxz.SetItemString(1, "hgcyd_c_rwbh", ""); // } // var jyd_sfxz = ds_rwxz.GetItemString(1, "jyd_sfxz"); // if (jyd_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "jyd_rwbh", rwbh); // } // else if (jyd_sfxz == "N") // { // ds_rwxz.SetItemString(1, "jyd_rwbh", ""); // } // var jyd_c_sfxz = ds_rwxz.GetItemString(1, "jyd_c_sfxz"); // if (jyd_c_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "jyd_c_rwbh", rwbh); // } // else if (jyd_c_sfxz == "N") // { // ds_rwxz.SetItemString(1, "jyd_c_rwbh", ""); // } // var zjfscwld_sfxz = ds_rwxz.GetItemString(1, "zjfscwld_sfxz"); // if (zjfscwld_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "zjfscwld_rwbh", rwbh); // } // else if (zjfscwld_sfxz == "N") // { // ds_rwxz.SetItemString(1, "zjfscwld_rwbh", ""); // } // var zjfscwld_c_sfxz = ds_rwxz.GetItemString(1, "zjfscwld_c_sfxz"); // if (zjfscwld_c_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "zjfscwld_c_rwbh", rwbh); // } // else if (zjfscwld_c_sfxz == "N") // { // ds_rwxz.SetItemString(1, "zjfscwld_c_rwbh", ""); // } // var sc_sfxz = ds_rwxz.GetItemString(1, "sc_sfxz"); // if (sc_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "sc_rwbh", rwbh); // } // else if (sc_sfxz == "N") // { // ds_rwxz.SetItemString(1, "sc_rwbh", ""); // } // var sc_c_sfxz = ds_rwxz.GetItemString(1, "sc_c_sfxz"); // if (sc_c_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "sc_c_rwbh", rwbh); // } // else if (sc_c_sfxz == "N") // { // ds_rwxz.SetItemString(1, "sc_c_rwbh", ""); // } // var jschfscwld_sfxz = ds_rwxz.GetItemString(1, "jschfscwld_sfxz"); // if (jschfscwld_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "jschfscwld_rwbh", rwbh); // } // else if (jschfscwld_sfxz == "N") // { // ds_rwxz.SetItemString(1, "jschfscwld_rwbh", ""); // } // var jschfscwld_c_sfxz = ds_rwxz.GetItemString(1, "jschfscwld_c_sfxz"); // if (jschfscwld_c_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "jschfscwld_c_rwbh", rwbh); // } // else if (jschfscwld_c_sfxz == "N") // { // ds_rwxz.SetItemString(1, "jschfscwld_c_rwbh", ""); // } // var fscwld3_sfxz = ds_rwxz.GetItemString(1, "fscwld3_sfxz"); // if (fscwld3_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "fscwld3_rwbh", rwbh); // } // else if (fscwld3_sfxz == "N") // { // ds_rwxz.SetItemString(1, "fscwld3_rwbh", ""); // } // var fscwld3_c_sfxz = ds_rwxz.GetItemString(1, "fscwld3_c_sfxz"); // if (fscwld3_c_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "fscwld3_c_rwbh", rwbh); // } // else if (fscwld3_c_sfxz == "N") // { // ds_rwxz.SetItemString(1, "fscwld3_c_rwbh", ""); // } // var fscwld4_sfxz = ds_rwxz.GetItemString(1, "fscwld4_sfxz"); // if (fscwld4_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "fscwld4_rwbh", rwbh); // } // else if (fscwld4_sfxz == "N") // { // ds_rwxz.SetItemString(1, "fscwld4_rwbh", ""); // } // var fscwld4_c_sfxz = ds_rwxz.GetItemString(1, "fscwld4_c_sfxz"); // if (fscwld4_c_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "fscwld4_c_rwbh", rwbh); // } // else if (fscwld4_c_sfxz == "N") // { // ds_rwxz.SetItemString(1, "fscwld4_c_rwbh", ""); // } // var dc_sfxz = ds_rwxz.GetItemString(1, "dc_sfxz"); // if (dc_sfxz == "Y") // { // ds_rwxz.SetItemString(1, "dc_rwbh", rwbh); // } // else if (dc_sfxz == "N") // { // ds_rwxz.SetItemString(1, "dc_rwbh", ""); // } //} #endregion ds_master.SetTransaction(this.DBHelp.TransAction); ds_jzxxx.SetTransaction(this.DBHelp.TransAction); ds_rwxz.SetTransaction(this.DBHelp.TransAction); ds_lsjl.SetTransaction(this.DBHelp.TransAction); ds_log.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (ds_master.UpdateData() == 1) { ds_lsjl.UpdateData(); ds_jzxxx.UpdateData(); if (ds_rwxz.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 //if (cmd.ExecuteNonQuery() > 0){ if (ds_log.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 } else { DBHelp.Rollback(); this.SetErrorInfo("传输错误日志保存失败!\n\n详细错误信息:\n" + ds_log.DBError); } DBHelp dbHelp = new DBHelp(); SqlCommand cmd = new SqlCommand(); var userid = AppService.GetUserID(); try { #region MyRegion //StringBuilder str = new StringBuilder(); //str.Append("update yw_hddz_jzxxx "); //str.Append("set cgqsj = case when (select max(jrdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '港区' ) is null then cgqsj else (select max(jrdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '港区' ) end ,"); //str.Append("djydsj = case when (select max(jrdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '检疫点' ) is null then djydsj else (select max(jrdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '检疫点' ) end,"); //str.Append("tgjysj = case when (select max(cdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '检疫点' ) is null then tgjysj else (select max(cdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '检疫点' ) end,"); //str.Append("cscsj = case when (select max(cdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '市场' ) is null then cscsj else (select max(cdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '市场' ) end ,"); //str.Append("hdcsj = case when (select max(jrdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '堆场') is null then hdcsj else (select max(jrdzwlsj) from Yw_hddz_wlgz_cmd where ywbh = yw_hddz_jzxxx.ywbh and hddz_cxh = yw_hddz_jzxxx.cxh and rwmc = '堆场') end "); //str.Append("from yw_hddz_jzxxx "); //str.Append("where ywbh = @ywbh and cxh = @cxh ;"); #endregion cmd = dbHelp.GetCommand("p_hywlgz"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd.Parameters.Add(new SqlParameter("@cxh", cxh)); cmd.ExecuteNonQuery(); for (int i = 1; i <= ds_master.RowCount; i++) { sj = "Y"; string dzwlbh = ds_master.GetItemString(i, "dzwlbh"); string dzwlbh_old = ds_master.GetItemString(i, "dzwlbh_old"); string rwbh = ds_master.GetItemString(i, "rwbh"); string sfybd = ds_master.GetItemString(i, "sfybd"); string cph = ds_master.GetItemString(i, "cph"); string cph_old = ds_master.GetItemString(i, "cph_old"); DateTime?rwkssj = ds_master.GetItemDateTime(i, "rwkssj"); ds_jzxxx.SetFilter("rwbh = '" + rwbh + "'"); ds_jzxxx.Filter(); for (int j = 1; j <= ds_jzxxx.RowCount; j++) { string dz_xx = ds_jzxxx.GetItemString(j, "dz_xx"); string jd = ds_jzxxx.GetItemString(j, "jd"); string wd = ds_jzxxx.GetItemString(j, "wd"); string fw = ds_jzxxx.GetItemString(j, "fw"); int wllx = ds_jzxxx.GetItemInt32(j, "wllx"); string points = ds_jzxxx.GetItemString(j, "points"); DateTime rq_null = DateTime.Parse("1900/1/1 0:00:00"); string aa = rwkssj.ToString(); if (rwkssj == null || aa == "1900/1/1 0:00:00") { sj = "N"; } } if (sj == "Y" && (sfybd == "Y" || sfybd == null) && cph.Length > 0) { IFView.FenceHandler fenceHandler = new IFView.FenceHandler(); string strerr = string.Empty; bool flag = fenceHandler.AddLogisticsMonitoring(dzwlbh, out strerr); if (strerr == null) { strerr = ""; } DBHelp.BeginTransAction(); SqlCommand cmd_wlgz = DBHelp.GetCommand("insert into yw_hddz_wlgz_bd (rwbh,dqsj,strerr,cph,cph_old) values(@rwbh,getdate(),@strerr,@cph,@cph_old)"); cmd_wlgz.Parameters.Add(new SqlParameter("@rwbh", rwbh)); cmd_wlgz.Parameters.Add(new SqlParameter("@strerr", strerr)); cmd_wlgz.Parameters.Add(new SqlParameter("@cph", cph)); cmd_wlgz.Parameters.Add(new SqlParameter("@cph_old", cph_old)); if (cmd_wlgz.ExecuteNonQuery() > 0) { DBHelp.Commit(); } else { DBHelp.Rollback(); } //if (flag == false) //{ // this.SetErrorInfo("调用北斗地图失败原因:" + strerr); //} //强制结束老的任务 if (cph != cph_old && cph_old != "" && cph_old != null) { IFView.FenceHandler fenceHandler_zqjs = new IFView.FenceHandler(); string strerr_qzjs = string.Empty; bool flag_qzjs = fenceHandler_zqjs.stopTask(dzwlbh_old, out strerr); if (strerr_qzjs == null) { strerr_qzjs = ""; } DBHelp.BeginTransAction(); SqlCommand cmd_wlgz_qzjs = DBHelp.GetCommand("insert into yw_hddz_wlgz_bd (rwbh,dqsj,strerr,cph,cph_old) values(@dzwlbh_old,getdate(),@strerr_qzjs,@cph,@cph_old)"); cmd_wlgz_qzjs.Parameters.Add(new SqlParameter("@dzwlbh_old", "删除" + dzwlbh_old)); cmd_wlgz_qzjs.Parameters.Add(new SqlParameter("@strerr_qzjs", strerr_qzjs)); cmd_wlgz_qzjs.Parameters.Add(new SqlParameter("@cph", cph)); cmd_wlgz_qzjs.Parameters.Add(new SqlParameter("@cph_old", cph_old)); if (cmd_wlgz_qzjs.ExecuteNonQuery() > 0) { DBHelp.Commit(); } else { DBHelp.Rollback(); } } } } } catch (Exception ex) { this.SetErrorInfo(ex.Message); } finally { dbHelp.Close(); dbHelp = null; } } else { this.DBHelp.Rollback();; this.SetErrorInfo("物流跟踪任务选择保存失败!\n\n详细错误信息:\n" + ds_rwxz.DBError); } } else { this.DBHelp.Rollback(); this.SetErrorInfo("物流跟踪任务保存失败!\n\n详细错误信息:\n" + ds_master.DBError + " " + ds_master.LastError); } } catch (Exception ex) { this.SetErrorInfo(ex.Message); } finally { ds_master.Dispose(); ds_master = null; ds_jzxxx.Dispose(); ds_jzxxx = null; ds_rwxz.Dispose(); ds_rwxz = null; ds_lsjl.Dispose(); ds_lsjl = null; ds_log.Dispose(); ds_log = null; } }
//单据保存 protected void Save() { string userID = AppService.GetUserID(); string skdbh = Request.Form["skdbh"].ToString(); int skd_cxh = Int32.Parse(Request.Form["skd_cxh"]); var operation = Request.Form["operation"].ToString(); string dw_master = Request.Form["dw_master"].ToString(); string dw_jzxxx = Request.Form["dw_jzxxx"].ToString(); SafeDS ds_master = new SafeDS("dw_hddz_skhx_edit"); SafeDS ds_jzxxx = new SafeDS("dw_hddz_skhx_edit_cmd"); try { ds_master.SetChanges(dw_master); ds_jzxxx.SetChanges(dw_jzxxx); if (operation == "copy" || operation == "modify") { ds_master.SetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); for (int row = 1; row <= ds_jzxxx.RowCount; row++) { ds_jzxxx.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } } ; //TODO 在服务器端,最好是重做一次数据校验,Demo简化处理,不再重复校验了。 if (skdbh == null || skdbh == "") { skdbh = ds_master.GetItemString(1, "skdbh"); skd_cxh = ds_master.GetItemInt32(1, "cmd_cxh"); } for (int row = 1; row <= ds_jzxxx.RowCount; row++) { ds_jzxxx.SetItemString(row, "skdbh", skdbh); ds_jzxxx.SetItemDouble(row, "skd_cxh", skd_cxh); } ds_master.SetTransaction(this.DBHelp.TransAction); ds_jzxxx.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (ds_master.UpdateData() == 1) { if (ds_jzxxx.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 Response.Write(skdbh); } else { this.DBHelp.Rollback();; this.SetErrorInfo("收款核销明细信息保存失败!\n\n详细错误信息:\n" + ds_jzxxx.DBError); } } else { this.DBHelp.Rollback(); this.SetErrorInfo("收款核销保存失败!\n\n详细错误信息:\n" + ds_master.DBError + " " + ds_master.LastError); } } catch (Exception ex) { this.SetErrorInfo(ex.Message); } finally { ds_master.Dispose(); ds_master = null; ds_jzxxx.Dispose(); ds_jzxxx = null; } }
public void Save() { //string master = Request.Form["dw_Master"].ToString(); //string dw_log = Request.Form["dw_log"].ToString(); //SafeDS ds = new SafeDS("dw_hddz_tggz"); //SafeDS ds_log = new SafeDS("dw_s_log_list"); string dw_1 = Request.Form["dw_1"].ToString(); string dw_2 = Request.Form["dw_2"].ToString(); string dw_3 = Request.Form["dw_3"].ToString(); string dw_4 = Request.Form["dw_4"].ToString(); string dw_log = Request.Form["dw_log"].ToString(); SafeDS ds_1 = new SafeDS("dw_hddz_tggz"); SafeDS ds_2 = new SafeDS("dw_hddz_tggz_b_one"); SafeDS ds_3 = new SafeDS("dw_hddz_tggz_b_two"); SafeDS ds_4 = new SafeDS("dw_hddz_tggz_b_three"); SafeDS ds_log = new SafeDS("dw_s_log_list"); try { //ds.SetChanges(master); //ds_log.SetChanges(dw_log); //ds.SetTransaction(this.DBHelp.TransAction); //ds_log.SetTransaction(this.DBHelp.TransAction); ds_1.SetChanges(dw_1); ds_2.SetChanges(dw_2); ds_3.SetChanges(dw_3); ds_4.SetChanges(dw_4); ds_log.SetChanges(dw_log); for (var i = 1; i <= ds_4.RowCount; i++) { var dz_xx = ds_4.GetItemString(i, "dz_xx"); } ds_1.SetTransaction(this.DBHelp.TransAction); ds_2.SetTransaction(this.DBHelp.TransAction); ds_3.SetTransaction(this.DBHelp.TransAction); ds_4.SetTransaction(this.DBHelp.TransAction); ds_log.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (ds_1.UpdateData() == 1) { ds_2.UpdateData(); ds_3.UpdateData(); ds_4.UpdateData(); ds_log.UpdateData(); this.DBHelp.Commit(); DBHelp dbHelp = new DBHelp(); SqlCommand cmd = new SqlCommand(); try { cmd = dbHelp.GetCommand("p_hywlgz"); cmd.CommandType = CommandType.StoredProcedure; for (int i = 1; i <= ds_4.RowCount; i++) { var ywbh = ds_4.GetItemString(i, "ywbh"); var hddz_cxh = ds_4.GetItemInt32(i, "hddz_cxh"); cmd.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd.Parameters.Add(new SqlParameter("@cxh", hddz_cxh.ToString())); cmd.ExecuteNonQuery(); dbHelp.Commit(); } for (int i = 1; i <= ds_2.RowCount; i++) { var ywbh = ds_2.GetItemString(i, "ywbh"); var cxh = ds_2.GetItemInt32(i, "cxh"); cmd.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd.Parameters.Add(new SqlParameter("@cxh", cxh.ToString())); cmd.ExecuteNonQuery(); } dbHelp.Commit(); } catch (Exception ex) { this.SetErrorInfo(ex.Message); } finally { dbHelp.Close(); dbHelp = null; } this.SetSuccessedInfo("数据保存成功"); // Response.Write("存盘成功"); } else { this.DBHelp.Rollback(); this.SetErrorInfo("数据保存失败!"); return; } } catch (Exception ex) { this.SetErrorInfo(ex.Message); } finally { ds_1.Dispose(); ds_1 = null; ds_2.Dispose(); ds_2 = null; ds_3.Dispose(); ds_3 = null; ds_4.Dispose(); ds_4 = null; ds_log.Dispose(); ds_log = null; } }
//#region 码头业务处理列表存盘 protected void MtywclListSave() { string userID = AppService.GetUserID(); string dw_list = Request.Form["dw_list"].ToString(); SafeDS ds_list = new SafeDS("dw_hy_mtywcl_list"); //string dw_log = Request.Form["dw_log"].ToString(); //SafeDS ds_log = new SafeDS("dw_s_log_list"); try { ds_list.SetChanges(dw_list); //ds_log.SetChanges(dw_log); ds_list.SetTransaction(this.DBHelp.TransAction); //ds_log.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (ds_list.UpdateData() == 1) // if (ds_list.e) { //if (ds_log.UpdateData()==1) //{ this.DBHelp.Commit(); //////数据上传生鲜港 //Thread t1 = new Thread(new ThreadStart(delegate //{ //HddzIF serv = new HddzIF(); for (int row = 1; row <= ds_list.RowCount; row++) { string zt = ds_list.GetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary).ToString(); if (zt == "NotModified") { string ywbh = ds_list.GetItemString(row, "ywbh"); int cxh = ds_list.GetItemInt32(row, "cxh"); string zdmc = "fxgsjc,fxsj"; string strErr; Interfaces.GeneralPortal.DataToFreshPort("yw_hddz_jzxxx", zdmc, ywbh, out strErr, new string[] { cxh.ToString() }); DBHelp.Commit(); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("select count(*),rwbh= isnull(max(Yw_hddz_wlgz_cmd.rwbh),''),dzwlbh= isnull(max(Yw_hddz_wlgz.dzwlbh),'') from Yw_hddz_wlgz,Yw_hddz_wlgz_cmd,yw_hddz_jzxxx Where Yw_hddz_wlgz.rwbh = Yw_hddz_wlgz_cmd.rwbh and Yw_hddz_wlgz_cmd.ywbh = yw_hddz_jzxxx.ywbh and Yw_hddz_wlgz_cmd.hddz_cxh = yw_hddz_jzxxx.cxh and Yw_hddz_wlgz_cmd.ywbh=@ywbh and Yw_hddz_wlgz_cmd.hddz_cxh = @cxh and len(yw_hddz_jzxxx.fxdcjc) > 0 and Yw_hddz_wlgz_cmd.rwmc = '堆场' and (jd is null and points is null)"); cmd.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd.Parameters.Add(new SqlParameter("@cxh", cxh)); SqlDataReader rs = cmd.ExecuteReader(); if (rs.Read()) { int num = rs.GetInt32(0); string rwbh = rs.GetString(1); string dzwlbh = rs.GetString(2); rs.Close(); if (num > 0) { SqlCommand cmd_update = DBHelp.GetCommand(" update Yw_hddz_wlgz_cmd set Yw_hddz_wlgz_cmd.jd = yw_wldw_gnkh_shdz.jd, Yw_hddz_wlgz_cmd.wd = yw_wldw_gnkh_shdz.wd, Yw_hddz_wlgz_cmd.fw = yw_wldw_gnkh_shdz.fw, Yw_hddz_wlgz_cmd.wllx = yw_wldw_gnkh_shdz.type,Yw_hddz_wlgz_cmd.points = yw_wldw_gnkh_shdz.points from Yw_hddz_wlgz_cmd,yw_hddz_jzxxx ,yw_wldw_gnkh_shdz,yw_wldw Where Yw_hddz_wlgz_cmd.ywbh = yw_hddz_jzxxx.ywbh and Yw_hddz_wlgz_cmd.hddz_cxh = yw_hddz_jzxxx.cxh and yw_wldw_gnkh_shdz.yw_khbm = yw_wldw.yw_khbm and yw_wldw.khjc = yw_hddz_jzxxx.fxdcjc and Yw_hddz_wlgz_cmd.ywbh=@ywbh and Yw_hddz_wlgz_cmd.hddz_cxh = @cxh and len(yw_hddz_jzxxx.fxdcjc) > 0 and Yw_hddz_wlgz_cmd.rwmc = '堆场' and (Yw_hddz_wlgz_cmd.jd is null and Yw_hddz_wlgz_cmd.points is null) "); cmd_update.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd_update.Parameters.Add(new SqlParameter("@cxh", cxh)); if (cmd_update.ExecuteNonQuery() > 0) { DBHelp.Commit(); IFView.FenceHandler fenceHandler = new IFView.FenceHandler(); string strerr = string.Empty; bool flag = fenceHandler.AddLogisticsMonitoring(dzwlbh, out strerr); if (strerr == null) { strerr = ""; } DBHelp.BeginTransAction(); SqlCommand cmd_wlgz = DBHelp.GetCommand("insert into yw_hddz_wlgz_bd (rwbh,dqsj,strerr) values(@rwbh,getdate(),@strerr)"); cmd_wlgz.Parameters.Add(new SqlParameter("@rwbh", rwbh)); cmd_wlgz.Parameters.Add(new SqlParameter("@strerr", strerr)); if (cmd_wlgz.ExecuteNonQuery() > 0) { DBHelp.Commit(); } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } } } else { DBHelp.Rollback(); } } ; } ; //})); //t1.IsBackground = true; //t1.Start(); //把单据号码,传回到客户端 Response.Write("存盘成功"); //} //else { // this.DBHelp.Rollback(); // this.SetErrorInfo("传输错误日志保存失败!\n\n详细错误信息:\n"+ds_log.DBError); //} } else { this.DBHelp.Rollback();; this.SetErrorInfo("码头业务处理保存失败!\n\n详细错误信息:\n" + ds_list.DBError); } } catch (Exception ex) { this.SetErrorInfo(ex.Message); } finally { ds_list.Dispose(); ds_list = null; //ds_log.Dispose(); //ds_log = null; } }