/// <summary> /// 删除监测项目信息 /// </summary> /// <param name="itemInfo">监测项目信息</param> /// <returns>删除个数</returns> public int Delete(InspectItemEntity itemInfo) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //删除监测项目信息 string sql = "DELETE FROM InspectItemInfo WHERE Id=@Id"; count = session.ExecuteSql(sql, new DataParameter { ParameterName = "Id", DataType = DbType.String, Value = itemInfo.Id }); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入组织机构信息 /// </summary> /// <param name="orga">组织机构信息</param> /// <returns>插入数</returns> public int Insert(Orgaization orga) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); orga.DelFlag = "0"; if (String.IsNullOrEmpty(orga.OrganParent)) { orga.OrganParent = "0"; } //插入基本信息 session.Insert <Orgaization>(orga); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除用户信息信息 /// </summary> /// <param name="user">用户信息信息</param> /// <returns>删除个数</returns> public int Delete(User user) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //删除用户所有角色信息 string sql = "DELETE from T_USERROLE WHERE USERID=@USERID"; count = session.ExecuteSql(sql, new DataParameter { ParameterName = "USERID", DataType = DbType.String, Value = user.UserID }); //删除用户信息信息 sql = "DELETE from T_USER WHERE USERID=@USERID"; count = session.ExecuteSql(sql, new DataParameter { ParameterName = "USERID", DataType = DbType.String, Value = user.UserID }); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入信息(单表) /// </summary> /// <param name="">信息</param> /// <returns>插入行数</returns> public int Insert(WHQualityCheck model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //插入基本信息 count = session.Insert <WHQualityCheck>(model); foreach (WHQualityCheckResult detail in model.QualityCheckResults) { detail.ID = Guid.NewGuid().ToString(); detail.CheckID = model.ID; session.Insert <WHQualityCheckResult>(detail); } session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入信息(单表) /// </summary> /// <param name="">信息</param> /// <returns>插入行数</returns> public int Insert(ProduceBOM model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //插入基本信息 count = session.Insert <ProduceBOM>(model); foreach (BOMDetail detail in model.Details) { detail.PID = Guid.NewGuid().ToString(); detail.BOMID = model.PID; session.Insert <BOMDetail>(detail); } session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入用户信息信息 /// </summary> /// <param name="user">用户信息信息</param> /// <returns>插入数</returns> public int Insert(User user) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //插入基本信息 session.Insert <User>(user); //插入用户角色信息 if (user.Roles != null) { foreach (UserRole ur in user.Roles) { ur.UserID = user.UserID; } //插入角色信息 session.Insert <UserRole>(user.Roles); } session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新信息 /// </summary> /// <param name=""></param> /// <returns>更新行数</returns> public int Update(ProduceBOM model) { int count = 0; string sql = "delete from T_FP_BOMDETAIL where BOMID = @BOMID"; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //更新BOM信息 count = session.Update <ProduceBOM>(model); //删除BOM明细信息 session.ExecuteSql(sql, new DataParameter("BOMID", model.PID)); foreach (BOMDetail detail in model.Details) { detail.PID = Guid.NewGuid().ToString(); detail.BOMID = model.PID; session.Insert <BOMDetail>(detail); } session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入信息(单表) /// </summary> /// <param name="">信息</param> /// <returns>插入行数</returns> public int Insert(SupplyInfo model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //插入基本信息 count = session.Insert <SupplyInfo>(model); foreach (SupplyMaterialInfo detail in model.Details) { detail.PID = Guid.NewGuid().ToString(); detail.SUPPLYID = model.PID; session.Insert <SupplyMaterialInfo>(detail); } session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除组织机构信息 /// </summary> /// <param name="orga">组织机构信息</param> /// <returns>删除个数</returns> public int Delete(Orgaization orga) { int count = 0; string sql = null; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //先删除组织机构所有权限信息 sql = "DELETE T_ORGAIZATIONAUTHORITY WHERE ORGANID=@ORGANID"; count = session.ExecuteSql(sql, new DataParameter { ParameterName = "ORGANID", DataType = DbType.String, Value = orga.OrganID }); //删除组织机构信息 sql = "UPDATE T_ORGANIZATION SET DELFLAG = '1' WHERE ORGANID=@ORGANID"; count = session.ExecuteSql(sql, new DataParameter { ParameterName = "ORGANID", DataType = DbType.String, Value = orga.OrganID }); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新信息 /// </summary> /// <param name=""></param> /// <returns>更新行数</returns> public int Update(SupplyInfo model) { int count = 0; string sql = "delete from T_FP_SUPPLYMATERIALINFO where SUPPLYID = @SUPPLYID"; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //更新BOM信息 count = session.Update <SupplyInfo>(model); //删除BOM明细信息 session.ExecuteSql(sql, new DataParameter("SUPPLYID", model.PID)); foreach (SupplyMaterialInfo detail in model.Details) { detail.PID = Guid.NewGuid().ToString(); detail.SUPPLYID = model.PID; session.Insert <SupplyMaterialInfo>(detail); } session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新信息 /// </summary> /// <param name=""></param> /// <returns>更新行数</returns> public int Update(WHQualityCheck model) { int count = 0; string sql = "delete from T_WH_QualityCheckResult where CheckID = @CheckID"; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); count = session.Update <WHQualityCheck>(model); session.ExecuteSql(sql, new DataParameter("CheckID", model.ID)); foreach (WHQualityCheckResult detail in model.QualityCheckResults) { detail.ID = Guid.NewGuid().ToString(); detail.CheckID = model.ID; session.Insert <WHQualityCheckResult>(detail); } session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入信息(单表) /// </summary> /// <param name="">信息</param> /// <returns>插入行数</returns> public int Insert(GoodInfo model) { int count = 0; List <DataParameter> parameters = new List <DataParameter>(); try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //插入基本信息 count = session.Insert <GoodInfo>(model); string sql = "UPDATE T_FP_ProducePlan SET FactAmount = FactAmount+@OfflineNum WHERE PID =@PID"; parameters.Add(new DataParameter { ParameterName = "OfflineNum", DataType = DbType.String, Value = model.OfflineNum }); parameters.Add(new DataParameter { ParameterName = "PID", DataType = DbType.String, Value = model.PLANID }); count = session.ExecuteSql(sql, parameters.ToArray()); //产品组成批次号 sql = "update T_FP_GoodPackingForm set BatchNumber = @BatchNumber where GoodBarCode = @GoodBarCode"; session.ExecuteSql(sql, new DataParameter("BatchNumber", model.BatchNumber), new DataParameter("GoodBarCode", model.GoodBarCode)); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入角色 /// </summary> /// <param name="role">角色信息</param> /// <returns>插入数</returns> public int Insert(RoleInfo role) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //插入基本信息 session.Insert <RoleInfo>(role); if (role.Powers != null) { foreach (RoleAuthority ra in role.Powers) { ra.RoleID = role.RoleID; } //插入权限信息 session.Insert <RoleAuthority>(role.Powers); } session.CommitTs(); } return(count); } catch (Exception ex) { throw; } }
/// <summary> /// 删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(CheckStockBill info) { int count = 0; string sql = ""; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); count = session.Delete <CheckStockBill>(info); sql = "delete from T_WH_CheckStockDetail where BillID = @BillID"; session.ExecuteSql(sql, new DataParameter("BillID", info.ID)); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
public void Insert(UseMatBill bill) { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); session.Insert <UseMatBill>(bill); session.Insert <UseMatAmount>(bill.Amounts); session.Insert <UseMatDetail>(bill.Details); session.CommitTs(); } }
/// <summary> /// 记录货品唯一识别码打印次数 /// </summary> /// <param name="idCodeList">识别码列表</param> public void SignMatIDCodePrintCount(List <string> idCodeList) { string sql = "update T_WH_MatIDCode set PrintCount=PrintCount+1 where IDCode = ?IDCode"; using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); foreach (string idCode in idCodeList) { session.ExecuteSql(sql, new DataParameter("IDCode", idCode)); } session.CommitTs(); } }
/// <summary> /// 装箱 /// </summary> /// <param name="list"></param> public void Packing(List <GoodPackingForm> list) { string sql = "delete from T_FP_GoodPackingForm where GoodBarCode = @GoodBarCode"; using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //删除原装箱信息 session.ExecuteSql(sql, new DataParameter("GoodBarCode", list[0].GoodBarCode)); //添加装箱信息 session.Insert <GoodPackingForm>(list); session.CommitTs(); } }
/// <summary> /// 新增盘点单 /// </summary> /// <param name="info"></param> public void Insert(CheckStockBill info) { try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); session.Insert <CheckStockBill>(info); session.Insert <CheckStockDetail>(info.Details); session.CommitTs(); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 保存仓库权限 /// </summary> /// <param name="userID">用户主键</param> /// <param name="powers">仓库权限</param> public void SaveWHPowers(string userID, List <WarehousePower> powers) { string sql = "delete from T_WH_WHPower where UserID = @UserID"; using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //删除 session.ExecuteSql(sql, new DataParameter("UserID", userID)); //新增 session.Insert <WarehousePower>(powers); session.CommitTs(); } }
/// <summary> /// 盘点确认 /// </summary> /// <param name="info">盘点单</param> public void ConfirmCheck(CheckStockBill info) { CheckStockDAL dal = new CheckStockDAL(); StockDAL sDal = new StockDAL(); int seq = 1; foreach (CheckStockDetail detail in info.Details) { detail.ID = Guid.NewGuid().ToString(); detail.BillID = info.ID; detail.Seq = seq; seq++; } using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); dal.Session = session; sDal.Session = session; //更新盘点单信息 info.IsConfirm = 1; dal.Update(info); foreach (CheckStockDetail detail in info.Details) { //更新库存信息 WHMatAmount matStock = sDal.GetStock(new WHMatAmount() { Warehouse = info.Warehouse , SaveSite = detail.SaveSite , MatID = detail.MatID , MatBarCode = detail.IDCode }); matStock.MainAmount = matStock.MainAmount * detail.FactAmount / matStock.ProductAmount; matStock.ProductAmount = detail.FactAmount; sDal.Update(matStock); } session.CommitTs(); } }
public void Delete(UseMatBill bill) { string sql = null; using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); session.Delete <UseMatBill>(bill); sql = "delete from T_WH_UseMatAmount where USEID = @USEID"; session.ExecuteSql(sql, new DataParameter("USEID", bill.PID)); session.Insert <UseMatAmount>(bill.Amounts); sql = "delete from T_WH_UseMatDetail where USEID = @USEID"; session.ExecuteSql(sql, new DataParameter("USEID", bill.PID)); session.Insert <UseMatDetail>(bill.Details); session.CommitTs(); } }
/// <summary> /// 插入操作记录(列表) /// </summary> /// <param name="log">记录</param> /// <returns>插入数</returns> public int InsertList(List <SystemOperateLog> logList) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); session.Insert <SystemOperateLog>(logList); session.CommitTs(); } return(count); } catch (Exception ex) { throw; } }
/// <summary> /// 库内移动 /// </summary> /// <param name="bill">移动信息</param> public void InsideMoveStock(MoveStockBill bill) { MoveStockDAL msDal = new MoveStockDAL(); StockDAL sDal = new StockDAL(); bill.ID = Guid.NewGuid().ToString(); bill.BillNO = this.GetNewBillNO(); bill.FromWarehouse = bill.ToWarehouse; bill.FromWHHeader = this.LoginUser.UserID; bill.ToWHHeader = this.LoginUser.UserID; bill.MoveMode = "1"; bill.CREATEUSER = this.LoginUser.UserID; bill.CREATETIME = DateTime.Now; bill.UPDATEUSER = bill.CREATEUSER; bill.UPDATETIME = bill.CREATETIME; foreach (MoveStockDetail detail in bill.Details) { detail.ID = Guid.NewGuid().ToString(); detail.FromSaveSite = detail.ToSaveSite; detail.BillID = bill.ID; } List <MoveStockRecord> records = bill.Details.Select(p => new MoveStockRecord() { IDCode = p.IDCode, MatID = p.MatID, ToSaveSite = p.ToSaveSite, ToWarehouse = bill.ToWarehouse }).ToList(); using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); msDal.Session = session; sDal.Session = session; msDal.Insert(bill); sDal.MoveStock(records); session.CommitTs(); } }
/// <summary> /// 更新组织机构 /// </summary> /// <param name="orga">组织机构</param> /// <returns>更新个数</returns> public int Update(Orgaization orga) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //更新基本信息 count = session.Update <Orgaization>(orga); session.CommitTs(); } return(count); } catch (Exception ex) { throw; } }
/// <summary> /// 插入监测项目信息 /// </summary> /// <param name="itemInfo">监测项目信息</param> /// <returns>插入数</returns> public int Insert(InspectItemEntity itemInfo) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //插入基本信息 session.Insert <InspectItemEntity>(itemInfo); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新角色 /// </summary> /// <param name="role">角色信息</param> /// <returns>更新个数</returns> public int Update(RoleInfo role) { int count = 0; string sql = null; List <DataParameter> parameters = new List <DataParameter>(); try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //更新基本信息 session.Update <RoleInfo>(role); //更新权限信息 sql = "DELETE FROM T_ROLEAUTHORITY WHERE ROLEID=@ROLEID"; sql = this.ChangeSqlByDB(sql, session); session.ExecuteSql(sql, new DataParameter { ParameterName = "ROLEID", DataType = DbType.String, Value = role.RoleID }); if (role.Powers != null) { session.Insert <RoleAuthority>(role.Powers); } session.CommitTs(); } return(count); } catch (Exception ex) { throw; } }
/// <summary> /// 删除角色信息 /// </summary> /// <param name="role">角色信息</param> /// <returns>删除个数</returns> public int Delete(RoleInfo role) { int count = 0; string sql = null; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //删除权限信息,子表 sql = "DELETE FROM T_ROLEAUTHORITY WHERE ROLEID=@ROLEID"; sql = this.ChangeSqlByDB(sql, session); session.ExecuteSql(sql, new DataParameter { ParameterName = "ROLEID", DataType = DbType.String, Value = role.RoleID }); //删除基本信息,主表 sql.Remove(0, sql.Length); sql = "DELETE FROM T_ROLE WHERE ROLEID=@ROLEID"; sql = this.ChangeSqlByDB(sql, session); session.ExecuteSql(sql, new DataParameter { ParameterName = "ROLEID", DataType = DbType.String, Value = role.RoleID }); session.CommitTs(); } return(count); } catch (Exception ex) { throw; } }
/// <summary> /// 入库(货品编号) /// </summary> /// <param name="bill">入库单</param> /// <returns></returns> public void InMatStorage(InStockBill bill) { //设置基本信息 bill.BillNO = this.GetNewBillNO(); bill.BillDate = DateTime.Now; bill.Receiver = this.LoginUser.UserID; bill.ID = Guid.NewGuid().ToString(); bill.CREATEUSER = this.LoginUser.UserID; bill.CREATETIME = DateTime.Now; bill.UPDATEUSER = this.LoginUser.UserID; bill.UPDATETIME = bill.CREATETIME; int seq = 1; foreach (InStockDetail detail in bill.Details) { detail.ID = Guid.NewGuid().ToString(); detail.BillID = bill.ID; detail.InAmount = detail.MainUnitAmount; detail.CREATEUSER = bill.CREATEUSER; detail.CREATETIME = bill.CREATETIME; detail.UPDATEUSER = bill.UPDATEUSER; detail.UPDATETIME = bill.UPDATETIME; detail.Seq = seq; seq++; } StockDAL stockDal = new StockDAL(); InStockDAL isDal = new InStockDAL(); using (IDataSession session = AppDataFactory.CreateMainSession()) { try { stockDal.Session = session; isDal.Session = session; foreach (InStockDetail detail in bill.Details) { WHMatAmount inStock = new WHMatAmount(); inStock.Warehouse = bill.Warehouse; inStock.SaveSite = detail.SaveSite; inStock.MatBarCode = detail.MatBarCode; inStock.MatID = detail.MatID; inStock.ProductAmount = detail.InAmount; inStock.ProductPrice = detail.InPrice; inStock.ProductSum = detail.InSum; inStock.Unit = detail.UnitCode; inStock.CreateUser = this.LoginUser.UserID; inStock.UpdateUser = this.LoginUser.UserID; inStock.MainAmount = detail.MainUnitAmount; stockDal.InStock(inStock); } isDal.Insert(bill); session.CommitTs(); } catch (Exception ex) { session.RollbackTs(); throw ex; } } }
/// <summary> /// 入库 /// </summary> /// <param name="bill">入库单</param> /// <returns></returns> public string InStorage(InStockBill bill) { string result = ""; bill.ID = Guid.NewGuid().ToString(); bill.CREATEUSER = this.LoginUser.UserID; bill.CREATETIME = DateTime.Now; bill.UPDATEUSER = this.LoginUser.UserID; bill.UPDATETIME = bill.CREATETIME; int seq = 1; foreach (InStockDetail detail in bill.Details) { detail.ID = Guid.NewGuid().ToString(); detail.BillID = bill.ID; detail.CREATEUSER = bill.CREATEUSER; detail.CREATETIME = bill.CREATETIME; detail.UPDATEUSER = bill.UPDATEUSER; detail.UPDATETIME = bill.UPDATETIME; detail.Seq = seq; seq++; } StockDAL stockDal = new StockDAL(); InStockDAL isDal = new InStockDAL(); using (IDataSession session = AppDataFactory.CreateMainSession()) { try { stockDal.Session = session; isDal.Session = session; foreach (InStockDetail detail in bill.Details) { WHMatAmount inStock = new WHMatAmount(); inStock.Warehouse = bill.Warehouse; inStock.SaveSite = detail.SaveSite; inStock.MatBarCode = detail.MatBarCode; inStock.MatID = detail.MatID; inStock.ProductAmount = detail.InAmount; inStock.ProductPrice = detail.InPrice; inStock.ProductSum = detail.InSum; inStock.Unit = detail.UnitCode; inStock.MainAmount = detail.MainUnitAmount; if (string.IsNullOrEmpty(detail.MatBarCode) == false && string.IsNullOrEmpty(detail.ProduceDate) == false) { inStock.ProduceDate = DateTime.Parse(detail.ProduceDate); //更新条码信息的生产日期 new WHMatDAL().UpdateIDCodeProduceDate(new MatIDCode { IDCode = detail.MatBarCode, ProduceDate = detail.ProduceDate }); } stockDal.InStock(inStock); } isDal.Insert(bill); session.CommitTs(); } catch (Exception ex) { session.RollbackTs(); throw ex; } } return(result); }
/// <summary> /// 出库 /// </summary> /// <param name="bill">出库单</param> /// <returns></returns> public string OutStorage(OutStockBill bill) { string result = ""; bill.ID = Guid.NewGuid().ToString(); bill.CREATEUSER = this.LoginUser.UserID; bill.CREATETIME = DateTime.Now; bill.UPDATEUSER = this.LoginUser.UserID; bill.UPDATETIME = bill.CREATETIME; //设置明细 int seq = 1; foreach (OutStockDetail detail in bill.Details) { detail.ID = Guid.NewGuid().ToString("N"); detail.Seq = seq; seq++; detail.BillID = bill.ID; detail.CREATEUSER = bill.CREATEUSER; detail.CREATETIME = bill.CREATETIME; detail.UPDATEUSER = bill.UPDATEUSER; detail.UPDATETIME = bill.UPDATETIME; } StockDAL stockDal = new StockDAL(); OutStockDAL outDal = new OutStockDAL(); using (IDataSession session = AppDataFactory.CreateMainSession()) { try { stockDal.Session = session; outDal.Session = session; foreach (OutStockDetail detail in bill.Details) { WHMatAmount outStock = new WHMatAmount(); outStock.Warehouse = bill.Warehouse; outStock.SaveSite = detail.SaveSite; outStock.MatBarCode = detail.IDCode; outStock.MatID = detail.MatID; outStock.ProductAmount = detail.OutAmount; outStock.ProductPrice = detail.OutPrice; outStock.ProductSum = detail.OutSum; outStock.Unit = detail.UnitCode; outStock.MainAmount = detail.MainUnitAmount; result = stockDal.OutStock(outStock); if (result != "") { break; } } if (result != "") { session.RollbackTs(); return(result); } outDal.Insert(bill); session.CommitTs(); } catch (Exception ex) { session.RollbackTs(); throw ex; } } return(result); }