/// <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);
}
}