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