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