/// <summary> /// 添加客户 /// </summary> /// <param name="clientInfo">客户信息</param> /// <param name="returnClient">客户信息结果集</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功添加客户信息</returns> public bool AddClient(Client clientInfo, out IQueryable <View_Client> returnClient, out string error) { returnClient = null; error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <Client> table = dataContxt.GetTable <Client>(); var varClient = from c in table where c.ClientCode == clientInfo.ClientCode select c; int sameNoteCount = varClient.Count <Client>(); if (sameNoteCount == 0) { Table <Out_StockInfo> tableOut = dataContxt.GetTable <Out_StockInfo>(); var result = from c in tableOut where c.SecStorageID == clientInfo.ClientCode select c; int count = result.Count <Out_StockInfo>(); if (count == 0) { if (clientInfo.IsSecStorage) { Out_StockInfo stock = new Out_StockInfo(); stock.SecStorageID = clientInfo.ClientCode; stock.SecStorageName = clientInfo.ClientName; stock.Remark = clientInfo.Remark; dataContxt.Out_StockInfo.InsertOnSubmit(stock); } } dataContxt.Client.InsertOnSubmit(clientInfo); dataContxt.SubmitChanges(); return(GetAllClient(out returnClient, out error)); } else { error = "该单据已提交,系统不允许重复提交相同编号的供应商!"; return(false); } } catch (Exception err) { return(SetReturnError(err, out returnClient, out error)); } }
/// <summary> /// 删除AB类零件表信息 /// </summary> /// <param name="id">序号</param> /// <param name="returnTable">返回的AB零件表</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool DeleteGoodsGrade(int id, out IQueryable <View_Q_GoodsGradeTable> returnTable, out string error) { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <Q_GoodsGradeTable> table = dataContxt.GetTable <Q_GoodsGradeTable>(); var delRow = from c in table where c.ID == id select c; foreach (var ei in delRow) { table.DeleteOnSubmit(ei); } dataContxt.SubmitChanges(); GetAllGoodsGradeTable(out returnTable, out error); return(true); } catch (Exception err) { return(SetReturnError(err, out returnTable, out error)); } }
/// <summary> /// 删除Bom附属表 /// </summary> /// <param name="id">序号</param> /// <param name="productType">产品类型</param> /// <param name="assemblyFlag">总成标志</param> /// <param name="returnTable">返回BOM附属表的信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>删除成功返回True,删除失败返回False</returns> public bool DeletePertainProductBomInfo(string id, string productType, int assemblyFlag, out DataTable returnTable, out string error) { returnTable = null; error = null; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <P_PertainProductBom> table = dataContxt.GetTable <P_PertainProductBom>(); P_PertainProductBom delRow = (from c in table where c.ID.ToString() == id select c).First(); table.DeleteOnSubmit(delRow); dataContxt.SubmitChanges(); if (assemblyFlag == 0) { GetPertainProductBomInfo("False", productType, out returnTable, out error); } else if (assemblyFlag == 1) { GetPertainProductBomInfo("True", productType, out returnTable, out error); } } catch (Exception err) { return(SetReturnError(err, out returnTable, out error)); } return(true); }
/// <summary> /// 删除领料退库单 /// </summary> /// <param name="billNo">领料退库单号</param> /// <param name="returnBill">返回更新后重新查询的领料退库单数据集</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除领料退库单号</returns> public bool DeleteBill(string billNo, out IQueryResult returnBill, out string error) { returnBill = null; error = null; try { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; Table <S_MaterialReturnedInTheDepot> table = ctx.GetTable <S_MaterialReturnedInTheDepot>(); var delRow = from c in table where c.Bill_ID == billNo select c; m_assignBill.CancelBillNo(ctx, "领料退库单", billNo); table.DeleteAllOnSubmit(delRow); //对于营销的总称领料的删除 var varData = from a in ctx.ProductsCodes where a.DJH == billNo select a; ctx.ProductsCodes.DeleteAllOnSubmit(varData); ctx.SubmitChanges(); return(GetAllBill(out returnBill, out error)); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 获取订单信息 /// </summary> /// <param name="listRole">角色列表</param> /// <param name="loginName">登录名</param> /// <param name="returnOrderFormInfo">返回查询到的订单信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作是否成功的标志</returns> public bool GetAllOrderFormInfo(List <string> listRole, string loginName, out IQueryable <View_B_OrderFormInfo> returnOrderFormInfo, out string error) { returnOrderFormInfo = null; error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <View_B_OrderFormInfo> table = dataContxt.GetTable <View_B_OrderFormInfo>(); var orderFormInfo = (from a in table join b in dataContxt.ProviderPrincipal on a.供货单位 equals b.Provider where b.PrincipalWorkId == loginName select a).Distinct().OrderByDescending(r => r.订货日期); returnOrderFormInfo = orderFormInfo.AsQueryable <View_B_OrderFormInfo>(); //returnOrderFormInfo = from c in table where c.权限控制用登录名 == loginName select c; if (returnOrderFormInfo.Count() == 0 || listRole.Contains(CE_RoleEnum.采购账务管理员.ToString()) || listRole.Contains(CE_RoleEnum.采购主管.ToString())) { returnOrderFormInfo = (from c in table select c).OrderByDescending(r => r.订货日期); } return(true); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 删除某一供应商 /// </summary> /// <param name="providerCode">供应商编码</param> /// <param name="persnonnelCode">工号</param> /// <param name="returnBill">操作成功后返回的查询信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除某一供应商</returns> public bool DeleteProvider(string providerCode, string persnonnelCode, out IQueryable <View_Provider> returnBill, out string error) { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { #region 除 关系表的信息 Table <ProviderPrincipal> tablePp = dataContxt.GetTable <ProviderPrincipal>(); var delRowPp = from c in tablePp where c.Provider == providerCode && c.PrincipalWorkId == persnonnelCode select c; foreach (var eiPp in delRowPp) { tablePp.DeleteOnSubmit(eiPp); } #endregion dataContxt.SubmitChanges(); GetAllProvider(out returnBill, out error); return(true); } catch (Exception err) { return(SetReturnError1(err, out returnBill, out error)); } }
/// <summary> /// 删除某一部门 /// </summary> /// <param name="departmentCode">部门编码</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除某一部门</returns> public bool DeleteDepartment(string departmentCode, out string error) { try { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <Department> table = dataContxt.GetTable <Department>(); var delRow = from c in table where c.DepartmentCode == departmentCode select c; foreach (var ei in delRow) { table.DeleteOnSubmit(ei); } dataContxt.SubmitChanges(); return(true); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 更新产品信息 /// </summary> /// <param name="productInfo">更新后的产品信息</param> /// <param name="returnProductInfo">返回重新查询到的产品信息</param> /// <param name="error">出错时返回的错误信息</param> /// <returns>操作是否成功的标志</returns> public bool UpdateProductInfo(P_ProductInfo productInfo, out IQueryable <View_P_ProductInfo> returnProductInfo, out string error) { returnProductInfo = null; error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <P_ProductInfo> table = dataContxt.GetTable <P_ProductInfo>(); var result = from c in table where c.ProductType == productInfo.ProductType select c; if (result.Count() != 0) { P_ProductInfo updateInfo = result.Single(); updateInfo.ProductCode = productInfo.ProductCode; updateInfo.ProductName = productInfo.ProductName; updateInfo.IsReturn = productInfo.IsReturn; updateInfo.Remark = productInfo.Remark; dataContxt.SubmitChanges(); } return(GetAllProductInfo(out returnProductInfo, out error)); } catch (Exception err) { return(SetReturnError(err, out returnProductInfo, out error)); } }
/// <summary> /// 删除材料类别编码表记录 /// </summary> /// <param name="szLid">关系ID</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool DeleteDepotForPersonnel(string szLid, out string error) { try { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <S_DepotTypeForPersonnel> table = dataContxt.GetTable <S_DepotTypeForPersonnel>(); var delRow = from c in table where c.ZlID == szLid select c; foreach (var ei in delRow) { table.DeleteOnSubmit(ei); } dataContxt.SubmitChanges(); return(true); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 添加产品信息 /// </summary> /// <param name="productInfo">产品信息</param> /// <param name="returnProductInfo">返回重新查询到的产品信息</param> /// <param name="error">出错时返回的错误信息</param> /// <returns>操作是否成功的标志</returns> public bool AddProductInfo(P_ProductInfo productInfo, out IQueryable <View_P_ProductInfo> returnProductInfo, out string error) { returnProductInfo = null; error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <P_ProductInfo> table = dataContxt.GetTable <P_ProductInfo>(); var billGather = from c in table where c.ProductType == productInfo.ProductType select c; int intSameNoteCount = billGather.Count <P_ProductInfo>(); if (intSameNoteCount == 0) { dataContxt.P_ProductInfo.InsertOnSubmit(productInfo); dataContxt.SubmitChanges(); return(GetAllProductInfo(out returnProductInfo, out error)); } else { error = "数据库中已存在该编码的产品信息!"; return(false); } } catch (Exception err) { return(SetReturnError(err, out returnProductInfo, out error)); } }
/// <summary> /// 删除采购退货单 /// </summary> /// <param name="billNo">退货单号</param> /// <param name="returnBill">返回更新后重新查询的采购退货单数据集</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除退货单号</returns> public bool DeleteBill(string billNo, out IQueryResult returnBill, out string error) { returnBill = null; error = null; try { IsolationManageBill serverIsolation = new IsolationManageBill(); DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <S_MaterialRejectBill> table = dataContxt.GetTable <S_MaterialRejectBill>(); var delRow = from c in table where c.Bill_ID == billNo select c; m_assignBill.CancelBillNo(dataContxt, "采购退货单", billNo); if (!serverIsolation.ClearBillDate(dataContxt, billNo, out error)) { return(false); } table.DeleteAllOnSubmit(delRow); dataContxt.SubmitChanges(); return(GetAllBill(out returnBill, out error)); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 删除主表信息 /// </summary> /// <param name="billID">单据号</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>删除成功返回True,否则返回False</returns> public bool DeleteBill(string billID, out string error) { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <S_MaterialDetainBill> table = dataContxt.GetTable <S_MaterialDetainBill>(); var delRow = from c in table where c.Bill_ID == billID select c; if (DeleteList(billID, out error)) { table.DeleteAllOnSubmit(delRow); } else { return(false); } dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 添加/修改供应商信息表 /// </summary> /// <param name="providerCode">供应商编码</param> /// <param name="providerName">供应商名称</param> /// <param name="remark">备注</param> /// <param name="returnBill">操作成功后返回的查询信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功添加/修改供应商信息表</returns> public bool UpdataNewProvider(string providerCode, string providerName, string remark, out IQueryable <View_B_NewProvider> returnBill, out string error) { returnBill = null; error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <B_NewProvider> table = dataContxt.GetTable <B_NewProvider>(); var varProvider = from c in table where c.NewProviderCode == providerCode select c; foreach (var ei in varProvider) { ei.NewProviderName = providerName; ei.Remark = remark; } dataContxt.SubmitChanges(); GetAllNewProvider(out returnBill, out error); return(true); } catch (Exception err) { return(SetReturnError2(err, out returnBill, out error)); } }
/// <summary> /// 删除某一供应商 /// </summary> /// <param name="providerCode">供应商编码</param> /// <param name="returnBill">操作成功后返回的查询信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除某一供应商</returns> public bool DeleteNewProvider(string providerCode, out IQueryable <View_B_NewProvider> returnBill, out string error) { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <B_NewProvider> table = dataContxt.GetTable <B_NewProvider>(); var delRow = from c in table where c.NewProviderCode == providerCode select c; foreach (var ei in delRow) { table.DeleteOnSubmit(ei); } dataContxt.SubmitChanges(); GetAllNewProvider(out returnBill, out error); return(true); } catch (Exception err) { return(SetReturnError2(err, out returnBill, out error)); } }
/// <summary> /// 删除普通入库单 /// </summary> /// <param name="billNo">入库单号</param> /// <param name="returnInfo">普通入库单</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除普通入库单号</returns> public bool DeleteBill(string billNo, out IQueryResult returnInfo, out string error) { returnInfo = null; error = null; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <S_OrdinaryInDepotBill> table = dataContxt.GetTable <S_OrdinaryInDepotBill>(); var delRow = from c in table where c.Bill_ID == billNo select c; table.DeleteAllOnSubmit(delRow); m_assignBill.CancelBillNo(dataContxt, "普通入库单", billNo); if (!m_serverFrockStandingBook.DeleteFrockOrdinaryInDepotBill(dataContxt, billNo, out error)) { return(false); } dataContxt.SubmitChanges(); return(GetAllBill(out returnInfo, out error)); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 通过员工编号删除 /// </summary> /// <param name="workID">员工编号</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>成功返回true,失败返回False</returns> public bool DeleteAttendanceSetting(List <string> workID, out string error) { try { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <HR_AttendanceSetting> table = dataContxt.GetTable <HR_AttendanceSetting>(); for (int i = 0; i < workID.Count; i++) { var delRow = from c in table where c.WorkID == workID[i].ToString() select c; foreach (var item in delRow) { table.DeleteOnSubmit(item); } } dataContxt.SubmitChanges(); return(true); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 获得分工位总成 /// </summary> /// <param name="queryAssemblingBom">操作后查询返回的产品信息</param> /// <param name="error">错误信息</param> /// <returns>获取成功返回True,获取失败返回False</returns> public bool GetAssemblingBom( out IQueryable <P_AssemblingBom> queryAssemblingBom, out string error) { error = ""; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <P_AssemblingBom> table = dataContxt.GetTable <P_AssemblingBom>(); queryAssemblingBom = (from c in table where c.ParentName != null orderby c.ParentName select c).Distinct(); return(true); } catch (Exception ex) { error = ex.Message; queryAssemblingBom = null; return(false); } }
/// <summary> /// 删除客户 /// </summary> /// <param name="clientCode">客户编码</param> /// <param name="returnClient">客户信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除客户信息</returns> public bool DeleteClient(string clientCode, out IQueryable <View_Client> returnClient, out string error) { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <Client> table = dataContxt.GetTable <Client>(); var delRow = from c in table where c.ClientCode == clientCode select c; foreach (var ei in delRow) { table.DeleteOnSubmit(ei); } var delInfo = from a in dataContxt.Out_StockInfo where a.SecStorageID == clientCode select a; dataContxt.Out_StockInfo.DeleteAllOnSubmit(delInfo); dataContxt.SubmitChanges(); return(GetAllClient(out returnClient, out error)); } catch (Exception err) { return(SetReturnError(err, out returnClient, out error)); } }
/// <summary> /// 获取订单物品信息 /// </summary> /// <param name="listRole">角色列表</param> /// <param name="loginName">登录名</param> /// <param name="returnOrderFormGoods">返回查询到的信息</param> /// <param name="error">错误信息, 没有则为null</param> /// <returns>操作是否成功的标志</returns> public bool GetAllOrderFormGoods(List <string> listRole, string loginName, out IQueryable <View_B_OrderFormGoods> returnOrderFormGoods, out string error) { returnOrderFormGoods = null; error = null; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <View_B_OrderFormGoods> table = dataContxt.GetTable <View_B_OrderFormGoods>(); if (listRole.Contains(CE_RoleEnum.采购账务管理员.ToString()) || listRole.Contains(CE_RoleEnum.SQE组长.ToString()) || listRole.Contains(CE_RoleEnum.采购主管.ToString()) || listRole.Contains(CE_RoleEnum.会计.ToString())) { returnOrderFormGoods = from c in table select c; } else { var orderForm = from r in dataContxt.View_B_OrderFormInfo where r.权限控制用登录名 == loginName select r.订单号; returnOrderFormGoods = from c in table where orderForm.Contains(c.订单号) select c; } return(true); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 删除自制件入库单 /// </summary> /// <param name="billNo">入库单号</param> /// <param name="returnBill">返回的单据查询结果集</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除自制件入库单号</returns> public bool DeleteBill(string billNo, out IQueryResult returnBill, out string error) { returnBill = null; error = null; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <S_HomemadePartBill> table = dataContxt.GetTable <S_HomemadePartBill>(); var delRow = from c in table where c.Bill_ID == billNo select c; table.DeleteAllOnSubmit(delRow); dataContxt.SubmitChanges(); return(GetAllBill(out returnBill, out error)); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 删除材料类型关系记录 /// </summary> /// <param name="szLid">关系ID</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool DeleteDtp(string szLid, out string error) { try { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <S_DepotForDtp> S_table = dataContxt.GetTable <S_DepotForDtp>(); var S_delRow = from a in S_table where a.DtpCode == szLid select a; foreach (var S_ei in S_delRow) { S_table.DeleteOnSubmit(S_ei); } dataContxt.SubmitChanges(); return(true); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 删除合同信息 /// </summary> /// <param name="bargainNumber">合同编号</param> /// <param name="returnBargainInfo">返回查询到的合同信息</param> /// <param name="error">错误信息, 没有则为null</param> /// <returns>操作是否成功的标志</returns> public bool DeleteBargainInfo(string bargainNumber, out IQueryResult returnBargainInfo, out string error) { error = null; returnBargainInfo = null; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; IBargainGoodsServer goodsServer = ServerModuleFactory.GetServerModule <IBargainGoodsServer>(); IQueryable <View_B_BargainGoods> returnBargainGoods; if (!goodsServer.GetBargainGoods(bargainNumber, out returnBargainGoods, out error)) { return(false); } #region 检查此合同的订单信息 IOrderFormInfoServer orderFormServer = ServerModuleFactory.GetServerModule <IOrderFormInfoServer>(); if (orderFormServer.GetOrderFormCollection(bargainNumber).Count() > 0) { error = string.Format("合同 [{0}] 还包含有订单信息无法进行删除,请将所有此合同包含的订单信息全部删除后才能进行此操作!", bargainNumber); return(false); } #endregion if (returnBargainGoods != null && returnBargainGoods.Count() > 0) { error = string.Format("合同 [{0}] 还包含有零件信息无法进行删除,请将所有此合同包含的零件信息全部删除后才能进行此操作!", bargainNumber); return(false); } Table <B_BargainInfo> table = dataContxt.GetTable <B_BargainInfo>(); var delRow = from c in table where c.BargainNumber == bargainNumber select c; table.DeleteAllOnSubmit(delRow); dataContxt.SubmitChanges(); return(GetAllBargainInfo(out returnBargainInfo, out error)); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 获取订单综合查询结果 /// </summary> /// <param name="listRole">用户角色列表</param> /// <param name="loginName">用户登录名</param> /// <returns>合同综合查询结果</returns> public IQueryable <View_B_OrderFormAnalyzer> GetOrderFormAnalyzer(List <string> listRole, string loginName) { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <View_B_OrderFormAnalyzer> table = dataContxt.GetTable <View_B_OrderFormAnalyzer>(); if (listRole.Contains(CE_RoleEnum.业务系统管理员.ToString()) || listRole.Contains(CE_RoleEnum.采购账务管理员.ToString()) || listRole.Contains(CE_RoleEnum.采购主管.ToString()) || listRole.Contains(CE_RoleEnum.会计.ToString())) { return(from c in table select c); } else { return(from c in table where c.权限控制用登录名 == loginName select c); } }
/// <summary> /// 删除合同物品信息 /// </summary> /// <param name="bargainNumber">合同号</param> /// <param name="goodsID">物品ID</param> /// <param name="returnBargainGoods">返回查询到的合同物品信息</param> /// <param name="error">错误信息, 没有则为null</param> /// <returns>操作是否成功的标志</returns> public bool DeleteBargainGoods(string bargainNumber, int goodsID, out IQueryable <View_B_BargainGoods> returnBargainGoods, out string error) { returnBargainGoods = null; error = null; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; Table <B_BargainGoods> table = dataContxt.GetTable <B_BargainGoods>(); var result = from r in dataContxt.B_BargainGoods where r.GoodsID == goodsID && r.BargainNumber == bargainNumber select r; if (result.Count() == 0) { error = "找不到指定物品信息,无法进行此操作!"; return(false); } dataContxt.B_BargainGoods.DeleteAllOnSubmit(result); var temp = from a in dataContxt.B_BargainGoods where a.BargainNumber == bargainNumber select a; if (temp == null || temp.Count() == 0) { var temp1 = from a in dataContxt.B_BargainInfo where a.BargainNumber == bargainNumber select a; temp1.Single().MinorPurchaseBillNo = null; } dataContxt.SubmitChanges(); return(GetBargainGoods(bargainNumber, out returnBargainGoods, out error)); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 获取客户信息 /// </summary> /// <param name="returnClient">客户信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功获取客户信息</returns> public bool GetAllClient(out IQueryable <View_Client> returnClient, out string error) { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <View_Client> table = dataContxt.GetTable <View_Client>(); returnClient = from c in table select c; return(true); } catch (Exception err) { return(SetReturnError(err, out returnClient, out error)); } }
/// <summary> /// 获取AB类零件表信息 /// </summary> /// <param name="returnTable">返回的AB零件表</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> public bool GetAllGoodsGradeTable(out IQueryable <View_Q_GoodsGradeTable> returnTable, out string error) { returnTable = null; error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <View_Q_GoodsGradeTable> table = dataContxt.GetTable <View_Q_GoodsGradeTable>(); returnTable = from c in table orderby c.类别, c.图号型号 select c; return(true); } catch (Exception err) { return(SetReturnError(err, out returnTable, out error)); } }
/// <summary> /// 删除自制件工装报检 /// </summary> /// <param name="billNo">单据号号</param> /// <param name="returnInfo">自制件工装报检</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除自制件工装报检</returns> public bool DeleteBill(string billNo, out IQueryResult returnInfo, out string error) { returnInfo = null; error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <S_FrockInDepotBill> table = dataContxt.GetTable <S_FrockInDepotBill>(); var delRow = from c in table where c.Bill_ID == billNo select c; table.DeleteAllOnSubmit(delRow); if (!m_serverFrockStandingBook.DeleteFrockOrdinaryInDepotBill(dataContxt, billNo, out error)) { return(false); } var result = from r in dataContxt.S_FrockInDepotGoodsBill where r.Bill_ID == billNo select r; if (result.Count() > 0) { dataContxt.S_FrockInDepotGoodsBill.DeleteAllOnSubmit(result); } dataContxt.SubmitChanges(); return(GetAllBill(out returnInfo, out error)); } catch (Exception exce) { error = exce.Message; return(false); } }
/// <summary> /// 获取供应商信息表 /// </summary> /// <param name="returnBill">供应商信息表</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功获取供应商信息表</returns> public bool GetAllProvider(out IQueryable <View_Provider> returnBill, out string error) { returnBill = null; error = null; try { DepotManagementDataContext depotMangaeDataContext = CommentParameter.DepotDataContext; IQueryable <View_Provider> providerTable = depotMangaeDataContext.GetTable <View_Provider>(); returnBill = from c in providerTable orderby c.供应商编码 select c; } catch (Exception err) { error = err.ToString(); return(false); } return(true); }
/// <summary> /// 删除单位 /// </summary> /// <param name="id">序号</param> /// <param name="returnUnit">单位信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>返回是否成功删除单位信息</returns> public bool DeleteUnit(int id, out IQueryable <View_S_Unit> returnUnit, out string error) { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { var varData = from a in dataContxt.F_GoodsPlanCost where a.UnitID == id select a; if (varData.Count() > 0) { error = "基础信息表内已经使用此单位,不能删除!"; GetAllUnit(out returnUnit, out error); return(false); } Table <S_Unit> table = dataContxt.GetTable <S_Unit>(); var delRow = from c in table where c.ID == id select c; foreach (var ei in delRow) { table.DeleteOnSubmit(ei); } dataContxt.SubmitChanges(); GetAllUnit(out returnUnit, out error); return(true); } catch (Exception err) { return(SetReturnError(err, out returnUnit, out error)); } }
/// <summary> /// 获取所有材料类别信息 /// </summary> /// <param name="materialTypes">查询到的材料类别信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作是否成功的标志</returns> public bool GetAllMaterialType(out IQueryable <View_S_Depot> materialTypes, out string error) { materialTypes = null; error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { Table <View_S_Depot> depotTable = dataContxt.GetTable <View_S_Depot>(); materialTypes = from c in depotTable orderby c.仓库编码 select c; return(true); } catch (Exception err) { error = err.ToString(); return(false); } }