private void NewFixJudge() { DataRow drRow = this.dt_Return.NewRow(); //获取维修单号 string wxno = this.dtList.Rows[0]["WXNo"].ToString(); string warehouse = this.dtList.Rows[0]["Warehouse"].ToString(); wxno = FilterSpecial(wxno); warehouse = FilterSpecial(warehouse); string selectMain = @"SELECT [ID] ,[WXNo] ,[DepotId] ,[CreateUser] ,[SKU] ,[Status] ,[WarehouseNo] ,[ModifyTime] ,[ModifyUser] FROM [dbo].[SPWX_Main] WITH(NOLOCK) WHERE [Status] = '20' AND [WXNo] = @Param0 "; //创建连接对象 DBHandle dbh = new DBHandle("SPWX"); //获取主表状态 DataTable dtMain = dbh.GetData(selectMain,new object[]{wxno}); //判断有无初判数据 if (dtMain.Rows.Count > 0) { //获取交易表表头 DataTable dtHist = dbh.GetTabHead("[dbo].[SPWX_Hist]"); DataRow dr = dtHist.NewRow(); dr["WXNo"] = wxno; dr["BeforeStatus"] = dtMain.Rows[0]["Status"].ToString(); dr["AfterStatus"] = "25"; dr["Content"] = "操作内容:完成初判"; dr["ModifyUser"] = base.m_hzyMessage.User_Name; dtHist.Rows.Add(dr); //修改主表状态,修改人 dtMain.Rows[0]["Status"] = "25"; dtMain.Rows[0]["ModifyUser"] = base.m_hzyMessage.User_Name; dtMain.Rows[0]["ModifyTime"] = timeNow.ToString(); //获取维修价格和时间 string value = this.dtList.Rows[0]["FirstPhen"].ToString(); value = FilterSpecial(value); DataTable dtMD = GetMoneyDay(value); //新插入表 this.dtList.Columns.Add("CreateUser"); this.dtList.Columns.Add("ModifyUser"); this.dtList.Rows[0]["FixNeedTime"] = dtMD.Rows[0]["Day"].ToString(); this.dtList.Rows[0]["FixNeedMoney"] = dtMD.Rows[0]["Money"].ToString(); this.dtList.Rows[0]["CreateUser"] = base.m_hzyMessage.User_Name; this.dtList.Rows[0]["ModifyUser"] = base.m_hzyMessage.User_Name; //调用退仓单 if (warehouse.Length > 0) { string DepotId = dtMain.Rows[0]["DepotId"].ToString(); string CreateUser = dtMain.Rows[0]["CreateUser"].ToString(); string sku = dtMain.Rows[0]["SKU"].ToString(); string sendUser = base.m_hzyMessage.User_Name; string WarehouseNo = dtMain.Rows[0]["WarehouseNo"].ToString(); DBHandle dbhGP = new DBHandle("F22GP"); object[] paramObj = new object[4]; object[] paramVal = new object[4]; paramObj[0] = SParam.InputFormat; paramObj[1] = SParam.OutputFormat; paramObj[2] = SParam.OutputContentType; paramObj[3] = SParam.ConditionStr; paramVal[0] = "AML"; paramVal[1] = "DB"; paramVal[2] = "RS"; paramVal[3] = @"【操作类型,NEW】【实体,发货】 【新增内容,发货店铺ID,收货店铺ID,装箱号,款号,款式编号,颜色,尺码,退货数量,成本, 原价,现价,结算价,折扣,登记人,发货操作员,收货操作员】 【条件内容,《N》发货店铺ID,《N》收货店铺ID,《N》装箱号,《N》款号,《N》款式编号, 《N》颜色,《N》尺码,《N》退货数量,《N》成本,《N》原价,《N》现价,《N》结算价,《N》折扣, 《N》登记人,《N》发货操作员,《N》收货操作员 】 【《N》维修单号," + wxno + "】【《N》发货店铺ID," + DepotId + "】【《N》收货店铺ID," + WarehouseNo + @"】 【《N》装箱号," + sendUser + "】【《N》款号," + sku + @"】【《N》款式编号,】【《N》颜色,】 【《N》尺码,】【《N》退货数量,1】【《N》成本,0】【《N》原价,0】【《N》现价,0】【《N》结算价,0】 【《N》折扣,0】【《N》登记人," + sendUser + "】【《N》发货操作员," + sendUser + "】【《N》收货操作员,】"; DataTable dtRtn = dbhGP.GetDataBySP("[API_Bill].[Thd_Info]", paramObj, paramVal); if (dtRtn != null) { if (dtRtn.Rows.Count > 0) { string result = dtRtn.Rows[0]["FLAG"].ToString(); if (result.ToUpper() == "TRUE") { string returnNo = dtRtn.Rows[0]["outindentid"].ToString(); this.dtList.Columns.Add("ReturnNo"); this.dtList.Rows[0]["ReturnNo"] = returnNo; //调用收货的过程 paramVal[3] = @"【操作类型,NEW】【实体,收货】 【新增内容,退货单号,发货店铺ID,收货店铺ID,装箱号,款号,款式编号,颜色,尺码,退货数量,成本, 原价,现价,结算价,折扣,登记人,发货操作员,收货操作员】 【条件内容,《N》退货单号,《N》发货店铺ID,《N》收货店铺ID,《N》装箱号,《N》款号,《N》款式编号, 《N》颜色,《N》尺码,《N》退货数量,《N》成本,《N》原价,《N》现价,《N》结算价,《N》折扣,《N》登记人, 《N》发货操作员,《N》收货操作员 】【《N》退货单号," + returnNo + "】【《N》发货店铺ID," + DepotId + @"】 【《N》收货店铺ID," + WarehouseNo + "】【《N》装箱号," + sendUser + "】【《N》款号," + sku + @"】【《N》款式编号,】 【《N》颜色,】【《N》尺码,】【《N》退货数量,1】【《N》成本,0】【《N》原价,0】【《N》现价,0】 【《N》结算价,0】【《N》折扣,0】【《N》登记人," + CreateUser + "】【《N》发货操作员,】【《N》收货操作员," + sendUser + "】"; DataTable dtClt = dbhGP.GetDataBySP("[API_Bill].[Thd_Info]", paramObj, paramVal); if (dtClt != null) { if (dtClt.Rows.Count > 0) { if (dtClt.Rows[0]["FLAG"].ToString().ToUpper() == "TRUE") { DataTable dtHead = this.dtList.Copy(); dtHead.TableName = "[dbo].[SPWX_Headquarters]"; dtMain.TableName = "[dbo].[SPWX_Main]"; dtHist.TableName = "[dbo].[SPWX_Hist]"; DataSet ds = new DataSet(); ds.Tables.Add(dtHead); ds.Tables.Add(dtMain); ds.Tables.Add(dtHist); this.bRst = dbh.UpdateDB("ID", ds); if (this.bRst) { drRow["result"] = true; drRow["message"] = "提交成功"; } else { drRow["result"] = false; drRow["message"] = "提交失败"; }; } else { string msg = dtRtn.Rows[0]["message"].ToString(); drRow["result"] = false; drRow["message"] = msg; }; } else { drRow["result"] = false; drRow["message"] = "收货单生成失败,请联系信息管理部。"; }; } else { drRow["result"] = false; drRow["message"] = "收货单生成失败,请联系信息管理部。"; }; } else { string msg = dtRtn.Rows[0]["message"].ToString(); drRow["result"] = false; drRow["message"] = msg; }; } else { drRow["result"] = false; drRow["message"] = "退货单生成失败,请联系信息管理部。"; }; } else { drRow["result"] = false; drRow["message"] = "退货单生成失败,请联系信息管理部。"; }; } else { DataTable dtHead = this.dtList.Copy(); dtHead.TableName = "[dbo].[SPWX_Headquarters]"; dtMain.TableName = "[dbo].[SPWX_Main]"; dtHist.TableName = "[dbo].[SPWX_Hist]"; DataSet ds = new DataSet(); ds.Tables.Add(dtHead); ds.Tables.Add(dtMain); ds.Tables.Add(dtHist); this.bRst = dbh.UpdateDB("ID", ds); if (this.bRst) { drRow["result"] = true; drRow["message"] = "提交成功"; } else { drRow["result"] = false; drRow["message"] = "提交失败"; }; }; } else { drRow["result"] = false; drRow["message"] = "在初判表中已经无法找到该维修单号,请确认。"; }; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); }
//HWA #region 检查快递单号 private void CheckExpNo() { DataTable dtChk = this.dtList.Copy(); DataTable dtRst = new DataTable(); string ExpNo = ""; string WxNo = ""; if (dtChk.Columns.Contains("ExpNo")) { ExpNo = dtChk.Rows[0]["ExpNo"].ToString(); ExpNo = FilterSpecial(ExpNo); ExpNo = ExpNo.ToUpper(); } else if (dtChk.Columns.Contains("WxNo")) { WxNo = dtChk.Rows[0]["WxNo"].ToString(); WxNo = FilterSpecial(WxNo); }; string DepotId = base.m_hzyMessage.User_Name_CN.Split('_')[0]; string select = ""; bool b = Convert.ToChar(DepotId.Substring(0, 1)) <= 'Z'; if (b)//店铺 { if (ExpNo.Length > 0) { select = @"SELECT T1.[ID] ,T1.[WXNo] ,T1.[Status] ,T1.[ModifyTime] ,T1.[ModifyUser] FROM [dbo].[SPWX_Main] T1 LEFT JOIN [dbo].[SPWX_Headquarters] T2 ON T1.[WXNo] = T2.[WXNo] WHERE T1.[Status] = 45 AND T1.[DepotId] = '" + DepotId + "' AND T2.[ExpNo] = @Param0"; } else if (WxNo.Length > 0) { select = @"SELECT T1.[ID] ,T1.[WXNo] ,T1.[Status] ,T1.[ModifyTime] ,T1.[ModifyUser] FROM [dbo].[SPWX_Main] T1 LEFT JOIN [dbo].[SPWX_Headquarters] T2 ON T1.[WXNo] = T2.[WXNo] WHERE T1.[Status] = 45 AND T1.[DepotId] = '" + DepotId + "' AND T1.[WxNo] = @Param0"; }; } else { if (ExpNo.Length > 0) { select = @"SELECT [ID] ,[WXNo] ,[Status] ,[ModifyTime] ,[ModifyUser] FROM [dbo].[SPWX_Main] WHERE [Status] = '16' AND [ExpressNo] = @Param0"; } else if(WxNo.Length >0) { select = @"SELECT [ID] ,[WXNo] ,[Status] ,[ModifyTime] ,[ModifyUser] FROM [dbo].[SPWX_Main] WHERE [Status] = '16' AND [WXNo] = @Param0"; }; }; DBHandle dbh = new DBHandle("SPWX"); if (ExpNo.Length > 0) { dtRst = dbh.GetData(select, new object[1] { ExpNo }); } else if (WxNo.Length > 0) { dtRst = dbh.GetData(select, new object[1] { WxNo }); }; if (dtRst.Rows.Count > 0) { DataTable dtHist = dbh.GetTabHead("[dbo].[SPWX_Hist]"); for (int i = 0; i < dtRst.Rows.Count; i++) { //交易表 DataRow drHist = dtHist.NewRow(); drHist["WXNo"] = dtRst.Rows[i]["WXNo"].ToString(); drHist["BeforeStatus"] = dtRst.Rows[i]["Status"].ToString(); if (b) { drHist["AfterStatus"] = "50"; drHist["Content"] = "操作内容:店铺已经收货"; } else { drHist["AfterStatus"] = "20"; drHist["Content"] = "操作内容:维修单已经收货"; }; drHist["ModifyTime"] = this.timeNow; drHist["ModifyUser"] = base.m_hzyMessage.User_Name; dtHist.Rows.Add(drHist); //主表 if (b) { dtRst.Rows[i]["Status"] = "50"; } else { dtRst.Rows[i]["Status"] = "20"; }; dtRst.Rows[i]["ModifyTime"] = this.timeNow; dtRst.Rows[i]["ModifyUser"] = base.m_hzyMessage.User_Name; }; dtRst.TableName = "[dbo].[SPWX_Main]"; dtHist.TableName = "[dbo].[SPWX_Hist]"; DataSet ds = new DataSet(); ds.Tables.Add(dtRst); ds.Tables.Add(dtHist); this.bRst = dbh.UpdateDB("ID", ds); }; DataRow drRow = this.dt_Return.NewRow(); if (this.bRst) //if (dt.Rows.Count >0) { drRow["result"] = true; drRow["message"] = "成功"; } else { drRow["result"] = false; drRow["message"] = "失败"; }; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); }
private void CrtNewWX() { DBHandle dbh = new DBHandle("SPWX"); DataRow drRow = this.dt_Return.NewRow(); DataTable dtCp = this.dtList.Copy(); if (dtCp.Rows[0]["ExpressNo"].ToString().Length > 0) { dtCp.Rows[0]["ExpressNo"] = dtCp.Rows[0]["ExpressNo"].ToString().ToUpper(); }; DataTable dtHist = dbh.GetData( "SELECT TOP 0 * FROM [dbo].[SPWX_Hist] WITH(NOLOCK)", new object[] { }); DataRow dr = dtHist.NewRow(); dtCp.Columns.Add("WXNo"); dtCp.Columns.Add("Status"); dtCp.Columns.Add("BackDate"); dtCp.Columns.Add("WxStatus"); dtCp.Columns.Add("CreateUser"); dtCp.Columns.Add("ModifyUser"); int iMax = getMaxWXNo(); if (iMax != 0) { dtCp.Rows[0]["WXNo"] = iMax.ToString(); dtCp.Rows[0]["Status"] = "16"; dtCp.Rows[0]["BackDate"] = this.timeNow; dtCp.Rows[0]["CreateUser"] = base.m_hzyMessage.User_Name; dtCp.Rows[0]["ModifyUser"] = base.m_hzyMessage.User_Name; if (dtCp.Columns.Contains("VIPID")) { dtCp.Rows[0]["WxStatus"] = "client"; } else { if (dtCp.Columns.Contains("VIPName")) { if (dtCp.Rows[0]["VIPName"].ToString().Length > 0) { dtCp.Rows[0]["WxStatus"] = "client"; } else { dtCp.Rows[0]["WxStatus"] = "unsell"; }; } else { dtCp.Rows[0]["WxStatus"] = "unsell"; }; }; //历史记录 dr["WXNo"] = iMax.ToString(); dr["BeforeStatus"] = "15"; dr["AfterStatus"] = "16"; dr["Content"] = "操作内容:创建维修单,并发货."; dr["ModifyUser"] = base.m_hzyMessage.User_Name; dtHist.Rows.Add(dr); dtCp.TableName = "[dbo].[SPWX_Main]"; dtHist.TableName = "[dbo].[SPWX_Hist]"; DataSet ds = new DataSet(); ds.Tables.Add(dtCp); ds.Tables.Add(dtHist); this.bRst = dbh.UpdateDB("ID", ds); if (this.bRst) { drRow["result"] = true; drRow["message"] = "提交成功"; } else { drRow["result"] = false; drRow["message"] = "提交失败"; }; } else { drRow["result"] = false; drRow["message"] = "提交失败"; }; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); }
private void SaveExp() { DataRow drRow = this.dt_Return.NewRow(); DataTable dt = this.dtList.Copy(); string wxno = ""; int count = dt.Rows.Count; object[] o = new object[count]; for (int i = 0; i < count; i++) { if(i !=count-1) { wxno += "@Param" + i + ","; } else if (i == count - 1) { wxno += "@Param" + i; }; o[i] = dt.Rows[i]["Wxno"].ToString(); }; string headp = @" SELECT [Id] ,[ExpName] ,[ExpNo] ,[ModifyUser] ,[ModifyTime] FROM [dbo].[SPWX_Headquarters] WITH(NOLOCK) WHERE WXNO in (" + wxno + ")"; string main = @" SELECT [ID] ,[Wxno] ,[Status] ,[ModifyTime] ,[ModifyUser] FROM [dbo].[SPWX_Main] WITH(NOLOCK) WHERE ([Status] = 40 or [Status] = 26) AND WXNO IN ("+wxno+")"; string hist = @" SELECT TOP 0 * FROM [dbo].[SPWX_Hist] WITH(NOLOCK)"; try { DBHandle dbh = new DBHandle("SPWX"); DataTable dtHp = dbh.GetData(headp, o); DataTable dtMa = dbh.GetData(main, o); DataTable dtHi = dbh.GetData(hist, new object[0]); if (dtHi != null && dtHp != null && dtMa != null) { // if(dtHp.Rows.Count == dt.Rows.Count) { for (int i = 0; i < dtHp.Rows.Count; i++) { dtHp.Rows[i]["ExpName"] = dt.Rows[i]["ExpName"]; dtHp.Rows[i]["ExpNo"] = dt.Rows[i]["ExpNo"].ToString().ToUpper(); dtHp.Rows[i]["ModifyUser"] = base.hzyMessage.User_Name; dtHp.Rows[i]["ModifyTime"] = timeNow; }; }; // if (dtMa.Rows.Count == dt.Rows.Count) { for (int i = 0; i < dtMa.Rows.Count; i++) { DataRow dr = dtHi.NewRow(); dr["WXNo"] = dtMa.Rows[i]["Wxno"]; dr["BeforeStatus"] = dtMa.Rows[i]["Status"]; dr["AfterStatus"] = "45"; dr["Content"] = "总部已经发货"; dr["ModifyTime"] = timeNow; dr["ModifyUser"] = base.hzyMessage.User_Name; dtHi.Rows.Add(dr); dtMa.Rows[i]["Status"] = "45"; dtMa.Rows[i]["ModifyUser"] = base.hzyMessage.User_Name; dtMa.Rows[i]["ModifyTime"] = timeNow; }; }; dtHp.TableName = "[dbo].[SPWX_Headquarters]"; dtMa.TableName = "[dbo].[SPWX_Main]"; dtHi.TableName = "[dbo].[SPWX_Hist]"; DataSet ds = new DataSet(); ds.Tables.Add(dtHp); ds.Tables.Add(dtMa); ds.Tables.Add(dtHi); this.bRst = dbh.UpdateDB("ID", ds); if (this.bRst) { drRow["result"] = true; drRow["message"] = "提交成功"; } else { drRow["result"] = false; drRow["message"] = "提交失败"; }; }; } catch (Exception ex) { drRow["result"] = false; drRow["message"] = ex.Message; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); throw; }; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); }
private void UpdateFix() { string wxno = this.dtList.Rows[0]["wxno"].ToString(); string beforeSta = ""; try { DBHandle dbh = new DBHandle("SPWX"); string Headp = @" SELECT * FROM [dbo].[SPWX_Headquarters] WITH(NOLOCK) WHERE [WXNo] = @Param0"; string Main = @" SELECT [ID] ,[Status] ,[ModifyTime] ,[ModifyUser] FROM [dbo].[SPWX_Main] WITH(NOLOCK) WHERE [WXNo] = @Param0"; string Hist = @" SELECT TOP 0 * FROM [dbo].[SPWX_Hist] WITH(NOLOCK)"; DataTable dtHp = dbh.GetData(Headp, new object[1] { wxno }); DataTable dtMain = dbh.GetData(Main, new object[1] { wxno }); DataTable dtHi = dbh.GetData(Hist, new object[0]); if (dtHp != null && dtMain != null && dtHi != null) { if (dtHp.Rows.Count > 0) { dtHp.Rows[0]["FirstOrigin"] = this.dtList.Rows[0]["FirstOrigin"]; dtHp.Rows[0]["FirstQust"] = this.dtList.Rows[0]["FirstQust"]; dtHp.Rows[0]["FirstPhen"] = this.dtList.Rows[0]["FirstPhen"]; dtHp.Rows[0]["SecondOrigin"] = this.dtList.Rows[0]["SecondOrigin"]; dtHp.Rows[0]["SecondQust"] = this.dtList.Rows[0]["SecondQust"]; dtHp.Rows[0]["SecondPhen"] = this.dtList.Rows[0]["SecondPhen"]; dtHp.Rows[0]["FirstDecide"] = this.dtList.Rows[0]["FirstDecide"]; dtHp.Rows[0]["SecondDecide"] = this.dtList.Rows[0]["SecondDecide"]; dtHp.Rows[0]["ThirdDecide"] = this.dtList.Rows[0]["ThirdDecide"]; dtHp.Rows[0]["FixLength"] = this.dtList.Rows[0]["FixLength"]; //dtHp.Rows[0]["FixPlace"] = this.dtList.Rows[0]["FixPlace"]; dtHp.Rows[0]["SecFixLen"] = this.dtList.Rows[0]["SecFixLen"]; //dtHp.Rows[0]["SecFixPlace"] = this.dtList.Rows[0]["SecFixPlace"]; dtHp.Rows[0]["ModifyUser"] = base.m_hzyMessage.User_Name; dtHp.Rows[0]["ModifyTime"] = timeNow; }; if (dtMain.Rows.Count > 0) { dtMain.Rows[0]["ModifyTime"] = timeNow; dtMain.Rows[0]["ModifyUser"] = base.m_hzyMessage.User_Name; beforeSta = dtMain.Rows[0]["Status"].ToString(); }; DataRow dr = dtHi.NewRow(); dr["WXNo"] = wxno; dr["BeforeStatus"] = beforeSta; dr["AfterStatus"] = beforeSta; dr["Content"] = "进行了维修再判定操作"; dr["ModifyTime"] = timeNow; dr["ModifyUser"] = base.m_hzyMessage.User_Name; dtHi.Rows.Add(dr); if (dtHp.Rows.Count > 0 && dtHi.Rows.Count > 0 && dtMain.Rows.Count > 0) { dtHp.TableName = "[dbo].[SPWX_Headquarters]"; dtMain.TableName = "[dbo].[SPWX_Main]"; dtHi.TableName = "[dbo].[SPWX_Hist]"; DataSet ds = new DataSet(); ds.Tables.Add(dtHp); ds.Tables.Add(dtMain); ds.Tables.Add(dtHi); this.bRst = dbh.UpdateDB("ID", ds); }; }; DataRow drRow = this.dt_Return.NewRow(); if (this.bRst) { drRow["result"] = true; drRow["message"] = "提交成功"; } else{ drRow["result"] = false; drRow["message"] = "提交失败"; }; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); } catch (Exception ex) { DataRow drRow = this.dt_Return.NewRow(); drRow["result"] = false; drRow["message"] = ex.Message; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); }; }
/// <summary> /// logic: /// 1.Update 'finish' field in table [dbo].[SPWX_Headquarters]. /// 2.Update 'status' field in table [dbo].[SPWX_Main]. /// 3.Insert history in [dbo.SPWX_Hist] Table. /// </summary> private void SaveFin() { DataRow drRow = this.dt_Return.NewRow(); string beforeStatus = ""; string wxno = this.dtList.Rows[0]["Wxno"].ToString(); string Headquarters = @" SELECT [Id] ,[IsFinish] ,[FinishMan] ,[FinishDate] ,[FinishPoint] ,[FinishMoney] ,[ModifyUser] ,[ModifyTime] FROM [dbo].[SPWX_Headquarters] WHIT(NOLOCK) WHERE [WXNo] = @Param0"; string Main = @" SELECT [ID] ,[Status] ,[ModifyTime] ,[ModifyUser] FROM [dbo].[SPWX_Main] WHIT(NOLOCK) WHERE [WXNo] = @Param0"; string Hist = @" SELECT TOP 0 * FROM [dbo].[SPWX_Hist] WITH(NOLOCK)"; try { DBHandle dbh = new DBHandle("SPWX"); DataTable dtUp = dbh.GetData(Headquarters, new object[1] { wxno }); DataTable dtMain = dbh.GetData(Main, new object[1] { wxno }); DataTable dtHist = dbh.GetData(Hist, new object[0]); //这里防止对象未初始化. if (dtUp != null && dtMain != null && dtHist != null) { if (dtUp.Rows.Count > 0) { string date = this.dtList.Rows[0]["FinishDate"].ToString(); DateTime datetime = DateTime.Parse(date); dtUp.Rows[0]["IsFinish"] = FilterSpecial(this.dtList.Rows[0]["IsFinish"].ToString()); dtUp.Rows[0]["FinishMan"] = FilterSpecial(this.dtList.Rows[0]["FinishMan"].ToString()); dtUp.Rows[0]["FinishDate"]= datetime; dtUp.Rows[0]["FinishPoint"] = FilterSpecial(this.dtList.Rows[0]["FinishPoint"].ToString()); dtUp.Rows[0]["FinishMoney"] = FilterSpecial(this.dtList.Rows[0]["FinishMoney"].ToString()); dtUp.Rows[0]["ModifyUser"] = base.m_hzyMessage.User_Name; dtUp.Rows[0]["ModifyTime"] = this.timeNow; }; if (dtMain.Rows.Count > 0) { beforeStatus = dtMain.Rows[0]["Status"].ToString(); dtMain.Rows[0]["Status"] = "40"; dtMain.Rows[0]["ModifyTime"] = this.timeNow; dtMain.Rows[0]["ModifyUser"] = base.m_hzyMessage.User_Name; }; DataRow dr = dtHist.NewRow(); dr["Wxno"] = wxno; dr["BeforeStatus"] = beforeStatus; dr["AfterStatus"] = "40"; dr["Content"] = "维修单已经维修完成,结果为:" + FilterSpecial(this.dtList.Rows[0]["IsFinish"].ToString()); dr["ModifyUser"] = base.m_hzyMessage.User_Name; dtHist.Rows.Add(dr); if (dtUp.Rows.Count > 0 && dtMain.Rows.Count > 0) { dtUp.TableName = "[dbo].[SPWX_Headquarters]"; dtMain.TableName = "[dbo].[SPWX_Main]"; dtHist.TableName = "[dbo].[SPWX_Hist]"; DataSet ds = new DataSet(); ds.Tables.Add(dtUp); ds.Tables.Add(dtMain); ds.Tables.Add(dtHist); this.bRst = dbh.UpdateDB("ID", ds); if (this.bRst) { drRow["result"] = true; drRow["message"] = "提交成功"; } else { drRow["result"] = false; drRow["message"] = "提交失败"; }; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); }; }; } catch (Exception ex) { drRow["result"] = false; drRow["message"] = ex.Message; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); }; }