private void GetVipInfo() { string VipId = this.dtList.Rows[0]["VipId"].ToString(); VipId = FilterSpecial(VipId); //过滤特殊符号 string select = @"SELECT vipname ,mobtel FROM vip_user WITH(NOLOCK) WHERE vipcode = @Param0"; DBHandle dba = new DBHandle("F22GP"); DataTable dt = dba.GetData(select, new object[] { VipId }); this.ds_Return.Tables.Add(dt); }
private void GetExpressInfo() { string select = @"SELECT [Value] ,[Name] FROM [dbo].[SPWX_Dict] WHIT(NOLOCK) WHERE [Type] = 'Express' AND [Status] = '0'"; DBHandle DBH = new DBHandle("SPWX"); DataTable dt = DBH.GetData(select, new object[] { }); this.ds_Return.Tables.Add(dt); }
private void GetPay() { string select = @"SELECT [Value] ,[Name] FROM [dbo].[SPWX_Dict] WITH(NOLOCK) WHERE [Type] = 'charge' AND [Status] = 0"; DBHandle dbh = new DBHandle("SPWX"); DataTable dt = dbh.GetData(select, new object[] { }); ds_Return.Tables.Add(dt); }
/// <summary> /// 这里需要适应单条(搜索)与多条(datagrid) /// </summary> private void GetWXInfo() { DataTable dt = new DataTable(); string where = " WHERE 1=1 "; if (this.dtList.Rows.Count > 0) { this.objVal = new object[this.dtList.Columns.Count]; for(int i = 0; i<this.dtList.Columns.Count;i++) { where += " AND T1." + this.dtList.Columns[i].ColumnName; where += " = @Param" + i; this.objVal[i] = FilterSpecial(this.dtList.Rows[0][i].ToString()); }; }; string select = @"SELECT T1.[ID] ,[WXNo],[DepotId] ,[DepotName],[DepotPhone] ,[DepotTye],[DepotArea] ,[RespName],[RespPhone] ,[StaffNo],[StaffName] ,[StaffPhone],[SKU] ,[BackDate],[Question] ,[VIPID],[VIPName] ,[VIPPhone],[SellDate] ,[Collect],[UrgentLevel] ,T4.[Name] AS [ULName] ,[Express] ,T3.[Name] AS [ExpressName] ,[ExpressNo],[SendAddress] ,[TakeAddress],[TakeMan] ,[TakeManPhone],T1.[Remark] ,T1.[Status] ,T2.[Name] AS [StatusName] ,T1.[WxStatus] ,T5.[Name] AS [WXStName] ,T1.[CreateTime],T1.[ModifyTime] ,[CreateUser],[ModifyUser] FROM [dbo].[SPWX_Main] T1 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T2 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T3 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T4 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T5 WITH(NOLOCK) "; select += where; select += @" AND T1.[Status] = T2.[Value] AND T2.[Type] = 'Status' AND T2.[Status] = 0 AND T1.[Express] = T3.[Value] AND T3.[Type] = 'Express' AND T3.[Status] = 0 AND T1.[UrgentLevel] = T4.[Value] AND T4.[Type] = 'Level' AND T4.[Status] = 0 AND T1.[WxStatus] = T5.[Value] AND T5.[Type] = 'WXType' AND T5.[Status] = 0 ORDER BY T1.[WXNo] Desc"; DBHandle dbh = new DBHandle("SPWX"); dt = dbh.GetData(select, this.objVal); dt.TableName = "WxInfo"; if (dt.Rows.Count == 1) { string sku = dt.Rows[0]["SKU"].ToString(); DataTable dtSup = GetSupplierInfo(sku); dtSup.TableName = "SuppInfo"; this.ds_Return.Tables.Add(dt); this.ds_Return.Tables.Add(dtSup); } else { this.ds_Return.Tables.Add(dt); } }
private void GetHistory() { string WXNo = this.dtList.Rows[0][0].ToString(); WXNo = FilterSpecial(WXNo); string select = @"SELECT DISTINCT [WXNo] ,[AfterStatus] ,T2.[Name] AS [StatusName] ,CONVERT(VARCHAR(200),T1.[ModifyTime],23) AS [ModifyTime] ,[ModifyUser] FROM [dbo].[SPWX_Hist] T1 LEFT JOIN [dbo].[SPWX_Dict] T2 ON T1.[AfterStatus] = T2.[Value] WHERE T1.WXNo = @Param0 "; DBHandle dbh = new DBHandle("SPWX"); DataTable dt = dbh.GetData(select, new object[] { WXNo }); string html = ""; if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (i != dt.Rows.Count - 1) { html += "<li><div class=\"status\">"; html += dt.Rows[i]["StatusName"].ToString(); html += "</div><div class=\"statusDate\">"; html += dt.Rows[i]["ModifyTime"].ToString(); html += "</div></li>"; } else if (i == dt.Rows.Count - 1) { html += "<li style=\"background-image:none\"><div class=\"status\">"; html += dt.Rows[i]["StatusName"].ToString(); html += "</div><div class=\"statusDate\">"; html += dt.Rows[i]["ModifyTime"].ToString(); html += "</div></li>"; break; }; }; }; }; DataRow drRow = this.dt_Return.NewRow(); drRow["result"] = true; drRow["message"] = html; this.dt_Return.Rows.Add(drRow); this.ds_Return.Tables.Add(this.dt_Return); }
private void GetQuestion() { string type = this.dtList.Rows[0][0].ToString(); type = FilterSpecial(type); string select = @"SELECT [Value] ,[Name] FROM [dbo].[SPWX_WXDict] WHERE [FartherVal] = @Param0"; DBHandle dbh = new DBHandle("SPWX"); DataTable dt = dbh.GetData(select, new object[] { type }); this.ds_Return.Tables.Add(dt); }
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); }; }
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 GetFinInfo() { string IsFin = @"SELECT [Value] ,[Name] FROM [dbo].[SPWX_Dict] WHERE [Type] = 'finRst' AND [Status] = '0'"; string FinMan = @"SELECT [Value] ,[Name] FROM [dbo].[SPWX_Dict] WHERE [Type] = 'FinMan' AND [Status] = '0'"; string FinPntMon = @"SELECT T1.[Value] AS Point ,T1.[Name] AS PointName ,T2.[Name] AS MoneyName FROM [dbo].[SPWX_WXDict] T1 LEFT JOIN [dbo].[SPWX_WXDict] T2 ON T1.HowMuch = T2.Lev AND T2.[Type] = 'money' WHERE T1.[Type] = 'finish'"; string ExpCom = @"SELECT [Value] ,[Name] FROM [dbo].[SPWX_Dict] WHERE [Type] = 'Express' AND [Status] = 0"; DBHandle dbh = new DBHandle("SPWX"); DataTable dtIsFin = dbh.GetData(IsFin, new object[0]); DataTable dtFinMan = dbh.GetData(FinMan, new object[0]); DataTable dtPntMon = dbh.GetData(FinPntMon, new object[0]); DataTable dtExpCom = dbh.GetData(ExpCom, new object[0]); dtIsFin.TableName = "dtIsFin"; dtFinMan.TableName = "dtFinMan"; dtPntMon.TableName = "dtPntMon"; dtExpCom.TableName = "dtExpCom"; this.ds_Return.Tables.Add(dtIsFin); this.ds_Return.Tables.Add(dtFinMan); this.ds_Return.Tables.Add(dtPntMon); this.ds_Return.Tables.Add(dtExpCom); }
/// <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); }; }
private void GetWXListDg(string where,object[] o) { DataTable dtData = new DataTable(); DataTable dtCount = new DataTable(); dtData.TableName = "dtData"; dtCount.TableName = "dtCount"; string queryTable = @" FROM [dbo].[SPWX_Main] T2 WITH(NOLOCK) LEFT JOIN [dbo].[SPWX_Headquarters] T1 WITH(NOLOCK) ON T1.WXNo = T2.WXno LEFT JOIN [dbo].[SPWX_WXDict] T3 WITH(NOLOCK) ON T1.FirstPhen = T3.Value AND T3.[Type] = 'nature' LEFT JOIN [dbo].[SPWX_WXDict] T4 WITH(NOLOCK) ON T1.FirstQust = T4.Value AND T4.[Type] = 'origin' LEFT JOIN [dbo].[SPWX_WXDict] T5 WITH(NOLOCK) ON T1.FirstPhen = T5.Value AND T5.[Type] = 'phenomenon' LEFT JOIN [dbo].[SPWX_WXDict] T6 WITH(NOLOCK) ON T1.SecondOrigin = T6.Value AND T6.[Type] = 'nature' LEFT JOIN [dbo].[SPWX_WXDict] T7 WITH(NOLOCK) ON T1.SecondQust = T7.Value AND T7.[Type] = 'origin' LEFT JOIN [dbo].[SPWX_WXDict] T8 WITH(NOLOCK) ON T1.SecondPhen = T8.Value AND T8.[Type] = 'phenomenon' LEFT JOIN [dbo].[SPWX_Dict] T9 WITH(NOLOCK) ON T1.DecideRst = T9.Value AND T9.[Type] = 'result' LEFT JOIN [dbo].[SPWX_Dict] T10 WITH(NOLOCK) ON T1.Department = T10.Value AND T10.[Type] = 'blame' LEFT JOIN [dbo].[SPWX_Dict] T11 WITH(NOLOCK) ON T1.Warehouse = T10.Value AND T11.[Type] = 'degrade' LEFT JOIN [dbo].[SPWX_Dict] T12 WITH(NOLOCK) ON T1.FixType = T12.Value AND T12.[Type] = 'maintainway' LEFT JOIN [dbo].[SPWX_Dict] T13 WITH(NOLOCK) ON T1.Cost = T13.Value AND T13.[Type] = 'charge' LEFT JOIN [dbo].[SPWX_Dict] T14 WITH(NOLOCK) ON T2.WXStatus = T14.Value AND T14.[Type] = 'WXType' LEFT JOIN [dbo].[SPWX_Dict] T15 WITH(NOLOCK) ON T2.[Status] = T15.Value AND T15.[Type] = 'Status' LEFT JOIN [dbo].[SPWX_WXDict] T16 WITH(NOLOCK) ON T1.FirstOrigin = T16.Value AND T16.[Type] = 'nature' LEFT JOIN [dbo].[SPWX_Dict] T17 WITH(NOLOCK) ON T2.[Express] = T17.Value AND T17.[Type] = 'Express' LEFT JOIN [dbo].[SPWX_Dict] T18 WITH(NOLOCK) ON T1.[FinishMan] = T18.Value AND T18.[Type] = 'FinMan' LEFT JOIN [dbo].[SPWX_WXDict] T19 WITH(NOLOCK) ON T1.[FinishPoint] = T19.Value AND T19.[Type] = 'finish' LEFT JOIN [dbo].[SPWX_Dict] T20 WITH(NOLOCK) ON T2.[UrgentLevel] = T20.Value AND T20.[Type] = 'Level' LEFT JOIN [dbo].[SPWX_Dict] T21 WITH(NOLOCK) ON T1.[ExpName] = T21.Value AND T21.[Type] = 'Express' "; string select = @" SELECT ROW_NUMBER() OVER (ORDER BY T2.[ModifyTime]) AS RowNumber ,T1.[Id] ,T2.[WXNo] ,T2.[WxPath] ,T2.[SKU] ,T2.[Status] ,T15.[Name] AS [StatusName] ,T2.[WxStatus] ,T14.[Name] AS [WXSTName] ,T2.[WarehouseNo] ,T2.[WarehouseName] ,T2.[Remark] ,T2.[RespName] ,T2.[RespPhone] ,T2.[StaffName] ,T2.[StaffPhone] ,T2.[DepotArea] ,T2.[DepotName] ,T2.[DepotPhone] ,T2.[DepotId] ,T2.[UrgentLevel] ,T20.[Remark] AS ULName ,T2.[VIPID] ,T2.[VIPName] ,T2.[VIPPhone] ,T2.[Express] ,T2.[SendAddress] ,T2.[TakeAddress] ,T17.[Name] AS [DpExpName] ,T2.[ExpressNo] AS [DpExpNo] ,T2.[TakeMan] ,T2.[TakeManPhone] ,T1.[ExpName] ,T21.[Name] AS [ZBExpName] ,T1.[ExpNo] AS [ZBExpNo] ,CASE T2.[Collect] WHEN 'yes' THEN '愿意' WHEN 'no' THEN '不愿意' END AS [Collect] ,CONVERT(varchar, T2.[BackDate], 23) AS [BackDate] ,T2.[Question] ,[SupplierId] ,[SupplierName] ,[FirstOrigin] ,T16.[Name] AS [FOName] ,[FirstQust] ,T4.[Name] AS [FQName] ,[FirstPhen] ,T5.[Name] AS [FPName] ,[SecondOrigin] ,T6.[Name] AS [SOName] ,[SecondQust] ,T7.[Name] AS [SQName] ,[SecondPhen] ,T8.[Name] AS [SPName] ,[FirstDecide] ,[SecondDecide] ,[ThirdDecide] ,[FixLength] ,[SecFixLen] ,[SecFixPlace] ,[FixPlace] ,[SealNo] ,[aaa] ,[DecideRst] ,T9.[Name] AS [DRName] ,[Department] ,T10.[Name] AS [DMName] ,[Warehouse] ,T11.[Name] AS [WHName] ,[ReturnNo] ,[FixType] ,T12.[Name] AS [FTName] ,[Cost] ,T13.[Name] AS [CTName] ,ISNULL([FixNeedTime],'无') AS [FixNeedTime] ,ISNULL([FixNeedMoney],'无') AS [FixNeedMoney] ,T1.[FinishMan] ,T18.[Name] AS [FinManName] ,T1.[IsFinish] ,CONVERT(varchar(100), T1.[FinishDate], 23) AS [FinishDate] ,T1.[FinishPoint] ,T19.[Name] AS [FinPntName] ,T1.[FinishMoney] ,T1.[ModifyTime] " + queryTable + where; string queryData = "SELECT TOP " + m_hzyPageInfo.PageRowCount + " * FROM ( "; string queryCount = "SELECT Count(1) AS RowNumber " + queryTable; queryCount += where; queryData += select; queryData += " ) A WHERE RowNumber > " + m_hzyPageInfo.PageRowCount * (m_hzyPageInfo.Page - 1); //获取行数 DBHandle dbh = new DBHandle("SPWX"); dtCount = dbh.GetData(queryCount, o); dtData = dbh.GetData(queryData, o); this.ds_Return.Tables.Add(dtData); this.ds_Return.Tables.Add(dtCount); }
private DataTable GetSupplierInfo(string SKU) { string sku = SKU; sku = FilterSpecial(sku); DBHandle dbh = 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] = "【操作类型,GET】【实体,J_Supplier】" +"【返回内容,供应商ID,供应商简称,供应商全称】" +"【条件内容,《W》款号】【《W》款号,"+sku+"】"; //used "[API_Product].[GetProdInfo]" sp in 200.120. DataTable dt = dbh.GetDataBySP("[API_Product].[GetProdInfo]", paramObj, paramVal); return dt; }
private DataTable GetMoneyDay(string value) { string select = @"SELECT T2.[Value] AS [Money] ,T3.[Value] AS [Day] FROM [dbo].[SPWX_WXDict] T1 LEFT JOIN [dbo].[SPWX_WXDict] T2 ON T1.HowMuch = T2.[Lev] AND T2.[Type] = 'money' LEFT JOIN [dbo].[SPWX_WXDict] T3 ON T1.[Day] = T3.[Lev] AND T3.[Type] = 'day' WHERE T1.[Value] = @Param0"; DBHandle dbh = new DBHandle("SPWX"); DataTable dt = dbh.GetData(select, new object[] { value }); return dt; }
private void GetDataGrid(string Screen) { DataTable dtData = new DataTable(); DataTable dtCount = new DataTable(); dtData.TableName = "dtData"; dtCount.TableName = "dtCount"; string DepotId = base.m_hzyMessage.User_Name_CN.Split('_')[0]; string where = ""; string queryPage = ""; string queryData = ""; if (Screen.Length == 0) { where = "WHERE T1.[DepotId] = @Param0 "; } else { where = "WHERE T1.[DepotId] = @Param0 "; where += " AND (T1.[WXNo] = @Param1 OR T1.[SKU] = @Param2) "; }; string select = @"SELECT ROW_NUMBER() OVER (ORDER BY T1.[ModifyTime] DESC) AS RowNumber ,T1.[ID] ,[WXNo],[WxPath],[DepotId] ,[DepotName],[DepotPhone] ,[DepotTye],[DepotArea] ,[RespName],[RespPhone] ,[StaffNo],[StaffName] ,[StaffPhone],[SKU] ,[BackDate],[Question] ,[VIPID],[VIPName] ,[VIPPhone],[SellDate] ,[Collect] ,[UrgentLevel] ,T4.[Name] AS [ULName] ,[Express] ,T3.[Name] AS [ExpressName] ,[ExpressNo],[SendAddress] ,[TakeAddress],[TakeMan] ,[TakeManPhone],T1.[Remark] ,T1.[Status] ,T2.[Name] AS [StatusName] ,T1.[WxStatus] ,T5.[Name] AS [WXStName] ,T1.[CreateTime],T1.[ModifyTime] ,[CreateUser],[ModifyUser] FROM [dbo].[SPWX_Main] T1 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T2 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T3 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T4 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T5 WITH(NOLOCK) "; select += where; select += @" AND T1.[Status] = T2.[Value] AND T2.[Type] = 'Status' AND T2.[Status] = 0 AND T1.[Express] = T3.[Value] AND T3.[Type] = 'Express' AND T3.[Status] = 0 AND T1.[UrgentLevel] = T4.[Value] AND T4.[Type] = 'Level' AND T4.[Status] = 0 AND T1.[WxStatus] = T5.[Value] AND T5.[Type] = 'WXType' AND T5.[Status] = 0 "; DBHandle dbh = new DBHandle("SPWX"); queryPage = @"SELECT Count(1) AS page FROM [dbo].[SPWX_Main] T1 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T2 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T3 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T4 WITH(NOLOCK) ,[dbo].[SPWX_Dict] T5 WITH(NOLOCK) " + where; queryPage += @" AND T1.[Status] = T2.[Value] AND T2.[Type] = 'Status' AND T2.[Status] = 0 AND T1.[Express] = T3.[Value] AND T3.[Type] = 'Express' AND T3.[Status] = 0 AND T1.[UrgentLevel] = T4.[Value] AND T4.[Type] = 'Level' AND T4.[Status] = 0 AND T1.[WxStatus] = T5.[Value] AND T5.[Type] = 'WXType' AND T5.[Status] = 0"; queryData = @"SELECT TOP " + m_hzyPageInfo.PageRowCount + @" * FROM ( "; queryData += select; queryData += @" ) A WHERE RowNumber > " + m_hzyPageInfo.PageRowCount * (m_hzyPageInfo.Page - 1); queryData += " ORDER BY A.[WXNo] Desc"; if (Screen.Length == 0)//店铺无条件查询 { dtCount = dbh.GetData(queryPage, new object[1] { DepotId }); dtData = dbh.GetData(queryData, new object[1] { DepotId }); } else if (Screen.Length > 0)//店铺有条件查询 { dtCount = dbh.GetData(queryPage, new object[3] { DepotId, Screen, Screen }); dtData = dbh.GetData(queryData, new object[3] { DepotId, Screen, Screen }); }; this.ds_Return.Tables.Add(dtData); this.ds_Return.Tables.Add(dtCount); }
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 GetSKUCheck() { string VipId = this.dtList.Rows[0]["VipId"].ToString(); string SKU = this.dtList.Rows[0]["SKU"].ToString(); string DepotId = base.m_hzyMessage.User_Name_CN.Split('_')[0]; DataTable dtChk = new DataTable(); DataTable dtRst = new DataTable(); dtRst.Columns.Add("Result"); dtRst.Columns.Add("Msg"); dtRst.Columns.Add("Date"); //数据清洗 VipId = FilterSpecial(VipId); SKU = FilterSpecial(SKU); bool b = Convert.ToChar(DepotId.Substring(0, 1)) <= 'Z'; if (b) { DBHandle DBH = new DBHandle("CUSF22"); //调用存储过程 dtChk = DBH.GetDataBySP( "dbo.SP_AftermarketRepairs_Check", new object[3] { "clothingid", "depotid", "vipcode" }, new object[3] { SKU, DepotId, VipId }); if (dtChk != null) { if (dtChk.Rows.Count > 0) { string result = dtChk.Rows[0]["Result"].ToString(); string[] strRst = result.Split(','); //account strRst: //strRst[0] = 0,无经营权,strRst[0] = 1,有经营权 //strRst[1] = 0,顾客未购买,strRst[1] = 1,顾客有购买 //logic: //1.判断strRst[0]=0,直接返回结果 //2.strRst[0] = 1,继续判断顾客 //3.strRst[1] = 0,返回无购买记录 //4.strRst[1] = 1,返回购买记录 if (Int32.Parse(strRst[0]) == 0) { DataRow dr = dtRst.NewRow(); dtRst.Rows[0]["Result"] = false; dtRst.Rows[0]["Msg"] = "此登陆帐号,无该品牌经营权。请更换相应帐号!"; dtRst.Rows[0]["Date"] = ""; } else { if (Int32.Parse(strRst[1]) == 0) { DataRow dr = dtRst.NewRow(); dr["Result"] = false; dr["Msg"] = "该顾客未购买此款衣服,请确认款号是否正确!"; dr["Date"] = ""; dtRst.Rows.Add(dr); } else { DataRow dr = dtRst.NewRow(); dr["Result"] = true; dr["Msg"] = "验证通过,可以维修."; dr["Date"] = dtChk.Rows[0]["sure_date"]; dtRst.Rows.Add(dr); }; }; } else { DataRow dr = dtRst.NewRow(); dr["Result"] = false; dr["Msg"] = "验证失败,请再次尝试!"; dr["Date"] = ""; dtRst.Rows.Add(dr); }; } else { DataRow dr = dtRst.NewRow(); dr["Result"] = false; dr["Msg"] = "验证失败,请再次尝试!"; dr["Date"] = ""; dtRst.Rows.Add(dr); }; } else { DataRow dr = dtRst.NewRow(); dr["Result"] = false; dr["Msg"] = "只有店铺才可以使用此功能!"; dr["Date"] = ""; dtRst.Rows.Add(dr); }; this.ds_Return.Tables.Add(dtRst); }
/// <summary> /// 这是获取维修单号的唯一方法,防止出现同时取最大号的情况 /// 使用的技术叫做: Double check Lock /// </summary> /// <returns>快递单号,如果是0则表示生成失败</returns> #region 获取最大维修单号 private static int getMaxWXNo() { int iRst = 0; if (dbhle == null) { lock (syncRoot) { if (dbhle == null) { dbhle = new DBHandle("SPWX"); string select = @"SELECT [ID],[Value] FROM [dbo].[SPWX_Dict] WHERE Type = 'MaxWxNo'"; DataTable dtMax = dbhle.GetData(select, new object[0]); int iMax = Int32.Parse(dtMax.Rows[0][1].ToString()); iRst = ++iMax; dtMax.Rows[0][1] = iRst.ToString(); bool b = dbhle.Update("[dbo].[SPWX_Dict]", "ID", dtMax); if (!b) { iRst = 0; }; }; dbhle = null; }; }; return iRst; }
private void GetWXDetailInfo() { string WXNO = this.dtList.Rows[0][0].ToString(); //过滤非法字符 WXNO = FilterSpecial(WXNO); string select = @"SELECT * FROM [dbo].[SPWX_Main] WITH(NOLOCK) WHERE [WXNo] = @Param0 "; DataTable dt = new DataTable(); DBHandle dbh = new DBHandle("SPWX"); dt = dbh.GetData(select, new object[] { WXNO }); this.ds_Return.Tables.Add(dt); }
private void GetSalesman() { string DepotId = base.m_hzyMessage.User_Name_CN.ToString(); DepotId = DepotId.Split('_')[0]; string select = @"SELECT [employeeid] ,[names] ,[telephone] FROM [dbo].[j_employee] WITH(NOLOCK) WHERE valid = 0 AND depotid = @Param0"; DBHandle DBH = new DBHandle("F22GP"); DataTable dt = DBH.GetData(select, new object[] { DepotId }); this.ds_Return.Tables.Add(dt); }
//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 DataTable GetWX() { string select = @"SELECT j_depotid ,j_name ,g_address ,m_shopadmin ,m_shoptel FROM [dbo].[V_L0013_BASE] WITH(NOLOCK) WHERE j_name LIKE '%品检维修%'"; DBHandle dbl = new DBHandle("MDM_Market2"); DataTable dt = dbl.GetData(select, new object[] { }); return dt; }
private void GetMaintainway() { string select = @"SELECT [Value] ,[Name] FROM [dbo].[SPWX_Dict] WHERE [Type] = 'maintainway' AND [Status] = 0"; DBHandle dbh = new DBHandle("SPWX"); DataTable dt = dbh.GetData(select, new object[] { }); this.ds_Return.Tables.Add(dt); }
private void GetUrgentLeve() { string select = @"SELECT [Value] ,[Name] FROM [dbo].[SPWX_Dict] WITH(NOLOCK) WHERE [Type] = 'Level' AND [Status] = 0"; DBHandle dba = new DBHandle("SPWX"); DataTable dt = dba.GetData(select, new object[] { }); this.ds_Return.Tables.Add(dt); }
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); }
//Depot #region 获取店铺信息 private void GetDepotInfo() { DataTable dtDepot = new DataTable();//店铺表 DataTable dtWX = new DataTable(); //维修表 string ColumnsName = ""; string Depotid = ""; string select = @"SELECT [j_dq] ,[j_depotid] ,[j_name] ,[j_form] ,[m_shoptel] ,[m_shopadmin] ,[m_shopadminmob] ,[m_supervisor] ,[m_supervisormob] ,[品牌简称] ,[m_salesmannum] ,[g_address] ,[j_merchantid] ,[j_com] ,[j_brand] FROM [dbo].[V_L0013_BASE] WITH(NOLOCK) WHERE [j_depotid] = @Param0"; if (this.dtList.Rows.Count > 0) { if (this.dtList.Columns.Count > 0) { ColumnsName = this.dtList.Columns[0].ColumnName; if (ColumnsName.ToUpper() == "DEPOTID") { Depotid = this.dtList.Rows[0][0].ToString(); } else { Depotid = base.m_hzyMessage.User_Name_CN.Split('_')[0].ToString(); }; } else { Depotid = base.m_hzyMessage.User_Name_CN.Split('_')[0].ToString(); }; } else { Depotid = base.m_hzyMessage.User_Name_CN.Split('_')[0].ToString(); }; DBHandle had = new DBHandle("MDM_Market2"); dtDepot = had.GetData(select, new object[] { Depotid }); //增加维修仓信息 dtDepot.Columns.Add("j_wxid");//维修仓编号 dtDepot.Columns.Add("j_wxname");//维修仓名称 dtDepot.Columns.Add("j_wxaddress");//维修仓地址 dtDepot.Columns.Add("j_wxadmin");//维修对接人 dtDepot.Columns.Add("m_wxshoptel");//维修电话 string brand = dtDepot.Rows[0]["品牌简称"].ToString(); //获取维修信息 dtWX = GetWX(); for (int i = 0; i < dtWX.Rows.Count; i++) { string wxID = dtWX.Rows[i]["j_depotid"].ToString(); wxID = wxID.Substring(0, 1); if (wxID == brand) { dtDepot.Rows[0]["j_wxid"] = dtWX.Rows[i]["j_depotid"].ToString(); dtDepot.Rows[0]["j_wxname"] = dtWX.Rows[i]["j_name"].ToString(); dtDepot.Rows[0]["j_wxaddress"] = dtWX.Rows[i]["g_address"].ToString(); dtDepot.Rows[0]["j_wxadmin"] = dtWX.Rows[i]["m_shopadmin"].ToString(); dtDepot.Rows[0]["m_wxshoptel"] = dtWX.Rows[i]["m_shoptel"].ToString(); break; } else { continue; }; }; this.ds_Return.Tables.Add(dtDepot); }