/// <summary>
/// 执行保存操作
/// </summary>
/// <param name="DeptID"></param>
/// <param name="ModelList"></param>
/// <returns></returns>
public static bool SaveInfo(string EmployeeID, SalaryEmployeeStructureSetModel Model)
{
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
try
{
isSucc = SalaryEmployeeStructureSetDBHelper.SaveInfo(EmployeeID, Model);
}
catch (Exception ex)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//输出日志
WriteSystemLog(userInfo, ex);
}
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//操作日志
LogInfoModel logModel = InitLogInfo(EmployeeID);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return isSucc;
}
/// <summary>
/// 执行保存操作
/// </summary>
/// <param name="DeptID"></param>
/// <param name="ModelList"></param>
/// <returns></returns>
public static bool SaveInfo(string EmployeeID, SalaryEmployeeStructureSetModel Model)
{
ArrayList lstUpdate = new ArrayList();
string strSqlDel = "Delete from officedba.SalaryEmployeeStructureSet where EmployeeID=@EmployeeID";
SqlCommand commDel = new SqlCommand();
commDel.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", EmployeeID));
commDel.CommandText = strSqlDel;
//先删除所有当前分公司的所有记录
lstUpdate.Add(commDel);
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into officedba.SalaryEmployeeStructureSet(");
strSql.Append("EmployeeID,CompanyCD,IsCompanyRoyaltySet,IsDeptRoyaltySet,IsProductRoyaltySet,IsFixSalarySet,IsPieceWorkSet,IsInsurenceSet,IsPerIncomeTaxSet,IsQuteerSet,IsTimeWorkSet,IsPersonalRoyaltySet,ModifiedUserID,ModifiedDate,IsPerformanceSet,CompanyRatePercent,DeptRatePercent)");
strSql.Append(" values (");
strSql.Append("@EmployeeID,@CompanyCD,@IsCompanyRoyaltySet,@IsDeptRoyaltySet,@IsProductRoyaltySet,@IsFixSalarySet,@IsPieceWorkSet,@IsInsurenceSet,@IsPerIncomeTaxSet,@IsQuteerSet,@IsTimeWorkSet,@IsPersonalRoyaltySet,@ModifiedUserID,getdate(),@IsPerformanceSet,@CompanyRatePercent,@DeptRatePercent)");
strSql.Append(";select @@IDENTITY");
SqlCommand InserComm = new SqlCommand();
InserComm.CommandText = strSql.ToString();
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID ", Model.EmployeeID));
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD ", Model.CompanyCD));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsCompanyRoyaltySet ", Model.IsCompanyRoyaltySet));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsDeptRoyaltySet ", Model.IsDeptRoyaltySet));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsProductRoyaltySet ", Model.IsProductRoyaltySet));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsFixSalarySet ", Model.IsFixSalarySet));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsPieceWorkSet ", Model.IsPieceWorkSet));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsInsurenceSet ", Model.IsInsurenceSet));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsPerIncomeTaxSet ", Model.IsPerIncomeTaxSet));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsQuteerSet ", Model.IsQuteerSet));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsTimeWorkSet ", Model.IsTimeWorkSet));//分公司ID
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsPersonalRoyaltySet ", Model.IsPersonalRoyaltySet));//
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID ", Model.ModifiedUserID));//
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@IsPerformanceSet ", Model.IsPerformanceSet));//
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyRatePercent ", Model.CompanyRatePercent));//
InserComm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptRatePercent ", Model.DeptRatePercent));//
//把插入Command加入集合
lstUpdate.Add(InserComm);
return SqlHelper.ExecuteTransWithArrayList(lstUpdate);
}
