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