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