/// <summary> /// 添加新的系统用户 /// </summary> /// <param name="loginid"></param> /// <param name="pass"></param> /// <param name="name"></param> /// <param name="isDefaultPower">是否给新加用户赋默认权限</param> /// <returns>-2:添加用户失败;-3:添加用户和赋权都成功; ///power:复权所影响的行数;-5;//添加用成功,不赋权</returns> public static int Add(string loginid, string pass, string name, string departId, string tel, string email, string power) { sqlHandler sh = new sqlHandler(); string sql = string.Format("insert into syUsers values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", loginid, pass, name, departId, tel, email, power); int Adduser = sh.ExecuteNonQuery(sql); //添加用户 if (Adduser > 0) //如果添加成功就赋默认权限 { string sqlPower = string.Format("exec Proc_AddPower '{0}','{1}'", loginid, power); int result = sh.ExecuteNonQuery(sqlPower); /*if (power != -2) //赋默认权限 * { * return result;//添加用户和赋权都成功 * } * else * { * return -2;//添加用户成功但赋权失败 * }*/ } else { return(-1);//添加用户失败 } return(0); }
/// <summary> /// 添加新的系统用户 /// </summary> /// <param name="loginname"></param> /// <param name="pass"></param> /// <param name="name"></param> /// <param name="isDefaultPower">是否给新加用户赋默认权限</param> /// <returns>-2:添加用户失败;-3:添加用户和赋权都成功; ///power:复权所影响的行数;-5;//添加用成功,不赋权</returns> public static int Add(string loginname, string pass, string name, bool isDefaultPower) { sqlHandler sh = new sqlHandler(); string sql = string.Format("insert into syUsers values('{0}','{1}','{2}')", loginname, pass, name); int Adduser = sh.ExecuteNonQuery(sql); //添加用户 if (Adduser > 0) //如果添加成功就检查是否要赋默认权限 { if (isDefaultPower) //如果需要添加默认权限 { string sqlPower = string.Format("exec Proc_AddPower '{0}'", loginname); int power = sh.ExecuteNonQuery(sqlPower); if (power != -3) //赋默认权限 { return(power); //添加用户和赋权都成功 } else { return(-3);//添加用户成功但赋权失败 } } else { return(-5);//添加用成功,不赋权 } } else { return(-2);//添加用户失败 } }
/// <summary> /// 删除系统用户 /// </summary> /// <param name="loginid"></param> /// <returns></returns> public static bool Del(string loginid) { string sql = string.Format("delete from SyUsers where id='{0}'", loginid); string powersql = string.Format("delete from [Power] where loginid='{0}'", loginid); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0 && sh.ExecuteNonQuery(powersql) > 0); }
/// <summary> /// 删除指定的保管人 /// </summary> /// <param name="id">工号</param> /// <returns></returns> public static int Del(int id) { sqlHandler sh = new sqlHandler(); string sqlcheck = string.Format("exec proc_DelKeeper {0}", id); string sqldel = string.Format("delete from keeper where id={0}", id); if (sh.ExecuteNonQuery(sqlcheck) == -1)//判断是否还保管资产 { return(-1); } else { return(sh.ExecuteNonQuery(sqldel)); } }
/// <summary> /// 添加某一个用户的权限 /// </summary> /// <param name="loginname"></param> /// <param name="func"></param> /// <returns></returns> public static bool Add(string loginname, int func) { string sql = string.Format("insert into [power] values('{0}',{1})", loginname, func); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 修改资料(不修改密码) /// </summary> /// <param name="loginname">登录名</param> /// <param name="name">真实姓名</param> /// <returns></returns> public static bool UpdateNoPass(string loginname, string name) { string sql = string.Format("update SyUsers set name='{0}' where loginname='{1}'", name, loginname); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 修改资料 /// </summary> /// <param name="loginname">登录名</param> /// <param name="oldpass">原密码</param> /// <param name="newpass">新密码</param> /// <param name="name">真实姓名</param> /// <returns></returns> public static int UpdatePass(string loginname, string oldpass, string newpass, string name) { string sql = string.Format("exec proc_UpdateSysUserInfo '{0}','{1}','{2}','{3}'", loginname, oldpass, newpass, name); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql)); }
public static bool Update(Equipment eq) { string eqNo = eq.EqNo; string name = eq.Name; string type = eq.Type; string addtype = eq.AddType; int count = eq.Count; double price = eq.Price; string plus = eq.Plus; string lable = eq.Lable; string uintt = eq.Unit; DateTime birth = eq.Birthday; string keeper = eq.Keeper; string keepplace = eq.KeepPlace; string maker = eq.Maker; string model = eq.Model; string usetime = eq.UseTime; string booker = eq.Booker; DateTime bookdate = eq.BookDate; sqlHandler sh = new sqlHandler(); string sql = string.Format("update equipment set type='{0}',name='{1}',label='{2}',model='{3}',plus='{4}',count={5},unit='{6}',price={7},maker='{8}',birthday='{9}',addtype='{10}',keepplace='{11}',keeper='{12}',usetime='{13}',booker='{14}',boodDate='15' where eqno='{16}'", type, name, lable, model, plus, count, uintt, price, maker, birth, addtype, keepplace, keeper, usetime, booker, bookdate, eqNo); return(sh.ExecuteNonQuery(sql)); }
/// <summary> /// 删除系统用户 /// </summary> /// <param name="loginname"></param> /// <returns></returns> public static bool Del(string loginname) { string sql = string.Format("delete from SyUsers where loginname='{0}'", loginname); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 添加保存地点 /// </summary> /// <param name="type"></param> /// <returns></returns> public static bool AddPlace(string place) { string sql = string.Format("insert into KeepPlace values('{0}')", place); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 维修审核未通过 /// </summary> /// <param name="ID">流水号</param> /// <param name="bReviewer">用户</param> /// <returns></returns> public static bool disagreeAudit(string ID, string user) { string sql = string.Format("update FixLog set mReviewer='{1}', state='送修审核未通过' where serialNo='{0}'", ID, user); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 修改基本项目 /// </summary> /// <param name="table"></param> /// <param name="id"></param> /// <param name="discrip"></param> /// <returns></returns> public static bool UpdateBasic(string table, int id, string discrip) { string sql = string.Format("update {0} set discrip='{2}' where id={1}", table, id, discrip); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 删除项目 /// </summary> /// <param name="table"></param> /// <param name="id"></param> /// <returns></returns> public static bool DeleteBasic(string table, int id) { string sql = string.Format("delete from {0} where id={1}", table, id); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 删除指定的部门 /// </summary> /// <param name="id">部门id</param> /// <returns></returns> public static bool Del(string id) { string sql = string.Format("delete from department where id='{0}' or pid='{0}'", id); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 修改部门名称 /// </summary> /// <param name="name"></param> /// <param name="departid"></param> /// <returns></returns> public static bool Update(string name, string departid) { string sql = string.Format("update department set departName='{0}' where id='{1}' ", name, departid); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 注销审核未通过 /// </summary> /// <param name="ID">流水号</param> /// <param name="bReviewer">用户</param> /// <returns></returns> public static bool disagreeAudit(string ID, string user, string audit) { string sql = string.Format("update ClearLog set cReviewer='{1}', state='注销审核未通过' , audit='{2}' where serialNo='{0}'", ID, user, audit); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 添加计量单位 /// </summary> /// <param name="type"></param> /// <returns></returns> public static bool Add(string unit) { string sql = string.Format("insert into unit values('{0}')", unit); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 修改保存地点 /// </summary> /// <param name="type"></param> /// <returns></returns> public static bool UpdatePlace(int id, string place) { string sql = string.Format("update KeepPlace set Place='{1}' where id={0}", id, place); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 删除某一个用户的权限 /// </summary> /// <param name="loginname"></param> /// <param name="func"></param> /// <returns></returns> public static bool Del(string loginname, int func) { string sql = string.Format("delete from [power] where userloginname='{0}'and menu_id={1}", loginname, func); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 添加维修商信息 /// </summary> /// <param name="type"></param> /// <returns></returns> public static bool Add(string name, string address, string contracts, string tel) { string sql = string.Format("insert into Maintainer values('{0}','{1}','{2}','{3}')", name, address, contracts, tel); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 修改资料(不修改密码) /// </summary> /// <param name="loginid">登录名</param> /// <param name="name">真实姓名</param> /// <returns></returns> public static bool UpdateNoPass(string loginid, string name, string tel, string email, string departid) { string sql = string.Format("update SyUsers set loginname='{0}' ,tel='{1}',email='{2}',DepartId='{3}' where id='{4}'", name, tel, email, departid, loginid); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 添加新部门 /// </summary> /// <param name="departId"></param> /// <returns>true:成功;fals:失败</returns> public static bool Add(string departId, string departName, string pid) { string sql = string.Format("insert into department values('{0}','{1}','{2}')", departId, departName, pid); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 新增基本项目 /// </summary> /// <param name="table"></param> /// <param name="discrip"></param> /// <returns></returns> public static bool AddBasic(string table, string discrip) { string sql = string.Format("insert into {0} values('{1}')", table, discrip); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 修改资料 /// </summary> /// <param name="loginid">登录名</param> /// <param name="oldpass">原密码</param> /// <param name="newpass">新密码</param> /// <param name="name">真实姓名</param> /// <returns></returns> public static int UpdatePass(string loginid, string oldpass, string newpass, string name, string tel, string email, string departid) { string sql = string.Format("exec proc_UpdateSysUserInfo '{0}','{1}','{2}','{3}','{4}','{5}','{6}'", loginid, oldpass, newpass, name, tel, email, departid); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql)); }
/// <summary> /// 添加资产类型 /// </summary> /// <param name="type"></param> /// <returns></returns> public static bool AddType(string type) { string sql = string.Format("insert into type values('{0}')", type); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 系统数据初始化 /// </summary> /// <returns></returns> public static bool SysInit() { string sql = "exec proc_Init"; sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) == -1); }
/// <summary> /// 删除维修商信息 /// </summary> /// <param name="type"></param> /// <returns></returns> public static bool Del(int id) { string sql = string.Format("delete from Maintainer where id={0}", id); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 添加保管人员 /// </summary> /// <param name="empid">工号</param> /// <param name="name">姓名</param> /// <returns></returns> public static bool Add(int empid, string name) { string sql = string.Format("Insert into keeper values({0},'{1}')", empid, name); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 删除维修信息 /// </summary> /// <param name="ID">流水号</param> /// <param name="bReviewer">用户</param> /// <returns></returns> public static bool deleteAudit(string ID) { string sql = string.Format("DELETE FixLog WHERE serialNo='{0}'", ID); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 资产增长 /// </summary> /// <param name="eq"></param> /// <returns>true:成功;false:失败</returns> public static bool Add(Equipment eq) { string eqNo = eq.EqNo; string name = eq.Name; string type = eq.Type; string addtype = eq.AddType; int count = eq.Count; double price = eq.Price; string plus = eq.Plus; string lable = eq.Lable; string uintt = eq.Unit; DateTime birth = eq.Birthday; string keeper = eq.Keeper; string keepplace = eq.KeepPlace; string maker = eq.Maker; string model = eq.Model; string usetime = eq.UseTime; string booker = eq.Booker; DateTime bookdate = eq.BookDate; sqlHandler sh = new sqlHandler(); string sql = string.Format("insert into equipment values('{0}','{1}','{2}','{3}','{4}','{5}',{6},'{7}',{8},'{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}')", eqNo, type, name, lable, model, plus, count, uintt, price, maker, birth, addtype, keepplace, keeper, usetime, booker, bookdate); return(sh.ExecuteNonQuery(sql)); }