public void UpdateDataSet(Model.MonthlySalaryStruct monthlySalaryStruct)
{
using (SqlConnection conn = new SqlConnection(sqlmapper.DataSource.ConnectionString))
{
using (SqlCommand command = new SqlCommand("update MonthlySalary set EffectFactor=@EffectFactor,OtherPay=@OtherPay,OtherPunish=@OtherPunish,HolidayBonusGivenDays=@HolidayBonusGivenDays where EmployeeId=@EmployeeId and convert(varchar(20),IdentifyDate,101)=convert(varchar(20),@IdentifyDate,101)", conn))
{
conn.Open();
//SqlParameter[] sqlParameter = new SqlParameter[]{
// new SqlParameter("@MonthlySalaryId",SqlDbType.VarChar,50) ,
// new SqlParameter("@EffectFactor",SqlDbType.Money,8),
// new SqlParameter("@OtherPay",SqlDbType.Money,8),
// new SqlParameter("@OtherPunish",SqlDbType.Money,8),
// new SqlParameter("@AnnualBonus",SqlDbType.Money,8) ,
// new SqlParameter("@EmployeeId",SqlDbType.VarChar,50),
// new SqlParameter("@IdentifyDate",SqlDbType.DateTime,8)
// };
//da.InsertCommand.Parameters["@MonthlySalaryId"].Value = monthlySalaryStruct.MonthlySalaryId;
//da.InsertCommand.Parameters["@EffectFactor"].Value = monthlySalaryStruct.EffectFactor;
//da.InsertCommand.Parameters["@OtherPay"].Value = monthlySalaryStruct.OtherPay;
//da.InsertCommand.Parameters["@OtherPunish"].Value = monthlySalaryStruct.OtherPunish;
//da.InsertCommand.Parameters["@AnnualBonus"].Value = monthlySalaryStruct.AnnualBonus;
//da.InsertCommand.Parameters["@EmployeeId"].Value = monthlySalaryStruct.EmployeeId;
//da.InsertCommand.Parameters["@IdentifyDate"].Value = monthlySalaryStruct.IdentifyDate;
//da.UpdateCommand = new SqlCommand("update MonthlySalary set EffectFactor=@EffectFactor,OtherPay=@OtherPay,OtherPunish=@OtherPunish,HolidayBonusGivenDays=@HolidayBonusGivenDays where EmployeeId=@EmployeeId and convert(varchar(20),IdentifyDate,101)=convert(varchar(20),@IdentifyDate,101)", conn);
SqlParameter[] sqlParameter1 = new SqlParameter[] {
new SqlParameter("@EffectFactor", SqlDbType.Money, 8),
new SqlParameter("@OtherPay", SqlDbType.Money, 8),
new SqlParameter("@OtherPunish", SqlDbType.Money, 8),
new SqlParameter("@AnnualBonus", SqlDbType.Money, 8),
new SqlParameter("@EmployeeId", SqlDbType.VarChar, 50),
new SqlParameter("@IdentifyDate", SqlDbType.DateTime, 8),
new SqlParameter("@HolidayBonusGivenDays", SqlDbType.Float, 8)
};
command.Parameters.AddRange(sqlParameter1);
command.Parameters["@EffectFactor"].Value = monthlySalaryStruct.EffectFactor;
command.Parameters["@OtherPay"].Value = monthlySalaryStruct.OtherPay;
command.Parameters["@OtherPunish"].Value = monthlySalaryStruct.OtherPunish;
command.Parameters["@AnnualBonus"].Value = monthlySalaryStruct.AnnualBonus;
command.Parameters["@EmployeeId"].Value = monthlySalaryStruct.EmployeeId;
command.Parameters["@IdentifyDate"].Value = monthlySalaryStruct.IdentifyDate;
command.Parameters["@HolidayBonusGivenDays"].Value = monthlySalaryStruct.HolidayBonusGivenDays;
command.ExecuteNonQuery();
}
}
}
public void UpdateDataSet(Model.MonthlySalaryStruct monthlySalaryStruct)
{
accessor.UpdateDataSet(monthlySalaryStruct);
}
public void UpdateDataSet(Model.MonthlySalaryStruct monthlySalaryStruct)
{
using (SqlConnection conn = new SqlConnection(sqlmapper.DataSource.ConnectionString))
{
using (SqlCommand command = new SqlCommand("update MonthlySalary set EffectFactor=@EffectFactor,OtherPay=@OtherPay,OtherPunish=@OtherPunish,HolidayBonusGivenDays=@HolidayBonusGivenDays,JiuYuanKouJiao=@JiuYuanKouJiao where EmployeeId=@EmployeeId and convert(varchar(20),IdentifyDate,101)=convert(varchar(20),@IdentifyDate,101)", conn))
{
conn.Open();
//SqlParameter[] sqlParameter = new SqlParameter[]{
// new SqlParameter("@MonthlySalaryId",SqlDbType.VarChar,50) ,
// new SqlParameter("@EffectFactor",SqlDbType.Money,8),
// new SqlParameter("@OtherPay",SqlDbType.Money,8),
// new SqlParameter("@OtherPunish",SqlDbType.Money,8),
// new SqlParameter("@AnnualBonus",SqlDbType.Money,8) ,
// new SqlParameter("@EmployeeId",SqlDbType.VarChar,50),
// new SqlParameter("@IdentifyDate",SqlDbType.DateTime,8)
// };
//da.InsertCommand.Parameters["@MonthlySalaryId"].Value = monthlySalaryStruct.MonthlySalaryId;
//da.InsertCommand.Parameters["@EffectFactor"].Value = monthlySalaryStruct.EffectFactor;
//da.InsertCommand.Parameters["@OtherPay"].Value = monthlySalaryStruct.OtherPay;
//da.InsertCommand.Parameters["@OtherPunish"].Value = monthlySalaryStruct.OtherPunish;
//da.InsertCommand.Parameters["@AnnualBonus"].Value = monthlySalaryStruct.AnnualBonus;
//da.InsertCommand.Parameters["@EmployeeId"].Value = monthlySalaryStruct.EmployeeId;
//da.InsertCommand.Parameters["@IdentifyDate"].Value = monthlySalaryStruct.IdentifyDate;
//da.UpdateCommand = new SqlCommand("update MonthlySalary set EffectFactor=@EffectFactor,OtherPay=@OtherPay,OtherPunish=@OtherPunish,HolidayBonusGivenDays=@HolidayBonusGivenDays where EmployeeId=@EmployeeId and convert(varchar(20),IdentifyDate,101)=convert(varchar(20),@IdentifyDate,101)", conn);
SqlParameter[] sqlParameter1 = new SqlParameter[] {
new SqlParameter("@EffectFactor", SqlDbType.Money, 8),
new SqlParameter("@OtherPay", SqlDbType.Money, 8),
new SqlParameter("@OtherPunish", SqlDbType.Money, 8),
new SqlParameter("@AnnualBonus", SqlDbType.Money, 8),
new SqlParameter("@EmployeeId", SqlDbType.VarChar, 50),
new SqlParameter("@IdentifyDate", SqlDbType.DateTime, 8),
new SqlParameter("@HolidayBonusGivenDays", SqlDbType.Float, 8),
new SqlParameter("@JiuYuanKouJiao", SqlDbType.Float, 8)
};
command.Parameters.AddRange(sqlParameter1);
command.Parameters["@EffectFactor"].Value = monthlySalaryStruct.EffectFactor;
command.Parameters["@OtherPay"].Value = monthlySalaryStruct.OtherPay;
command.Parameters["@OtherPunish"].Value = monthlySalaryStruct.OtherPunish;
command.Parameters["@AnnualBonus"].Value = monthlySalaryStruct.AnnualBonus;
command.Parameters["@EmployeeId"].Value = monthlySalaryStruct.EmployeeId;
command.Parameters["@IdentifyDate"].Value = monthlySalaryStruct.IdentifyDate;
command.Parameters["@HolidayBonusGivenDays"].Value = monthlySalaryStruct.HolidayBonusGivenDays;
command.Parameters["@JiuYuanKouJiao"].Value = monthlySalaryStruct.JiuYuanKouJiao;
if (command.ExecuteNonQuery() == 0)
{
Model.Employee employee = new EmployeeAccessor().Get(monthlySalaryStruct.EmployeeId);
if (employee != null)
{
SqlCommand cmd = new SqlCommand("insert into MonthlySalary(MonthlySalaryId,IdentifyDate,EmployeeId,DailyPay,MonthlyPay,DutyPay,PostPay,FieldPay,Insurance,Tax,EffectFactor,OtherPay,OtherPunish,HolidayBonusGivenDays,JiuYuanKouJiao) values('" + monthlySalaryStruct.MonthlySalaryId + "','" + monthlySalaryStruct.IdentifyDate + "','" + monthlySalaryStruct.EmployeeId + "','" + employee.DailyPay + "','" + employee.MonthlyPay + "','" + employee.DutyPay + "','" + employee.PostPay + "','" + employee.FieldPay + "','" + employee.Insurance + "','" + employee.Tax + "',@EffectFactor,@OtherPay,@OtherPunish,@HolidayBonusGivenDays,@JiuYuanKouJiao)", conn);
SqlParameter[] sqlParameter2 = new SqlParameter[] {
new SqlParameter("@EffectFactor", SqlDbType.Money, 8),
new SqlParameter("@OtherPay", SqlDbType.Money, 8),
new SqlParameter("@OtherPunish", SqlDbType.Money, 8),
new SqlParameter("@AnnualBonus", SqlDbType.Money, 8),
new SqlParameter("@EmployeeId", SqlDbType.VarChar, 50),
new SqlParameter("@IdentifyDate", SqlDbType.DateTime, 8),
new SqlParameter("@HolidayBonusGivenDays", SqlDbType.Float, 8),
new SqlParameter("@JiuYuanKouJiao", SqlDbType.Float, 8)
};
cmd.Parameters.AddRange(sqlParameter2);
cmd.Parameters["@EffectFactor"].Value = monthlySalaryStruct.EffectFactor;
cmd.Parameters["@OtherPay"].Value = monthlySalaryStruct.OtherPay;
cmd.Parameters["@OtherPunish"].Value = monthlySalaryStruct.OtherPunish;
cmd.Parameters["@AnnualBonus"].Value = monthlySalaryStruct.AnnualBonus;
cmd.Parameters["@EmployeeId"].Value = monthlySalaryStruct.EmployeeId;
cmd.Parameters["@IdentifyDate"].Value = monthlySalaryStruct.IdentifyDate;
cmd.Parameters["@HolidayBonusGivenDays"].Value = monthlySalaryStruct.HolidayBonusGivenDays;
cmd.Parameters["@JiuYuanKouJiao"].Value = monthlySalaryStruct.JiuYuanKouJiao;
cmd.ExecuteNonQuery();
}
}
}
}
}
