/// <summary> /// 添加新员工 /// </summary> /// <param name="emp">员工</param> /// <returns>true:添加成功;false:添加失败</returns> public static bool Add(Employee emp) { int id = emp.EmpNo; int depart = emp.departId; string name = emp.Name; string sex = emp.Sex; string sql = string.Format("insert into employee values('{0}','{1}',{2})", name, sex, depart); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 更新资产领用 /// </summary> /// <param name="br"></param> /// <returns></returns> public static bool CUpdate(string ID, Clear clear) { string cType = clear.CType; //注销方式 DateTime cDate = clear.CDate; //借用日期 string remark = clear.Remark; //备注 string sql = string.Format("update ClearLog set cType='{1}', cDate='{2}', remark='{3}', state='{4}' where serialNo='{0}'", ID, cType, cDate, remark, "注销待审核"); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 更新资产领用 /// </summary> /// <param name="fix"></param> /// <returns></returns> public static bool MUpdate(string ID, Fix fix) { string maintainer = fix.Maintainer; //借用人 DateTime mDate = fix.MDate; //借用日期 DateTime rDate = fix.RDate; //归还日期 string remark = fix.mRemark; //备注 string sql = string.Format("update FixLog set maintainer='{1}', mDate='{2}', rDate='{3}', mRemark='{4}', state='{5}' where serialNo='{0}'", ID, maintainer, mDate, rDate, remark, "送修待审核"); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 修改员工信息 /// </summary> /// <param name="emp"></param> /// <returns></returns> public static bool Update(Employee emp) { int empNo = emp.EmpNo; //string id = emp.ID; int depart = emp.departId; string name = emp.Name; string sex = emp.Sex; string sql = string.Format("update employee set name='{0}',sex='{1}',departid={2} where empid={3}", name, sex, depart, empNo); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 归还资产 /// </summary> /// <param name="re"></param> /// <returns>true:成功;false:失败</returns> public static bool Returns(Returns re) { string eqno = re.EqNo; int count = re.Count; string booker = re.Booker; int Borower = re.Borrower; string date = re.Date; sqlHandler sh = new sqlHandler(); string sql = string.Format("insert into [return] values({0},'{1}',{2},'{3}','{4}')", Borower, eqno, count, date, booker); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 添加监控设备 /// </summary> /// <param name="br"></param> /// <returns></returns> public static bool Add(Monitor mt) { int mtNo = mt.MtNo; string place = mt.Place; int doNo = mt.DoNo; string ip = mt.IP; string status = mt.Status; string sql = string.Format("insert into Monitor values({0},'{1}',{2},'{3}','{4}')", mtNo, place, doNo, ip, status); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 更新资产领用 /// </summary> /// <param name="br"></param> /// <returns></returns> public static bool BUpdate(string ID, Borrow br) { string borrower = br.Borrower; //借用人 DateTime bDate = br.BDate; //借用日期 DateTime rDate = br.RDate; //归还日期 string remark = br.bRemark; //备注 string sql = string.Format("update BorrowLog set borrower='{1}', bDate='{2}', rDate='{3}', bRemark='{4}', state='{5}' where serialNo='{0}'", ID, borrower, bDate, rDate, remark, "借出待审核"); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 添加新员工 /// </summary> /// <param name="emp">员工</param> /// <returns>true:添加成功;false:添加失败</returns> public static bool Add(Employee emp) { string id = emp.EmpId; string depart = emp.departId; string name = emp.Name; string sex = emp.Sex; string tel = emp.Tel; string email = emp.Email; string sql = string.Format("insert into employee values('{0}','{1}','{2}','{3}','{4}','{5}')", id, name, depart, sex, tel, email); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 资产领用 /// </summary> /// <param name="br"></param> /// <returns></returns> public static bool Add(Borrow br) { string eqno = br.EqNo; int count = br.Count; string depart = br.depart; DateTime date = br.Date; string booker = br.Booker; int boroower = br.Borrower; string sql = string.Format("insert into borrow values('{0}',{1},'{2}','{3}','{4}','{5}')", eqno, count, depart, boroower, date, booker); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 通过资产编码获得流水单号 /// </summary> /// <param name="departId"></param> /// <returns></returns> public static string GetIDFromEqNo(string eqno) { string sql = string.Format("select top 1 serialNo from FixLog where EqNo='{0}' order by serialNo desc", eqno); sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); string departName = ""; if (dt.Rows.Count > 0) { departName = dt.Rows[0][0].ToString(); } return(departName); }
/// <summary> /// 通过流水号获取审核意见 /// </summary> /// <param name="ID"></param> /// <returns></returns> public static string GetAuditFromID(string ID) { sqlHandler sh = new sqlHandler(); string sql = string.Format("select Audit from ClearLog where serialNo='{0}'", ID); DataTable dt = sh.GetData(sql); string result = ""; if (dt.Rows.Count > 0) { result = dt.Rows[0][0].ToString(); } return(result); }
/// <summary> /// 通过流水单号获得资产状态 /// </summary> /// <param name="departId"></param> /// <returns></returns> public static string GetStateFromSerialNo(string serialNo) { string sql = string.Format("select State from FixLog where serialNo='{0}'", serialNo); sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); string departName = ""; if (dt.Rows.Count > 0) { departName = dt.Rows[0][0].ToString(); } return(departName); }
/// <summary> /// 清理资产 /// </summary> /// <param name="cl"></param> /// <returns></returns> public static bool Clear(Clear cl) { string eqno = cl.EqNo; int count = cl.Count; string cleartype = cl.ClearType; string clearer = cl.Clearer; string remark = cl.Mark; string date = cl.ClearDate; string sql = string.Format("insert into clear values('{0}','{1}','{2}','{3}','{4}','{5}')", eqno, count, cleartype, clearer, date, remark); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 通过部门Id获得部门名称 /// </summary> /// <param name="departId"></param> /// <returns></returns> public static string GetNameFromId(string departId) { string sql = string.Format("select departName from Department where id='{0}'", departId); sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); string departName = ""; if (dt.Rows.Count > 0) { departName = dt.Rows[0][0].ToString(); } return(departName); }
public DataTable GetData(string sql) { sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); if (dt != null) { return(dt); } else { return(null); } }
/// <summary> /// 得到待审核信息单数 /// </summary> /// <returns></returns> public static int getUnAuditListCount(string agent) { sqlHandler sh = new sqlHandler(); string sql = string.Format("select count(*) from (SELECT * FROM View_ClearLog WHERE 状态 IN ('注销待审核','注销审核未通过') AND 注销经办人 = '{0}') AS M", agent); DataTable dt = sh.GetData(sql); int result = 0; if (dt != null) { result = int.Parse(dt.Rows[0][0].ToString()); } return(result); }
/// <summary> /// 得到审核信息单数 /// </summary> /// <returns></returns> public static int getAuditListCount() { sqlHandler sh = new sqlHandler(); string sql = string.Format("select count(*) from (select * from View_ClearLog where 状态 like '%审核') AS M"); DataTable dt = sh.GetData(sql); int result = 0; if (dt != null) { result = int.Parse(dt.Rows[0][0].ToString()); } return(result); }
/// <summary> /// 通过部门名称获取部门编号 /// </summary> /// <param name="departName"></param> /// <returns></returns> public static string GetIdFromName(string departName) { sqlHandler sh = new sqlHandler(); string sql = string.Format("select id from Department where departName='{0}'", departName); DataTable dt = sh.GetData(sql); string result = ""; if (dt.Rows.Count > 0) { result = dt.Rows[0][0].ToString(); } return(result); }
/// <summary> /// 修改员工信息 /// </summary> /// <param name="emp"></param> /// <returns></returns> public static bool Update(Employee emp) { string empNo = emp.EmpId; //string id = emp.ID; string depart = emp.departId; string name = emp.Name; string sex = emp.Sex; string tel = emp.Tel; string email = emp.Email; string sql = string.Format("update employee set name='{0}',sex='{1}',departid='{2}',tel='{4}',email='{5}' where empid={3}", name, sex, depart, empNo, tel, email); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
/// <summary> /// 得到三级部门数量 /// </summary> /// <returns></returns> public static int ThirdCount() { sqlHandler sh = new sqlHandler(); string sql = "select count(*) from Department where pid!='0'"; DataTable dt = sh.GetData(sql); int result = 0; if (dt != null) { result = int.Parse(dt.Rows[0][0].ToString()); } return(result); }
/// <summary> /// 得到资产信息的总条数 /// </summary> /// <returns></returns> public static int LogCount() { sqlHandler sh = new sqlHandler(); string sql = "select count(*) from FixLog"; DataTable dt = sh.GetData(sql); int result = 0; if (dt != null) { result = int.Parse(dt.Rows[0][0].ToString()); } return(result); }
/// <summary> /// 得到所有功能的列表 /// </summary> /// <returns></returns> public static DataTable GetFuncList(int parentid) { string sql = string.Format("select menu_id,menu_desc from Func where parentmenuid={0}", parentid); sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); if (dt != null) { return(dt); } else { return(null); } }
/// <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="uid"></param> /// <param name="pass"></param> /// <returns></returns> public static string Login(string uid, string pass) { string sql = string.Format("exec proc_login '{0}','{1}' ", uid, pass); sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); if (dt != null) { return(dt.Rows[0][0].ToString()); } else { return(null); } }
/// <summary> /// 得到待审核信息 /// </summary> /// <param name="agent">用户</param> /// <returns></returns> public static DataTable getUnAuditList(string agent) { sqlHandler sh = new sqlHandler(); string sql = string.Format("SELECT * FROM View_FixLog WHERE 状态 IN ('送修待审核','送修审核未通过','维修中','完成待审核') AND 送修经办人 = '{0}'", agent); DataTable dt = sh.GetData(sql); if (dt != null) { return(dt); } else { return(null); } }
/// <summary> /// 根据名称获取维修商信息 /// </summary> /// <param name="name"></param> /// <returns></returns> public static DataTable GetInfoByName(string name) { string sql = string.Format("select * from View_Maintainer where 名称 ='{0}' order by 编号", name); sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); if (dt != null) { return(dt); } else { return(null); } }
/// <summary> /// 根据编号获取维修商信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static DataTable GetInfoById(int id) { string sql = string.Format("select * from View_Maintainer where 编号 ={0} order by 编号", id); sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); if (dt != null) { return(dt); } else { return(null); } }
/// <summary> /// 得到所有维修商信息 /// </summary> /// <returns></returns> public static DataTable GetAll() { string sql = "select * from View_Maintainer order by 编号"; sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); if (dt != null) { return(dt); } else { return(null); } }
/// <summary> /// 根据联系人获取维修商信息 /// </summary> /// <param name="contracts"></param> /// <returns></returns> public static DataTable GetInfoByContracts(string contracts) { string sql = string.Format("select * from View_Maintainer where 联系人 ='{0}' order by 编号", contracts); sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); if (dt != null) { return(dt); } else { return(null); } }
/// <summary> /// 得到所有的资产类型 /// </summary> /// <returns></returns> public static DataTable GetAllType() { string sql = "select * from type"; sqlHandler sh = new sqlHandler(); DataTable dt = sh.GetData(sql); if (dt != null) { return(dt); } else { return(null); } }