/// <summary> /// 删除返回件 /// </summary> /// <param name="strDJH">单据号</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool DeleteReplace(string strDJH, out string error) { error = ""; try { WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext; var vardata = from a in dataContxt.S_ReplaceAccessory where a.ServiceID == strDJH select a; if (vardata.Count() != 0) { dataContxt.S_ReplaceAccessory.DeleteAllOnSubmit(vardata); } dataContxt.SubmitChanges(); } catch (Exception ex) { error = ex.Message; return(false); } return(true); }
/// <summary> /// 通过单据号删除函电信息 /// </summary> /// <param name="billNo">单据号</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool DeleteByBillNo(string billNo, out string error) { error = ""; try { WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext; var varData = from a in dataContxt.S_AfterService where a.ServiceID == billNo select a; if (varData.Count() != 1) { throw new Exception("单据信息有误!"); } else { dataContxt.S_AfterService.DeleteAllOnSubmit(varData); var varBug = from a in dataContxt.OF_BugMessageInfo where a.ServiceID == billNo select a; dataContxt.OF_BugMessageInfo.DeleteAllOnSubmit(varBug); dataContxt.SubmitChanges(); return(true); } } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 添加返回件 /// </summary> /// <param name="dtAddTb">数据集</param> /// <param name="strDJH">单据号</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool InsertReplace(DataTable dtAddTb, string strDJH, out string error) { error = ""; WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext; try { if (DeleteReplace(strDJH, out error)) { for (int i = 0; i < dtAddTb.Rows.Count; i++) { S_ReplaceAccessory list = new S_ReplaceAccessory(); list.ServiceID = strDJH; list.OldGoodsCode = dtAddTb.Rows[i]["OldGoodsCode"].ToString(); list.OldGoodsName = dtAddTb.Rows[i]["OldGoodsName"].ToString(); list.OldSpec = dtAddTb.Rows[i]["OldSpec"].ToString(); list.OldCvtID = dtAddTb.Rows[i]["OldCvtID"].ToString(); list.Count = Convert.ToInt32(dtAddTb.Rows[i]["Count"].ToString()); list.Unit = dtAddTb.Rows[i]["Unit"].ToString(); list.NewGoodsCode = dtAddTb.Rows[i]["NewGoodsCode"].ToString(); list.NewGoodsName = dtAddTb.Rows[i]["NewGoodsName"].ToString(); list.NewSpec = dtAddTb.Rows[i]["NewSpec"].ToString(); list.NewCvtID = dtAddTb.Rows[i]["NewCvtID"].ToString(); list.NewGoodsID = dtAddTb.Rows[i]["NewGoodsID"].ToString(); list.OldGoodsID = dtAddTb.Rows[i]["OldGoodsID"].ToString(); if (dtAddTb.Rows[i]["BackTime"].ToString() != "") { list.BackTime = Convert.ToDateTime(dtAddTb.Rows[i]["BackTime"].ToString()); } if (dtAddTb.Rows[i]["GiveOutDate"].ToString() != "") { list.GiveOutDate = Convert.ToDateTime(dtAddTb.Rows[i]["GiveOutDate"].ToString()); } dataContxt.S_ReplaceAccessory.InsertOnSubmit(list); } dataContxt.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; return(false); } return(true); }
/// <summary> /// 责任人确认,修改表信息 /// </summary> /// <param name="back">数据集对象</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool UpdateDutyPerson(S_ServiceFeedBack back, out string error) { error = ""; try { WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext; var varData = from a in dataContxt.S_ServiceFeedBack where a.FK_Bill_ID == back.FK_Bill_ID select a; if (varData.Count() != 1) { error = "数据有错误!"; return(false); } else { S_ServiceFeedBack list = varData.Single(); list.Temporary = back.Temporary; list.Analyse = back.Analyse; //list.foreverImplement = back.foreverImplement; list.IsFMEAfile = back.IsFMEAfile; list.IsOpen = back.IsOpen; list.Status = "等待质管检查"; list.DutyPersonDate = DateTime.Now; dataContxt.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; return(false); } return(true); }
/// <summary> /// 责任部门确认,修改表 /// </summary> /// <param name="billID">单据号</param> /// <param name="dutyPerson">责任人</param> /// <param name="finish">完成要求</param> /// <param name="stock">库存产品意见</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool UpdateDutyDept(string billID, string dutyPerson, string finish, string stock, out string error) { error = ""; try { WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext; var varData = from a in dataContxt.S_ServiceFeedBack where a.FK_Bill_ID == billID select a; if (varData.Count() != 1) { error = "数据有错误!"; return(false); } else { S_ServiceFeedBack list = varData.Single(); list.DutyDeptCharge = BasicInfo.LoginID; list.DutyPerson = dutyPerson; list.FinishClaim = finish; list.StockSuggestion = stock; list.DutyDeptChargeDate = ServerTime.Time; list.Status = "等待责任人确认"; dataContxt.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; return(false); } return(true); }
/// <summary> /// 插入WEB 数据库 /// </summary> /// <param name="bill">单据信息</param> /// <param name="error">出错时返回错误信息</param> /// <returns>操作是否成功的标志</returns> public bool InsertWebData(S_CheckOutInDepotBill bill, out string error) { try { error = null; int intListID = GetWebListID(bill.Bill_ID); if (intListID == 0) { error = "数据库无记录"; return(false); } WebSeverDataContext dataContext = WebServerModule.WebDatabaseParameter.WebDataContext; OF_OrderForm_ArrivalInfo lnqArrival = new OF_OrderForm_ArrivalInfo(); lnqArrival.ActualDate = bill.ArriveGoods_Time; lnqArrival.ActuaQuantity = Convert.ToDecimal(bill.DepotManagerAffirmCount); lnqArrival.ConcessionQuantity = Convert.ToDecimal(bill.ConcessionCount); lnqArrival.DestructQuantity = Convert.ToDecimal(bill.DeclareWastrelCount); lnqArrival.EligibilityQuantity = Convert.ToDecimal(bill.EligibleCount); lnqArrival.ListID = intListID; lnqArrival.QualityInfo = bill.QualityInfo; lnqArrival.RejectQuantity = Convert.ToDecimal(bill.ReimbursementCount); lnqArrival.BatchNo = bill.BatchNo; lnqArrival.InBillID = bill.Bill_ID; dataContext.OF_OrderForm_ArrivalInfo.InsertOnSubmit(lnqArrival); dataContext.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 质管部检验,修改表信息 /// </summary> /// <param name="billID">单据号</param> /// <param name="cloes">是否关闭</param> /// <param name="practice">落实情况</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool UpdateZGCheck(string billID, string cloes, string practice, out string error) { error = ""; try { WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext; var varData = from a in dataContxt.S_ServiceFeedBack where a.FK_Bill_ID == billID select a; if (varData.Count() != 1) { error = "数据有错误!"; return(false); } else { S_ServiceFeedBack list = varData.Single(); list.ZGCheckName = BasicInfo.LoginID; list.IsClose = cloes; list.Practicable = practice; list.Status = "单据完成"; list.ZGCheckDate = DateTime.Now; dataContxt.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; return(false); } return(true); }
/// <summary> /// 插入WEB订单 /// </summary> /// <param name="yearAndMonth">操作年月字符串</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>插入成功返回True,插入失败返回False</returns> bool InsertWebOrderForm(string yearAndMonth, out string error) { error = null; BargainInfoServer serverBargainInfo = new BargainInfoServer(); try { WebSeverDataContext dataContext = WebServerModule.WebDatabaseParameter.WebDataContext; //插入订单Bill string strSql = "select distinct 订单号 + '-' + convert(varchar(50),ID) as 订单号 ," + " 合同号 from (select 物品ID,供应商,订单号,到货数,到货日期,合同号, " + " Row_Number()Over(partition by 物品ID,供应商 order by 到货日期) as ID " + " from View_B_WebForOrderFormList as a inner join View_B_WebForAffrimTime as b " + " on a.序号 = b.明细ID where 单据号 = '" + yearAndMonth + "') as a"; DataTable dtBill = GlobalObject.DatabaseServer.QueryInfo(strSql); for (int i = 0; i < dtBill.Rows.Count; i++) { DataRow drBargainInfo = serverBargainInfo.GetBargainInfoDataRow(dtBill.Rows[i]["合同号"].ToString()); OF_OrderFormInfo lnqInfo = new OF_OrderFormInfo(); lnqInfo.OrderFormNumber = dtBill.Rows[i]["订单号"].ToString(); lnqInfo.Provider = drBargainInfo["Provider"].ToString(); lnqInfo.Buyer = drBargainInfo["Buyer"].ToString(); lnqInfo.ProviderLinkMan = drBargainInfo["ProviderLinkman"].ToString(); lnqInfo.ProviderLinkMode = drBargainInfo["LaisonMode"].ToString(); lnqInfo.Remark = drBargainInfo["Remark"].ToString(); lnqInfo.CreateDate = ServerTime.Time; dataContext.OF_OrderFormInfo.InsertOnSubmit(lnqInfo); } //插入订单List strSql = "select 图号型号,物品名称,规格,到货数," + " 订单号 + '-' + convert(varchar(50),ID) as 订单号 ," + " convert(varchar(10), 到货日期,120) + ' 23:59:59' as 到货日期 " + " from (select 图号型号,物品名称,规格,订单号,到货数,到货日期, " + " Row_Number()Over(partition by 物品ID,供应商 order by 到货日期) as ID " + " from View_B_WebForOrderFormList as a " + " inner join View_B_WebForAffrimTime as b " + " on a.序号 = b.明细ID where 单据号 = '" + yearAndMonth + "') as a "; DataTable dtList = GlobalObject.DatabaseServer.QueryInfo(strSql); for (int i = 0; i < dtList.Rows.Count; i++) { OF_OrderFormGoods lnqGoods = new OF_OrderFormGoods(); lnqGoods.OrderFormNumber = dtList.Rows[i]["订单号"].ToString(); lnqGoods.GoodsCode = dtList.Rows[i]["图号型号"].ToString(); lnqGoods.GoodsName = dtList.Rows[i]["物品名称"].ToString(); lnqGoods.Spec = dtList.Rows[i]["规格"].ToString(); lnqGoods.ArriveTime = Convert.ToDateTime(dtList.Rows[i]["到货日期"]); lnqGoods.OrderCount = Convert.ToDecimal(dtList.Rows[i]["到货数"]); dataContext.OF_OrderFormGoods.InsertOnSubmit(lnqGoods); } dataContext.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 质管部确认,修改表信息 /// </summary> /// <param name="billID">单据号</param> /// <param name="ChargeSuggestion">质管部意见</param> /// <param name="dutyDept">责任部门</param> /// <param name="replyTime">要求回复时间</param> /// <param name="appCount">出现次数</param> /// <param name="associatedBillNo">问题相似的关联单据</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool UpdateZGAffirm(string billID, string ChargeSuggestion, string dutyDept, DateTime replyTime, int appCount, string associatedBillNo, out string error) { error = ""; try { WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext; var varData = from a in dataContxt.S_ServiceFeedBack where a.FK_Bill_ID == billID select a; if (varData.Count() != 1) { error = "数据有错误!"; return(false); } else { S_ServiceFeedBack list = varData.Single(); list.ZGChargeSuggestion = ChargeSuggestion; list.DutyDept = dutyDept; list.ReplyTime = replyTime; list.AppearCount = appCount; list.SignatureDate = ServerTime.Time; list.Signature = BasicInfo.LoginID; if (associatedBillNo == null) { list.Status = "等待责任部门确认"; } else { list.Status = "单据完成"; var resultList = from c in dataContxt.S_ServiceFeedBack where c.FK_Bill_ID == associatedBillNo select c; if (resultList.Count() == 1) { S_ServiceFeedBack feedback = resultList.Single(); list.Analyse = feedback.Analyse; //list.foreverImplement = feedback.foreverImplement; list.FinishClaim = feedback.FinishClaim; list.IsFMEAfile = feedback.IsFMEAfile; list.IsOpen = feedback.IsOpen; list.Temporary = feedback.Temporary; list.StockSuggestion = feedback.StockSuggestion; list.SameBillNo = associatedBillNo; list.DutyPerson = feedback.DutyPerson; list.DutyDept = feedback.DutyDept; list.Practicable = feedback.Practicable; list.IsClose = "是"; } } dataContxt.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; return(false); } return(true); }