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