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