/// <summary> /// 添加多个库位类型. /// </summary> /// <param name="posisty">库位类型对象泛型集合.</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool addPositionsType(List <Model.PositionType> posisty) { for (int j = 0; j < posisty.Count; j++) { string sqltext = "insert positiontype(positionTypeId,positionTypeName,length,width,height,remark) values(@positionTypeId,@positionTypeName,@length,@width,@height,@remark)"; List <SqlParameter> para = new List <SqlParameter>(); string maxid = DBTools.searchID("position", "positionTypeId"); int id = maxid != null?int.Parse(maxid) : 0; SqlParameter sqlpara1 = new SqlParameter("@positionTypeId", (id + 1).ToString()); SqlParameter sqlpara2 = new SqlParameter("@positionTypeName", posisty[j].PositionTypeName); SqlParameter sqlpara3 = new SqlParameter("@length", posisty[j].Length); SqlParameter sqlpara4 = new SqlParameter("@width", posisty[j].Width); SqlParameter sqlpara5 = new SqlParameter("@height", posisty[j].Height); SqlParameter sqlpara6 = new SqlParameter("@remark", posisty[j].Remark); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { continue; } else { return(false); } } return(true); }
/// <summary> /// 添加多个批次。 /// </summary> /// <param name="bates">批次对象集合</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool addBatches(List <Model.Batch> bates) { for (int j = 0; j < bates.Count; j++) { string sqltext = "insert batch(batchNum,outorinType,proorrecNum,condition) values(@batchNum,@outorinType,@proorrecNum,@condition)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@batchNum", bates[j].BatchNum); SqlParameter sqlpara2 = new SqlParameter("@outorinType", bates[j].OutorinType); SqlParameter sqlpara3 = new SqlParameter("@proorrecNum", bates[j].ProorrecNum); SqlParameter sqlpara4 = new SqlParameter("@condition", bates[j].Condition); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); int i = DBTools.exenonquerySQL(sqltext, para);; if (i == 1) { continue; } else { return(false); } } return(true); }
/// <summary> /// 更新某个库位.库位ID不可更改. /// </summary> /// <param name="posity">库位类型对象.</param> public bool updatePositionType(Model.PositionType posity) { string sqltext = "update positiontype set positionTypeName=@positionTypeName,length=@length,width=@width,height=@height,remark=@remark where positionTypeId=@positionTypeId"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@positionTypeId", posity.PositionTypeId); SqlParameter sqlpara2 = new SqlParameter("@positionTypeName", posity.PositionTypeName); SqlParameter sqlpara3 = new SqlParameter("@length", posity.Length); SqlParameter sqlpara4 = new SqlParameter("@width", posity.Width); SqlParameter sqlpara5 = new SqlParameter("@height", posity.Height); SqlParameter sqlpara6 = new SqlParameter("@remark", posity.Remark); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加一个库位类型.库位类型ID是主键. /// </summary> /// <param name="posity">库位类型对象.</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool addPositionType(Model.PositionType posity) { string sqltext = "insert positiontype(num,positionTypeId,positionTypeName,length,width,height,remark) values(@num,@positionTypeId,@positionTypeName,@length,@width,@height,@remark)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara = new SqlParameter("@num", posity.Num); SqlParameter sqlpara1 = new SqlParameter("@positionTypeId", posity.PositionTypeId); SqlParameter sqlpara2 = new SqlParameter("@positionTypeName", posity.PositionTypeName); SqlParameter sqlpara3 = new SqlParameter("@length", posity.Length); SqlParameter sqlpara4 = new SqlParameter("@width", posity.Width); SqlParameter sqlpara5 = new SqlParameter("@height", posity.Height); SqlParameter sqlpara6 = new SqlParameter("@remark", posity.Remark); para.Add(sqlpara); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个供货商信息 /// </summary> /// <param name="pro">要更新的供货商对象</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool updateProvider(Model.Provider pro) { string sqltext = "update provider set providerName=@providerName,staffName=@staffName,contact=@contact,contactNumber=@contactNumber,providerAddress=@providerAddress,updateTime=@updateTime where providerNum=@providerNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@providerNum", pro.ProviderNum); SqlParameter sqlpara2 = new SqlParameter("@providerName", pro.ProviderName); SqlParameter sqlpara3 = new SqlParameter("@staffName", pro.Leader); SqlParameter sqlpara4 = new SqlParameter("@contact", pro.Contact); SqlParameter sqlpara5 = new SqlParameter("@contactNumber", pro.ContactNumber); SqlParameter sqlpara6 = new SqlParameter("@providerAddress", pro.ProviderAddress); //SqlParameter sqlpara7 = new SqlParameter("@createTime", pro.CreateTime.ToString()); SqlParameter sqlpara8 = new SqlParameter("@updateTime", pro.UpdateTime.ToString()); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); //para.Add(sqlpara7); para.Add(sqlpara8); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加多个供货商. /// </summary> /// <param name="pros">供货商对象泛型集合.</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool addProviders(List <Model.Provider> pros) { for (int j = 0; j < pros.Count; j++) { string sqltext = "insert provider(providerNum,providerName,staffName,contact,contactNumber,providerAddress,createTime,updateTime) values(@providerNum,@providerName,@staffName,@contact,@contactNumber,@providerAddress,@createTime,@updateTime)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@providerNum", pros[j].ProviderNum); SqlParameter sqlpara2 = new SqlParameter("@providerName", pros[j].ProviderName); SqlParameter sqlpara3 = new SqlParameter("@staffName", pros[j].Leader); SqlParameter sqlpara4 = new SqlParameter("@contact", pros[j].Contact); SqlParameter sqlpara5 = new SqlParameter("@contactNumber", pros[j].ContactNumber); SqlParameter sqlpara6 = new SqlParameter("@providerAddress", pros[j].ProviderAddress); SqlParameter sqlpara7 = new SqlParameter("@createTime", pros[j].CreateTime.ToString()); SqlParameter sqlpara8 = new SqlParameter("@updateTime", pros[j].UpdateTime.ToString()); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); para.Add(sqlpara8); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { continue; } else { return(false); } } return(true); }
/// <summary> /// 更改数据备份信息 /// </summary> /// <param name="ccopy">数据备份对象</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool updateCopy(Model.DataCopy ccopy) { string sqltext = "update datacopy set dataName=@dataName,copyTime=@copyTime,copyType=@copyType,copySize=@copySize,userId=@userId,copyLocation=@copyLocation,copyState=@copyState where copyId=@copyId"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@copyId", ccopy.CopyId); SqlParameter sqlpara2 = new SqlParameter("@dataName", ccopy.DataName); SqlParameter sqlpara3 = new SqlParameter("@copyTime", ccopy.CopyTime); SqlParameter sqlpara4 = new SqlParameter("@copyType", ccopy.CopyType); SqlParameter sqlpara5 = new SqlParameter("@copySize", ccopy.CopySize); SqlParameter sqlpara6 = new SqlParameter("@userId", ccopy.SysUser.UserId); SqlParameter sqlpara7 = new SqlParameter("@copyLocation", ccopy.CopyLocation); SqlParameter sqlpara8 = new SqlParameter("@copyState", ccopy.CopyState); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); para.Add(sqlpara8); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 增加一个数据备份。 /// </summary> /// <param name="ccopy">数据备份对象</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool addCopy(Model.DataCopy ccopy) { string sqltext = "insert datacopy(copyId,dataName,copyTime,copyType,copySize,userId,copyLocation,copyState) values(@copyId,@dataName,@copyTime,@copyType,@copySize,@userId,@copyLocation,@copyState)"; List <SqlParameter> para = new List <SqlParameter>(); string maxid = DBTools.searchID("datacopy", "copyId"); int id = maxid != null?int.Parse(maxid) : 0; SqlParameter sqlpara1 = new SqlParameter("@copyId", (id + 1).ToString()); SqlParameter sqlpara2 = new SqlParameter("@dataName", ccopy.DataName); SqlParameter sqlpara3 = new SqlParameter("@copyTime", ccopy.CopyTime); SqlParameter sqlpara4 = new SqlParameter("@copyType", ccopy.CopyType); SqlParameter sqlpara5 = new SqlParameter("@copySize", ccopy.CopySize); SqlParameter sqlpara6 = new SqlParameter("@userId", ccopy.SysUser.UserId); SqlParameter sqlpara7 = new SqlParameter("@copyLocation", ccopy.CopyLocation); SqlParameter sqlpara8 = new SqlParameter("@copyState", ccopy.CopyState); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); para.Add(sqlpara8); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个收货商信息对象. /// </summary> /// <param name="rec">收货商对象.</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool updateReceiver(Model.Receiver rec) { string sqltext = "update receiver set receiverName=@receiverName,staffName=@staffName,contact=@contact,contactNumber=@contactNumber,receiverAddress=@receiverAddress,createTime=@createTime,updateTime=@updateTime where receiverNum=@receiverNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@receiverNum", rec.ReceiverNum); SqlParameter sqlpara2 = new SqlParameter("@receiverName", rec.ReceiverName); SqlParameter sqlpara3 = new SqlParameter("@staffName", rec.StaffName); SqlParameter sqlpara4 = new SqlParameter("@contact", rec.Contact); SqlParameter sqlpara5 = new SqlParameter("@contactNumber", rec.ContactNumber); SqlParameter sqlpara6 = new SqlParameter("@receiverAddress", rec.ReceiverAddress); SqlParameter sqlpara7 = new SqlParameter("@createTime", rec.CreateTime.ToString()); SqlParameter sqlpara8 = new SqlParameter("@updateTime", rec.UpdateTime.ToString()); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); para.Add(sqlpara8); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加一个系统用户。 /// </summary> /// <param name="su">系统用户类对象</param> /// <returns>布尔值提示添加是否成功</returns> public bool addUser(Model.SysUser su) { string sqltext = "insert sysuser(userId,staffNum,password,job) values(@userId,@staffNum,@password,@job)"; string maxid = DBTools.searchID("sysuser", "userId"); int id = maxid != null?int.Parse(maxid) : 0; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@userId", (id + 1).ToString()); SqlParameter sqlpara2 = new SqlParameter("@staffNum", su.StaffNum); SqlParameter sqlpara3 = new SqlParameter("@password", su.Password); SqlParameter sqlpara4 = new SqlParameter("@job", su.Job); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 增加一个库柜。 /// </summary> /// <param name="cchest">库柜对象。</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool addChest(Model.Chest cchest) { string sqltext = "insert chest(num,chestNum,chestName,M,Height,roomNum,remark,createTime,updateTime) values(@num,@chestNum,@chestName,@M,@Height,@roomNum,@remark,@createTime,@updateTime)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara = new SqlParameter("@num", cchest.Num); SqlParameter sqlpara1 = new SqlParameter("@chestNum", cchest.ChestNum); SqlParameter sqlpara2 = new SqlParameter("@chestName", cchest.ChestName); SqlParameter sqlpara4 = new SqlParameter("@roomNum", cchest.RoomNum); SqlParameter sqlpara5 = new SqlParameter("@remark", cchest.Remark); SqlParameter sqlpara6 = new SqlParameter("@createTime", cchest.CreateTime); SqlParameter sqlpara7 = new SqlParameter("@updateTime", cchest.UpdateTime); SqlParameter sqlpara8 = new SqlParameter("@M", cchest.M); SqlParameter sqlpara9 = new SqlParameter("@Height", cchest.Height); para.Add(sqlpara); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara8); para.Add(sqlpara9); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加一条库存记录。 /// </summary> /// <param name="aamount">库存记录对象</param> public bool addAmount(Model.Amount aamount) { string sqltext = "insert amount(num,positionNum,goodsNum,amount,per,V,Vp) values(@num,@positionNum,@goodsNum,@amount,@per,@V,@Vp)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara = new SqlParameter("@num", aamount.Num); SqlParameter sqlpara1 = new SqlParameter("@positionNum", aamount.PositionNum); SqlParameter sqlpara2 = new SqlParameter("@goodsNum", aamount.GoodsNum); SqlParameter sqlpara3 = new SqlParameter("@amount", aamount.Amounts); SqlParameter sqlpara4 = new SqlParameter("@per", aamount.AmountPer); SqlParameter sqlpara5 = new SqlParameter("@V", aamount.V); SqlParameter sqlpara6 = new SqlParameter("@Vp", aamount.Vp); para.Add(sqlpara); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某条公告的内容。 /// </summary> /// <param name="noti">公告对象</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool updateNotice(Model.Notice noti) { string sqltext = "update notice set subject=@subject,title=@title,body=@body,userId=@userId,createTime=@createTime,publishTime=@publishTime where noticeId=@noticeId"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@noticeId", noti.NoticeId); SqlParameter sqlpara2 = new SqlParameter("@subject", noti.Subject); SqlParameter sqlpara3 = new SqlParameter("@title", noti.Title); SqlParameter sqlpara4 = new SqlParameter("@body", noti.Body); SqlParameter sqlpara5 = new SqlParameter("@userId", noti.SysUser.UserId); SqlParameter sqlpara6 = new SqlParameter("@createTime", noti.CreateTime.ToString()); SqlParameter sqlpara7 = new SqlParameter("@publishTime", noti.UpdateTime.ToString()); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加一条公告。 /// </summary> public bool addNotice(Model.Notice notice) { string sqltext = "insert notice(noticeId,subject,title,body,userId,createTime,publishTime) values(@noticeId,@subject,@title,@body,@userId,@createTime,@publishTime)"; string maxid = DBTools.searchID("notice", "noticeId"); int id = maxid != null?int.Parse(maxid) : 0; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@noticeId", (id + 1).ToString()); SqlParameter sqlpara2 = new SqlParameter("@subject", notice.Subject); SqlParameter sqlpara3 = new SqlParameter("@title", notice.Title); SqlParameter sqlpara4 = new SqlParameter("@body", notice.Body); SqlParameter sqlpara5 = new SqlParameter("@userId", notice.SysUser.UserId); SqlParameter sqlpara6 = new SqlParameter("@createTime", notice.CreateTime.ToString()); SqlParameter sqlpara7 = new SqlParameter("@publishTime", notice.UpdateTime.ToString()); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新一条出库信息。 /// </summary> /// <param name="oout">出库对象。</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool updateOut(Model.Outout oout) { string sqltext = "update outout set positionNum=@positionNum,goodsNum=@goodsNum,outAmount=@outAmount,batchNum=@batchNum,date=@date,userId=@userId,remark=@remark where outID=@outID"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@outID", oout.OuID); SqlParameter sqlpara2 = new SqlParameter("@positionNum", oout.PositionNum); SqlParameter sqlpara3 = new SqlParameter("@goodsNum", oout.GoodsNum); SqlParameter sqlpara4 = new SqlParameter("@outAmount", oout.OutAmount); SqlParameter sqlpara5 = new SqlParameter("@batchNum", oout.BatchNum); SqlParameter sqlpara6 = new SqlParameter("@date", oout.Date.ToString()); SqlParameter sqlpara7 = new SqlParameter("@userId", oout.UserId); SqlParameter sqlpara8 = new SqlParameter("@remark", oout.Remark); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); para.Add(sqlpara8); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加一条出库信息 /// </summary> /// <param name="oout">出库对象。</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool addOut(Model.Outout oout) { string sqltext = "insert outout(num,outID,positionNum,goodsNum,outAmount,batchNum,date,userId,remark) values(@num,@outID,@positionNum,@goodsNum,@outAmount,@batchNum,@date,@userId,@remark)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara = new SqlParameter("@num", oout.Num); SqlParameter sqlpara1 = new SqlParameter("@outID", oout.OuID); SqlParameter sqlpara2 = new SqlParameter("@positionNum", oout.PositionNum); SqlParameter sqlpara3 = new SqlParameter("@goodsNum", oout.GoodsNum); SqlParameter sqlpara4 = new SqlParameter("@outAmount", oout.OutAmount); SqlParameter sqlpara5 = new SqlParameter("@batchNum", oout.BatchNum); SqlParameter sqlpara6 = new SqlParameter("@date", oout.Date.ToString()); SqlParameter sqlpara7 = new SqlParameter("@userId", oout.UserId); SqlParameter sqlpara8 = new SqlParameter("@remark", oout.Remark); para.Add(sqlpara); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); para.Add(sqlpara8); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个员工信息,员工编号不变。 /// </summary> /// <param name="sstaff">员工类对象.</param> /// <returns>通过布尔值提示是否完成.</returns> public bool updateStaff(Model.staff sstaff) { string sqltext = "update staff set staffName=@staffName,departId=@departId,birthday=@birthday,gender=@gender,hometown=@hometown,idCard=@idCard,phoneNumber=@phoneNumber where staffNum=@staffNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@staffNum", sstaff.StaffNum); SqlParameter sqlpara2 = new SqlParameter("@staffName", sstaff.StaffName); SqlParameter sqlpara3 = new SqlParameter("@departId", sstaff.DepartId); SqlParameter sqlpara4 = new SqlParameter("@birthday", sstaff.Birthday.ToString()); SqlParameter sqlpara5 = new SqlParameter("@gender", sstaff.Gender); SqlParameter sqlpara6 = new SqlParameter("@hometown", sstaff.Hometown); SqlParameter sqlpara7 = new SqlParameter("@idCard", sstaff.IdCard); SqlParameter sqlpara8 = new SqlParameter("@phoneNumber", sstaff.PhoneNumber); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); para.Add(sqlpara8); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加多个部门。 /// </summary> /// <param name="departs">部门对象泛型集合。</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool addDeparts(List <Model.Department> departs) { for (int j = 0; j < departs.Count; j++) { string sqltext = "insert department(departId,departName,staffNum,parentdepartName) values(@departId,@departName,@staffNum,@parentdepartName)"; List <SqlParameter> para = new List <SqlParameter>(); string maxid = DBTools.searchID("department", "departId"); int id = maxid != null?int.Parse(maxid) : 0; SqlParameter sqlpara1 = new SqlParameter("@departId", (id + 1).ToString()); SqlParameter sqlpara2 = new SqlParameter("@departName", departs[j].DepartName); SqlParameter sqlpara3 = new SqlParameter("@staffNum", departs[j].SysUser.StaffNum); SqlParameter sqlpara4 = new SqlParameter("@parentdepartName", departs[j].ParentdepartName); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { continue; } else { return(false); } } return(true); }
/// <summary> /// 更新某个库柜信息。 /// </summary> /// <param name="cchest">库柜对象</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool updateChest(Model.Chest cchest) { string sqltext = "update chest set chestName=@chestName,positionMax=@positionMax,roomNum=@roomNum,remark=@remark,createTime=@createTime,updateTime=@updateTime,M=@M,Height=@Height where chestNum=@chestNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@chestNum", cchest.ChestNum); SqlParameter sqlpara2 = new SqlParameter("@chestName", cchest.ChestName); SqlParameter sqlpara3 = new SqlParameter("@positionMax", cchest.PositionMax); SqlParameter sqlpara4 = new SqlParameter("@roomNum", cchest.RoomNum); SqlParameter sqlpara5 = new SqlParameter("@remark", cchest.Remark); SqlParameter sqlpara6 = new SqlParameter("@createTime", cchest.CreateTime); SqlParameter sqlpara7 = new SqlParameter("@updateTime", cchest.UpdateTime); SqlParameter sqlpara8 = new SqlParameter("@M", cchest.M); SqlParameter sqlpara9 = new SqlParameter("@Height", cchest.Height); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); para.Add(sqlpara8); para.Add(sqlpara9); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个物品种类 /// </summary> /// <param name="ttype">物品种类对象</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool updateGoodsType(Model.GoodsType ttype) { string sqltext = "update goodstype set goodsTypeName=@goodsTypeName,parentTypeNum=@parentTypeNum,goodsTypeCondition=@goodsTypeCondition,remark=@remark,createTime=@createTime,updateTime=@updateTime where goodsTypeNum=@goodsTypeNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@goodsTypeNum", ttype.GoodsTypeNum); SqlParameter sqlpara2 = new SqlParameter("@goodsTypeName", ttype.GoodsTypeName); SqlParameter sqlpara3 = new SqlParameter("@parentTypeNum", ttype.ParentTypeNum); SqlParameter sqlpara4 = new SqlParameter("@goodsTypeCondition", ttype.GoodsTypeCondition); SqlParameter sqlpara5 = new SqlParameter("@remark", ttype.Remark); SqlParameter sqlpara6 = new SqlParameter("@createTime", ttype.CreateTime.ToString()); SqlParameter sqlpara7 = new SqlParameter("@updateTime", ttype.UpdateTime.ToString()); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara7); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加一条日志记录对象 /// </summary> /// <param name="templog">系统日志类对象</param> /// <returns>通过布尔值提示是否完成.</returns> public bool addLog(Model.SysLog templog) { string sqltext = "insert syslog(logId,userId,ipAddress,actionTime,[column],actionType) values(@logId,@userId,@ipAddress,@actionTime,@column,@actionType)"; List <SqlParameter> para = new List <SqlParameter>(); string maxid = DBTools.searchID("syslog", "logid"); int id = maxid != null?int.Parse(maxid) : 0; SqlParameter sqlpara1 = new SqlParameter("@logId", (id + 1).ToString()); SqlParameter sqlpara2 = new SqlParameter("@userId", templog.UserId); SqlParameter sqlpara3 = new SqlParameter("@ipAddress", templog.IpAddress); SqlParameter sqlpara4 = new SqlParameter("@actionTime", templog.ActionTime.ToString()); SqlParameter sqlpara5 = new SqlParameter("@column", templog.Column); SqlParameter sqlpara6 = new SqlParameter("@actionType", templog.ActionType); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加一个部门。 /// </summary> /// <param name="depart">部门对象</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool addDepart(Model.Department depart) { string sqltext = "insert Department(num,departId,departName,staffNum,parentdepartName) values(@num,@departId,@departName,@staffNum,@parentdepartName)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara = new SqlParameter("@num", depart.Num); SqlParameter sqlpara1 = new SqlParameter("@departId", depart.DepartId); SqlParameter sqlpara2 = new SqlParameter("@departName", depart.DepartName); SqlParameter sqlpara3 = new SqlParameter("@staffNum", depart.StaffNum); SqlParameter sqlpara4 = new SqlParameter("@parentdepartName", depart.ParentdepartName); para.Add(sqlpara); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个库存对象 /// </summary> /// <param name="aamount">库存对象</param> public bool update(Model.Amount aamount) { string sqltext = "update amount set amount=@amount,V=@V where positionNum=@positionNum1 and goodsNum=@goodsNum1 and Vp=@Vp"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@V", aamount.V); SqlParameter sqlpara2 = new SqlParameter("@amount", aamount.Amounts); SqlParameter sqlpara4 = new SqlParameter("@positionNum1", aamount.PositionNum); SqlParameter sqlpara6 = new SqlParameter("@goodsNum1", aamount.GoodsNum); SqlParameter sqlpara7 = new SqlParameter("@Vp", aamount.Vp); para.Add(sqlpara2); para.Add(sqlpara1); para.Add(sqlpara4); para.Add(sqlpara6); para.Add(sqlpara7); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个库存对象 /// </summary> /// <param name="aamount">库存对象</param> public bool updateAmount(Model.Amount aamount) { string sqltext = "update amount set goodsNum=@goodsNum,amount=@amount,per=@per,v=@v where positionNum=@positionNum1 and goodsNum=@goodsNum1"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@goodsNum", aamount.GoodsNum); SqlParameter sqlpara2 = new SqlParameter("@amount", aamount.Amounts); SqlParameter sqlpara3 = new SqlParameter("@per", aamount.AmountPer); SqlParameter sqlpara = new SqlParameter("@v", aamount.V); SqlParameter sqlpara4 = new SqlParameter("@positionNum1", aamount.PositionNum); SqlParameter sqlpara6 = new SqlParameter("@goodsNum1", aamount.GoodsNum); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara); para.Add(sqlpara4); para.Add(sqlpara6); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 添加一个房间. /// </summary> /// <param name="rroom">房间对象.</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool addRoom(Model.Room rroom) { string sqltext = "insert room(num,roomNum,roomName,M,Height,remark,createTime,updateTime) values(@num,@roomNum,@roomName,@M,@Height,@remark,@createTime,@updateTime)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara = new SqlParameter("@num", rroom.Num); SqlParameter sqlpara1 = new SqlParameter("@roomNum", rroom.RoomNum); SqlParameter sqlpara2 = new SqlParameter("@roomName", rroom.RoomName); SqlParameter sqlpara3 = new SqlParameter("@M", rroom.M); SqlParameter sqlpara33 = new SqlParameter("@Height", rroom.Height); SqlParameter sqlpara4 = new SqlParameter("@remark", rroom.Remark); SqlParameter sqlpara5 = new SqlParameter("@createTime", rroom.CreateTime.ToString()); SqlParameter sqlpara6 = new SqlParameter("@updateTime", rroom.UpdateTime.ToString()); para.Add(sqlpara); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara33); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个房间对象的信息.房间编号不变. /// </summary> /// <param name="rroom">要更新的房间对象.</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool updateRoom(Model.Room rroom) { string sqltext = "update room set roomName=@roomName,M=@M,Height=@Height,chestMax=@chestMax,remark=@remark,createTime=@createTime,updateTime=@updateTime where roomNum=@roomNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@roomNum", rroom.RoomNum); SqlParameter sqlpara2 = new SqlParameter("@roomName", rroom.RoomName); SqlParameter sqlpara22 = new SqlParameter("@M", rroom.M); SqlParameter sqlpara33 = new SqlParameter("@Height", rroom.Height); SqlParameter sqlpara3 = new SqlParameter("@chestMax", rroom.ChestMax); SqlParameter sqlpara4 = new SqlParameter("@remark", rroom.Remark); SqlParameter sqlpara5 = new SqlParameter("@createTime", rroom.CreateTime.ToString()); SqlParameter sqlpara6 = new SqlParameter("@updateTime", rroom.UpdateTime.ToString()); para.Add(sqlpara2); para.Add(sqlpara22); para.Add(sqlpara33); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 删除所有的物品种类 /// </summary> /// <returns>通过布尔值判断操作是否成功。</returns> public bool deleteAllGoodsTypes() { string sqltext = "delete from goodstype"; int i = DBTools.exenonquerySQL(sqltext, new List <SqlParameter> ()); if (i > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除所有库存。 /// </summary> public bool deleteAmounts() { string sqltext = "delete from amount"; int i = DBTools.exenonquerySQL(sqltext, new List <SqlParameter>()); if (i > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除所有房间. /// </summary> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool deleteAllRooms() { string sqltext = string.Format("delete from room"); int i = DBTools.exenonquerySQL(sqltext, new List <SqlParameter>()); if (i > 0) { return(true); } else { return(false); } }
/// <summary> /// 通过库存ID,删除某条信息。 /// </summary> /// <param name="outid">出库id</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool deleteOutById(string outid) { string sqltext = "delete from outout where outID=@outID"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@outID", outid); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }