/// <summary> /// 更新一条数据 /// </summary> public bool Update(EPReper.Model.ReperClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReperClass set "); strSql.Append("classname=@classname, "); strSql.Append("pic=@pic "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@classname", SqlDbType.NVarChar,50), new SqlParameter("@pic", SqlDbType.NVarChar,50), new SqlParameter("@id",SqlDbType.Int,4)}; parameters[0].Value = model.classname; parameters[1].Value = model.pic; parameters[2].Value = model.id; int rows = DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EPReper.Model.Userinfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Userinfo("); strSql.Append("id,username,department,phone,AMNum,QQ,Email,URole)"); strSql.Append(" values ("); strSql.Append("@id,@username,@department,@phone,@AMNum,@QQ,@Email,@URole)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@username", SqlDbType.NVarChar,50), new SqlParameter("@department", SqlDbType.NVarChar,50), new SqlParameter("@phone", SqlDbType.NVarChar,20), new SqlParameter("@AMNum", SqlDbType.NVarChar,50), new SqlParameter("@QQ", SqlDbType.NVarChar,50), new SqlParameter("@Email", SqlDbType.NVarChar,50), new SqlParameter("@URole", SqlDbType.Int,4)}; parameters[0].Value = model.id; parameters[1].Value = model.username; parameters[2].Value = model.department; parameters[3].Value = model.phone; parameters[4].Value = model.AMNum; parameters[5].Value = model.QQ; parameters[6].Value = model.Email; parameters[7].Value = model.URole; int rows = DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(EPReper.Model.RepairInfo model) { string str = "select count(code) from RepairInfo where bigid = " + model.BigID + " and isdel = 0 and finish!= 2 and code > 0 "; model.code = Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, str, null)) + 1; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RepairInfo("); strSql.Append("BigID,ClassID,userID,UpTime,Times,StartComment,Finish,isDel,applyPhone,code,BaseCode)"); strSql.Append(" values ("); strSql.Append("@BigID,@ClassID,@userID,@UpTime,@Times,@StartComment,@Finish,@isDel,@applyPhone,@code,@BaseCode)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@BigID",SqlDbType.Int,4), new SqlParameter("@ClassID", SqlDbType.Int,4), new SqlParameter("@userID", SqlDbType.Int,4), new SqlParameter("@UpTime", SqlDbType.DateTime), new SqlParameter("@Times", SqlDbType.NVarChar,50), new SqlParameter("@StartComment", SqlDbType.NText), new SqlParameter("@Finish", SqlDbType.Int,4), new SqlParameter("@isDel", SqlDbType.Int,4), new SqlParameter("@applyPhone",SqlDbType.VarChar,50), new SqlParameter("@code",SqlDbType.Int,4), new SqlParameter("@BaseCode",SqlDbType.NChar,20)}; parameters[0].Value = model.BigID; parameters[1].Value = model.ClassID; parameters[2].Value = model.userID; parameters[3].Value = model.UpTime; parameters[4].Value = model.Times; parameters[5].Value = model.StartComment; parameters[6].Value = 0; parameters[7].Value = 0; parameters[8].Value = model.applyPhone; parameters[9].Value = model.code; parameters[10].Value = model.BaseCode; object obj = DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EPReper.Model.Userinfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Userinfo set "); strSql.Append("username=@username,"); strSql.Append("department=@department,"); strSql.Append("phone=@phone,"); strSql.Append("AMNum=@AMNum,"); strSql.Append("QQ=@QQ,"); strSql.Append("Email=@Email,"); strSql.Append("URole=@URole"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@username", SqlDbType.NVarChar,50), new SqlParameter("@department", SqlDbType.NVarChar,50), new SqlParameter("@phone", SqlDbType.NVarChar,20), new SqlParameter("@AMNum", SqlDbType.NVarChar,50), new SqlParameter("@QQ", SqlDbType.NVarChar,50), new SqlParameter("@Email", SqlDbType.NVarChar,50), new SqlParameter("@URole", SqlDbType.Int,4), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.username; parameters[1].Value = model.department; parameters[2].Value = model.phone; parameters[3].Value = model.AMNum; parameters[4].Value = model.QQ; parameters[5].Value = model.Email; parameters[6].Value = model.URole; parameters[7].Value = model.id; int rows = DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(EPReper.Model.ReperClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ReperClass("); strSql.Append("classname,parentID,SubNum,orderNum,PoPlist,men,isDel,pic)"); strSql.Append(" values ("); strSql.Append("@classname,@parentID,@SubNum,@orderNum,@PoPlist,@men,@isDel,@pic)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@classname", SqlDbType.NVarChar,50), new SqlParameter("@parentID", SqlDbType.Int,4), new SqlParameter("@SubNum", SqlDbType.Int,4), new SqlParameter("@orderNum", SqlDbType.Int,4), new SqlParameter("@PoPlist", SqlDbType.NText), new SqlParameter("@men", SqlDbType.NText), new SqlParameter("@isDel", SqlDbType.Int,4), new SqlParameter("@pic",SqlDbType.NVarChar,50)}; parameters[0].Value = model.classname; parameters[1].Value = model.parentID; parameters[2].Value = 0; parameters[3].Value = 0; parameters[4].Value = ""; parameters[5].Value = ""; parameters[6].Value = 0; parameters[7].Value = model.pic; object obj = DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EPReper.Model.Userinfo model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EPReper.Model.Userinfo model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EPReper.Model.RepairInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RepairInfo set "); strSql.Append("BigID=@BigID,"); strSql.Append("ClassID=@ClassID,"); strSql.Append("userID=@userID,"); strSql.Append("point=@point,"); strSql.Append("UpTime=@UpTime,"); strSql.Append("DoTime=@DoTime,"); strSql.Append("OverTime=@OverTime,"); strSql.Append("Times=@Times,"); strSql.Append("StartComment=@StartComment,"); strSql.Append("OverComment=@OverComment,"); strSql.Append("Finish=@Finish,"); strSql.Append("isDel=@isDel"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@BigID", SqlDbType.Int,4), new SqlParameter("@ClassID", SqlDbType.Int,4), new SqlParameter("@userID", SqlDbType.Int,4), new SqlParameter("@point", SqlDbType.Int,4), new SqlParameter("@UpTime", SqlDbType.DateTime), new SqlParameter("@DoTime", SqlDbType.DateTime), new SqlParameter("@OverTime", SqlDbType.DateTime), new SqlParameter("@Times", SqlDbType.NVarChar,50), new SqlParameter("@StartComment", SqlDbType.NText), new SqlParameter("@OverComment", SqlDbType.NText), new SqlParameter("@Finish", SqlDbType.Int,4), new SqlParameter("@isDel", SqlDbType.Int,4), new SqlParameter("@BaseCode",SqlDbType.NChar,20), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.BigID; parameters[1].Value = model.ClassID; parameters[2].Value = model.userID; parameters[3].Value = model.point; parameters[4].Value = model.UpTime; parameters[5].Value = model.DoTime; parameters[6].Value = model.OverTime; parameters[7].Value = model.Times; parameters[8].Value = model.StartComment; parameters[9].Value = model.OverComment; parameters[10].Value = model.Finish; parameters[11].Value = model.isDel; parameters[12].Value = model.BaseCode; parameters[13].Value = model.id; int rows = DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EPReper.Model.ReperClass model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(EPReper.Model.ReperClass model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EPReper.Model.RepairInfo model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(EPReper.Model.RepairInfo model) { return dal.Add(model); }
/// <summary> /// 添加维修人员 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(EPReper.Model.Manager model) { return dal.Add(model); }