/// <summary> /// 增加一条数据 /// </summary> public bool Add(SystemLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into systemlog("); strSql.Append("ID,OPERATETYPE,OPERATECONTENT,CREATEDATE,EMPLOYEEID,IPADDRESS,PHYSICALADDRESS)"); strSql.Append(" values ("); strSql.Append("@ID,@OPERATETYPE,@OPERATECONTENT,@CREATEDATE,@EMPLOYEEID,@IPADDRESS,@PHYSICALADDRESS)"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 40), new MySqlParameter("@OPERATETYPE", MySqlDbType.VarChar, 2), new MySqlParameter("@OPERATECONTENT", MySqlDbType.VarChar, 2000), new MySqlParameter("@CREATEDATE", MySqlDbType.DateTime), new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40), new MySqlParameter("@IPADDRESS", MySqlDbType.VarChar, 40), new MySqlParameter("@PHYSICALADDRESS", MySqlDbType.VarChar, 40) }; parameters[0].Value = model.ID; parameters[1].Value = model.OPERATETYPE; parameters[2].Value = model.OPERATECONTENT; parameters[3].Value = model.CREATEDATE; parameters[4].Value = model.EMPLOYEEID; parameters[5].Value = model.IPADDRESS; parameters[6].Value = model.PHYSICALADDRESS; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WithdrawDetails model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into withdrawdetails("); strSql.Append("ID,EMPLOYEEID,WITHDRAWAMOUNT,CREATEDATE,ISCONFIRMED,OPERATEPERSON,ISDELETED)"); strSql.Append(" values ("); strSql.Append("@ID,@EMPLOYEEID,@WITHDRAWAMOUNT,@CREATEDATE,@ISCONFIRMED,@OPERATEPERSON,@ISDELETED)"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 36), new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 36), new MySqlParameter("@WITHDRAWAMOUNT", MySqlDbType.Decimal, 12), new MySqlParameter("@CREATEDATE", MySqlDbType.DateTime), new MySqlParameter("@ISCONFIRMED", MySqlDbType.Bit), new MySqlParameter("@OPERATEPERSON", MySqlDbType.VarChar, 36), new MySqlParameter("@ISDELETED", MySqlDbType.Bit) }; parameters[0].Value = model.ID; parameters[1].Value = model.EMPLOYEEID; parameters[2].Value = model.WITHDRAWAMOUNT; parameters[3].Value = model.CREATEDATE; parameters[4].Value = model.ISCONFIRMED; parameters[5].Value = model.OPERATEPERSON; parameters[6].Value = model.ISDELETED; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(TaskAssignConfigDetails model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into taskassignconfigdetails("); strSql.Append("ID,EMPLOYEEID,SPECIALTYCATEGORY,QUALITYSCORE,AVAILABLE,TIMEMULTIPLE,SPECIALTYTYPE)"); strSql.Append(" values ("); strSql.Append("@ID,@EMPLOYEEID,@SPECIALTYCATEGORY,@QUALITYSCORE,@AVAILABLE,@TIMEMULTIPLE,@SPECIALTYTYPE)"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 40), new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40), new MySqlParameter("@SPECIALTYCATEGORY", MySqlDbType.VarChar, 2), new MySqlParameter("@QUALITYSCORE", MySqlDbType.Decimal, 3), new MySqlParameter("@AVAILABLE", MySqlDbType.Int32, 1), new MySqlParameter("@TIMEMULTIPLE", MySqlDbType.Int32, 2), new MySqlParameter("@SPECIALTYTYPE", MySqlDbType.Int32, 1) }; parameters[0].Value = model.ID; parameters[1].Value = model.EMPLOYEEID; parameters[2].Value = model.SPECIALTYCATEGORY; parameters[3].Value = model.QUALITYSCORE; parameters[4].Value = model.AVAILABLE; parameters[5].Value = model.TIMEMULTIPLE; parameters[6].Value = model.SPECIALTYTYPE; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool DeleteByProjectID(string projectID, string type) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from projectspecialty "); strSql.Append(" where projectID=@projectID and type=@type "); MySqlParameter[] parameters = { new MySqlParameter("@projectID", MySqlDbType.VarChar, 40), new MySqlParameter("@type", MySqlDbType.Int32, 1) }; parameters[0].Value = projectID; parameters[1].Value = type; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FileZillaServerModel.Salary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into salary("); strSql.Append("ID,EMPLOYEEID,MONTHDATE,BASESALARY,CONTRACTSALARY,PIECEWAGE,PIECEPENALTY,FULLATTEND,OVERTIMEWAGE,AGEWAGE,ACCOMMODATION_ALLOWANCE,MEAL_ALLOWANCE,ATTENDANCEPENALTY,OTHERWAGE,TOTALORDERAMOUNT,SOCIALSECURITY_INDIVIDUAL,SOCIALSECURITY_COMPANY,HOUSINGPROVIDENTFUND_INDIVIDUAL,HOUSINGPROVIDENTFUND_COMPANY,TOTALINCOME,REALSALARY,REALSALARY_COMPANY)"); strSql.Append(" values ("); strSql.Append("@ID,@EMPLOYEEID,@MONTHDATE,@BASESALARY,@CONTRACTSALARY,@PIECEWAGE,@PIECEPENALTY,@FULLATTEND,@OVERTIMEWAGE,@AGEWAGE,@ACCOMMODATION_ALLOWANCE,@MEAL_ALLOWANCE,@ATTENDANCEPENALTY,@OTHERWAGE,@TOTALORDERAMOUNT,@SOCIALSECURITY_INDIVIDUAL,@SOCIALSECURITY_COMPANY,@HOUSINGPROVIDENTFUND_INDIVIDUAL,@HOUSINGPROVIDENTFUND_COMPANY,@TOTALINCOME,@REALSALARY,@REALSALARY_COMPANY)"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 40), new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40), new MySqlParameter("@MONTHDATE", MySqlDbType.Date), new MySqlParameter("@BASESALARY", MySqlDbType.Decimal, 10), new MySqlParameter("@CONTRACTSALARY", MySqlDbType.Decimal, 8), new MySqlParameter("@PIECEWAGE", MySqlDbType.Decimal, 8), new MySqlParameter("@PIECEPENALTY", MySqlDbType.Decimal, 8), new MySqlParameter("@FULLATTEND", MySqlDbType.Decimal, 8), new MySqlParameter("@OVERTIMEWAGE", MySqlDbType.Decimal, 8), new MySqlParameter("@AGEWAGE", MySqlDbType.Decimal, 8), new MySqlParameter("@ACCOMMODATION_ALLOWANCE", MySqlDbType.Decimal, 8), new MySqlParameter("@MEAL_ALLOWANCE", MySqlDbType.Decimal, 8), new MySqlParameter("@ATTENDANCEPENALTY", MySqlDbType.Decimal, 8), new MySqlParameter("@OTHERWAGE", MySqlDbType.Decimal, 8), new MySqlParameter("@TOTALORDERAMOUNT", MySqlDbType.Decimal, 8), new MySqlParameter("@SOCIALSECURITY_INDIVIDUAL", MySqlDbType.Decimal, 8), new MySqlParameter("@SOCIALSECURITY_COMPANY", MySqlDbType.Decimal, 8), new MySqlParameter("@HOUSINGPROVIDENTFUND_INDIVIDUAL", MySqlDbType.Decimal, 8), new MySqlParameter("@HOUSINGPROVIDENTFUND_COMPANY", MySqlDbType.Decimal, 8), new MySqlParameter("@TOTALINCOME", MySqlDbType.Decimal, 8), new MySqlParameter("@REALSALARY", MySqlDbType.Decimal, 10), new MySqlParameter("@REALSALARY_COMPANY", MySqlDbType.Decimal, 10) }; parameters[0].Value = model.ID; parameters[1].Value = model.EMPLOYEEID; parameters[2].Value = model.MONTHDATE; parameters[3].Value = model.BASESALARY; parameters[4].Value = model.CONTRACTSALARY; parameters[5].Value = model.PIECEWAGE; parameters[6].Value = model.PIECEPENALTY; parameters[7].Value = model.FULLATTEND; parameters[8].Value = model.OVERTIMEWAGE; parameters[9].Value = model.AGEWAGE; parameters[10].Value = model.ACCOMMODATION_ALLOWANCE; parameters[11].Value = model.MEAL_ALLOWANCE; parameters[12].Value = model.ATTENDANCEPENALTY; parameters[13].Value = model.OTHERWAGE; parameters[14].Value = model.TOTALORDERAMOUNT; parameters[15].Value = model.SOCIALSECURITY_INDIVIDUAL; parameters[16].Value = model.SOCIALSECURITY_COMPANY; parameters[17].Value = model.HOUSINGPROVIDENTFUND_INDIVIDUAL; parameters[18].Value = model.HOUSINGPROVIDENTFUND_COMPANY; parameters[19].Value = model.TOTALINCOME; parameters[20].Value = model.REALSALARY; parameters[21].Value = model.REALSALARY_COMPANY; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FileZillaServerModel.Salary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update salary set "); strSql.Append("EMPLOYEEID=@EMPLOYEEID,"); strSql.Append("MONTHDATE=@MONTHDATE,"); strSql.Append("BASESALARY=@BASESALARY,"); strSql.Append("CONTRACTSALARY=@CONTRACTSALARY,"); strSql.Append("PIECEWAGE=@PIECEWAGE,"); strSql.Append("PIECEPENALTY=@PIECEPENALTY,"); strSql.Append("FULLATTEND=@FULLATTEND,"); strSql.Append("OVERTIMEWAGE=@OVERTIMEWAGE,"); strSql.Append("AGEWAGE=@AGEWAGE,"); strSql.Append("ACCOMMODATION_ALLOWANCE=@ACCOMMODATION_ALLOWANCE,"); strSql.Append("MEAL_ALLOWANCE=@MEAL_ALLOWANCE,"); strSql.Append("ATTENDANCEPENALTY=@ATTENDANCEPENALTY,"); strSql.Append("OTHERWAGE=@OTHERWAGE,"); strSql.Append("TOTALORDERAMOUNT=@TOTALORDERAMOUNT,"); strSql.Append("SOCIALSECURITY_INDIVIDUAL=@SOCIALSECURITY_INDIVIDUAL,"); strSql.Append("SOCIALSECURITY_COMPANY=@SOCIALSECURITY_COMPANY,"); strSql.Append("HOUSINGPROVIDENTFUND_INDIVIDUAL=@HOUSINGPROVIDENTFUND_INDIVIDUAL,"); strSql.Append("HOUSINGPROVIDENTFUND_COMPANY=@HOUSINGPROVIDENTFUND_COMPANY,"); strSql.Append("TOTALINCOME=@TOTALINCOME,"); strSql.Append("REALSALARY=@REALSALARY,"); strSql.Append("REALSALARY_COMPANY=@REALSALARY_COMPANY"); strSql.Append(" where ID=@ID "); MySqlParameter[] parameters = { new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40), new MySqlParameter("@MONTHDATE", MySqlDbType.Date), new MySqlParameter("@BASESALARY", MySqlDbType.Decimal, 10), new MySqlParameter("@CONTRACTSALARY", MySqlDbType.Decimal, 8), new MySqlParameter("@PIECEWAGE", MySqlDbType.Decimal, 8), new MySqlParameter("@PIECEPENALTY", MySqlDbType.Decimal, 8), new MySqlParameter("@FULLATTEND", MySqlDbType.Decimal, 8), new MySqlParameter("@OVERTIMEWAGE", MySqlDbType.Decimal, 8), new MySqlParameter("@AGEWAGE", MySqlDbType.Decimal, 8), new MySqlParameter("@ACCOMMODATION_ALLOWANCE", MySqlDbType.Decimal, 8), new MySqlParameter("@MEAL_ALLOWANCE", MySqlDbType.Decimal, 8), new MySqlParameter("@ATTENDANCEPENALTY", MySqlDbType.Decimal, 8), new MySqlParameter("@OTHERWAGE", MySqlDbType.Decimal, 8), new MySqlParameter("@TOTALORDERAMOUNT", MySqlDbType.Decimal, 8), new MySqlParameter("@SOCIALSECURITY_INDIVIDUAL", MySqlDbType.Decimal, 8), new MySqlParameter("@SOCIALSECURITY_COMPANY", MySqlDbType.Decimal, 8), new MySqlParameter("@HOUSINGPROVIDENTFUND_INDIVIDUAL", MySqlDbType.Decimal, 8), new MySqlParameter("@HOUSINGPROVIDENTFUND_COMPANY", MySqlDbType.Decimal, 8), new MySqlParameter("@TOTALINCOME", MySqlDbType.Decimal, 8), new MySqlParameter("@REALSALARY", MySqlDbType.Decimal, 10), new MySqlParameter("@REALSALARY_COMPANY", MySqlDbType.Decimal, 10), new MySqlParameter("@ID", MySqlDbType.VarChar, 40) }; parameters[0].Value = model.EMPLOYEEID; parameters[1].Value = model.MONTHDATE; parameters[2].Value = model.BASESALARY; parameters[3].Value = model.CONTRACTSALARY; parameters[4].Value = model.PIECEWAGE; parameters[5].Value = model.PIECEPENALTY; parameters[6].Value = model.FULLATTEND; parameters[7].Value = model.OVERTIMEWAGE; parameters[8].Value = model.AGEWAGE; parameters[9].Value = model.ACCOMMODATION_ALLOWANCE; parameters[10].Value = model.MEAL_ALLOWANCE; parameters[11].Value = model.ATTENDANCEPENALTY; parameters[12].Value = model.OTHERWAGE; parameters[13].Value = model.TOTALORDERAMOUNT; parameters[14].Value = model.SOCIALSECURITY_INDIVIDUAL; parameters[15].Value = model.SOCIALSECURITY_COMPANY; parameters[16].Value = model.HOUSINGPROVIDENTFUND_INDIVIDUAL; parameters[17].Value = model.HOUSINGPROVIDENTFUND_COMPANY; parameters[18].Value = model.TOTALINCOME; parameters[19].Value = model.REALSALARY; parameters[20].Value = model.REALSALARY_COMPANY; parameters[21].Value = model.ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Employee model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update employee set "); strSql.Append("EMPLOYEENO=@EMPLOYEENO,"); strSql.Append("PASSWORD=@PASSWORD,"); strSql.Append("NAME=@NAME,"); strSql.Append("SEX=@SEX,"); strSql.Append("BIRTHDATE=@BIRTHDATE,"); strSql.Append("NATIVEPLACE=@NATIVEPLACE,"); strSql.Append("MOBILEPHONE=@MOBILEPHONE,"); strSql.Append("ADDRESS=@ADDRESS,"); strSql.Append("EMAIL=@EMAIL,"); strSql.Append("TOREGULARDATE=@TOREGULARDATE,"); strSql.Append("BANKCARD=@BANKCARD,"); strSql.Append("DEPARTMENTID=@DEPARTMENTID,"); strSql.Append("POLITICALSTATUS=@POLITICALSTATUS,"); strSql.Append("TYPE=@TYPE,"); strSql.Append("ISBRANCHLEADER=@ISBRANCHLEADER,"); strSql.Append("ISEXTERNAL=@ISEXTERNAL,"); strSql.Append("AVAILABLE=@AVAILABLE,"); strSql.Append("DINGTALKUSERID=@DINGTALKUSERID"); strSql.Append(" where ID=@ID "); MySqlParameter[] parameters = { new MySqlParameter("@EMPLOYEENO", MySqlDbType.VarChar, 50), new MySqlParameter("@PASSWORD", MySqlDbType.VarChar, 200), new MySqlParameter("@NAME", MySqlDbType.VarChar, 100), new MySqlParameter("@SEX", MySqlDbType.Bit), new MySqlParameter("@BIRTHDATE", MySqlDbType.DateTime), new MySqlParameter("@NATIVEPLACE", MySqlDbType.VarChar, 40), new MySqlParameter("@MOBILEPHONE", MySqlDbType.VarChar, 20), new MySqlParameter("@ADDRESS", MySqlDbType.VarChar, 255), new MySqlParameter("@EMAIL", MySqlDbType.VarChar, 50), new MySqlParameter("@TOREGULARDATE", MySqlDbType.DateTime), new MySqlParameter("@BANKCARD", MySqlDbType.VarChar, 20), new MySqlParameter("@DEPARTMENTID", MySqlDbType.VarChar, 40), new MySqlParameter("@POLITICALSTATUS", MySqlDbType.VarChar, 20), new MySqlParameter("@TYPE", MySqlDbType.Decimal, 1), new MySqlParameter("@ISBRANCHLEADER", MySqlDbType.Bit), new MySqlParameter("@ISEXTERNAL", MySqlDbType.Bit), new MySqlParameter("@AVAILABLE", MySqlDbType.Decimal, 1), new MySqlParameter("@DINGTALKUSERID", MySqlDbType.VarChar, 40), new MySqlParameter("@ID", MySqlDbType.VarChar, 40) }; parameters[0].Value = model.EMPLOYEENO; parameters[1].Value = model.PASSWORD; parameters[2].Value = model.NAME; parameters[3].Value = model.SEX; parameters[4].Value = model.BIRTHDATE; parameters[5].Value = model.NATIVEPLACE; parameters[6].Value = model.MOBILEPHONE; parameters[7].Value = model.ADDRESS; parameters[8].Value = model.EMAIL; parameters[9].Value = model.TOREGULARDATE; parameters[10].Value = model.BANKCARD; parameters[11].Value = model.DEPARTMENTID; parameters[12].Value = model.POLITICALSTATUS; parameters[13].Value = model.TYPE; parameters[14].Value = model.ISBRANCHLEADER; parameters[15].Value = model.ISEXTERNAL; parameters[16].Value = model.AVAILABLE; parameters[17].Value = model.DINGTALKUSERID; parameters[18].Value = model.ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Employee model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into employee("); strSql.Append("ID,EMPLOYEENO,PASSWORD,NAME,SEX,BIRTHDATE,NATIVEPLACE,MOBILEPHONE,ADDRESS,EMAIL,TOREGULARDATE,BANKCARD,DEPARTMENTID,POLITICALSTATUS,TYPE,ISBRANCHLEADER,ISEXTERNAL,AVAILABLE,DINGTALKUSERID)"); strSql.Append(" values ("); strSql.Append("@ID,@EMPLOYEENO,@PASSWORD,@NAME,@SEX,@BIRTHDATE,@NATIVEPLACE,@MOBILEPHONE,@ADDRESS,@EMAIL,@TOREGULARDATE,@BANKCARD,@DEPARTMENTID,@POLITICALSTATUS,@TYPE,@ISBRANCHLEADER,@ISEXTERNAL,@AVAILABLE,@DINGTALKUSERID)"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 40), new MySqlParameter("@EMPLOYEENO", MySqlDbType.VarChar, 50), new MySqlParameter("@PASSWORD", MySqlDbType.VarChar, 200), new MySqlParameter("@NAME", MySqlDbType.VarChar, 100), new MySqlParameter("@SEX", MySqlDbType.Bit), new MySqlParameter("@BIRTHDATE", MySqlDbType.Date), new MySqlParameter("@NATIVEPLACE", MySqlDbType.VarChar, 40), new MySqlParameter("@MOBILEPHONE", MySqlDbType.VarChar, 20), new MySqlParameter("@ADDRESS", MySqlDbType.VarChar, 255), new MySqlParameter("@EMAIL", MySqlDbType.VarChar, 50), new MySqlParameter("@TOREGULARDATE", MySqlDbType.Date), new MySqlParameter("@BANKCARD", MySqlDbType.VarChar, 20), new MySqlParameter("@DEPARTMENTID", MySqlDbType.VarChar, 40), new MySqlParameter("@POLITICALSTATUS", MySqlDbType.VarChar, 20), new MySqlParameter("@TYPE", MySqlDbType.Decimal, 1), new MySqlParameter("@ISBRANCHLEADER", MySqlDbType.Bit), new MySqlParameter("@ISEXTERNAL", MySqlDbType.Bit), new MySqlParameter("@AVAILABLE", MySqlDbType.Decimal, 1), new MySqlParameter("@DINGTALKUSERID", MySqlDbType.VarChar, 40) }; parameters[0].Value = model.ID; parameters[1].Value = model.EMPLOYEENO; parameters[2].Value = model.PASSWORD; parameters[3].Value = model.NAME; parameters[4].Value = model.SEX; parameters[5].Value = model.BIRTHDATE; parameters[6].Value = model.NATIVEPLACE; parameters[7].Value = model.MOBILEPHONE; parameters[8].Value = model.ADDRESS; parameters[9].Value = model.EMAIL; parameters[10].Value = model.TOREGULARDATE; parameters[11].Value = model.BANKCARD; parameters[12].Value = model.DEPARTMENTID; parameters[13].Value = model.POLITICALSTATUS; parameters[14].Value = model.TYPE; parameters[15].Value = model.ISBRANCHLEADER; parameters[16].Value = model.ISEXTERNAL; parameters[17].Value = model.AVAILABLE; parameters[18].Value = model.DINGTALKUSERID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }