/// <summary> /// 保存时参数设置 /// </summary> /// <param name="comm">命令</param> /// <param name="model">人才代理信息</param> private static void SetSaveParameter(SqlCommand comm, SalaryItemModel model) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemName", model.ItemName));//工资项名称 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemOrder", model.ItemOrder));//排列先后顺序 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Calculate", model.Calculate));//计算公式 comm.Parameters.Add(SqlHelper.GetParameterFromString("@PayFlag", model.PayFlag));//是否扣款(0否,1是) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ChangeFlag", model.ChangeFlag));//是否为固定项(0否,1是) comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));//启用状态(0停用,1启用) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));//备注 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ParamsList", model.CalculateParam ));//备注 }
/// <summary> /// 更新工资项申请信息 /// </summary> /// <param name="model">工资项申请信息</param> /// <returns></returns> private static SqlCommand UpdateSalaryItemInfo(SalaryItemModel model,string CompanyCD) { #region SQL文拼写 StringBuilder updateSql = new StringBuilder(); updateSql.AppendLine(" UPDATE officedba.SalaryItem "); updateSql.AppendLine(" SET "); updateSql.AppendLine(" ItemName = @ItemName "); updateSql.AppendLine(" ,ItemOrder = @ItemOrder "); updateSql.AppendLine(" ,Calculate = @Calculate "); updateSql.AppendLine(" ,ParamsList = @ParamsList "); updateSql.AppendLine(" ,PayFlag = @PayFlag "); updateSql.AppendLine(" ,ChangeFlag = @ChangeFlag "); updateSql.AppendLine(" ,UsedStatus = @UsedStatus "); updateSql.AppendLine(" ,Remark = @Remark "); updateSql.AppendLine(" WHERE "); updateSql.AppendLine("CompanyCD = @CompanyCD and "); updateSql.AppendLine(" ItemNo = @ItemNo "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = updateSql.ToString(); //工资项编号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemNo", model.ItemNo)); //其他参数 SetSaveParameter(comm, model); //执行更新 return comm; }
/// <summary> /// 新建工资项申请信息 /// </summary> /// <param name="model">工资项申请信息</param> /// <returns></returns> private static SqlCommand InsertSalaryItemInfo(SalaryItemModel model) { #region 登陆SQL文 StringBuilder insertSql = new StringBuilder(); insertSql.AppendLine(" INSERT INTO "); insertSql.AppendLine(" officedba.SalaryItem "); insertSql.AppendLine(" (CompanyCD "); insertSql.AppendLine(" ,ItemName "); insertSql.AppendLine(" ,ItemOrder "); insertSql.AppendLine(" ,Calculate "); insertSql.AppendLine(" ,ParamsList "); insertSql.AppendLine(" ,PayFlag "); insertSql.AppendLine(" ,ChangeFlag "); insertSql.AppendLine(" ,UsedStatus "); insertSql.AppendLine(" ,Remark) "); insertSql.AppendLine(" VALUES "); insertSql.AppendLine(" (@CompanyCD "); insertSql.AppendLine(" ,@ItemName "); insertSql.AppendLine(" ,@ItemOrder "); insertSql.AppendLine(" ,@Calculate "); insertSql.AppendLine(" ,@ParamsList "); insertSql.AppendLine(" ,@PayFlag "); insertSql.AppendLine(" ,@ChangeFlag "); insertSql.AppendLine(" ,@UsedStatus "); insertSql.AppendLine(" ,@Remark) "); insertSql.AppendLine(" SET @SalaryItemNo= @@IDENTITY "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); //设置存储过程名 comm.CommandText = insertSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //添加返回参数 comm.Parameters.Add(SqlHelper.GetOutputParameter("@SalaryItemNo", SqlDbType.Int)); //执行插入并返回插入结果 return comm; }
public static bool InsertSalaryItem(SalaryItemModel model) { #region 插入SQL拼写 StringBuilder insertSql = new StringBuilder(); insertSql.AppendLine(" INSERT INTO "); insertSql.AppendLine(" officedba.SalaryItem "); insertSql.AppendLine(" (CompanyCD "); insertSql.AppendLine(" ,ItemName "); insertSql.AppendLine(" ,ItemOrder "); insertSql.AppendLine(" ,Calculate "); insertSql.AppendLine(" ,PayFlag "); insertSql.AppendLine(" ,ChangeFlag "); insertSql.AppendLine(" ,UsedStatus "); insertSql.AppendLine(" ,Remark) "); insertSql.AppendLine(" VALUES "); insertSql.AppendLine(" (@CompanyCD "); insertSql.AppendLine(" ,@ItemName "); insertSql.AppendLine(" ,@ItemOrder "); insertSql.AppendLine(" ,@Calculate "); insertSql.AppendLine(" ,@PayFlag "); insertSql.AppendLine(" ,@ChangeFlag "); insertSql.AppendLine(" ,@UsedStatus "); insertSql.AppendLine(" ,@Remark) "); // insertSql.AppendLine(" set @ElemID= @@IDENTITY "); #endregion //定义插入基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = insertSql.ToString(); //设置保存的参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemName", model.ItemName));//工资项名称 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemOrder", model.ItemOrder));//排列先后顺序 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Calculate", model.Calculate));//计算公式 comm.Parameters.Add(SqlHelper.GetParameterFromString("@PayFlag", model.PayFlag));//是否扣款(0否,1是) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ChangeFlag", model.ChangeFlag));//是否为固定项(0否,1是) comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));//启用状态(0停用,1启用) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));//备注 //添加返回参数 // comm.Parameters.Add(SqlHelper.GetOutputParameter("@ElemID", SqlDbType.Int)); //执行插入操作 bool isSucc = SqlHelper.ExecuteTransWithCommand(comm); return isSucc; }
public static bool InsertSalaryItem(SalaryItemModel model) { //定义返回变量 bool isSucc = true; //信息存在时,进行操作 if (model != null ) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //执行保存操作 try { //执行保存操作 isSucc = SalaryItemDBHelper.InsertSalaryItem(model); } catch (Exception ex) { //输出系统日志 WriteSystemLog(userInfo, ex); } //操作日志 LogInfoModel logModel = InitLogInfo(userInfo.CompanyCD); //设置关键元素 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //更新成功时 if (isSucc) { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } //更新不成功 else { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } //登陆日志 LogDBHelper.InsertLog(logModel); } return isSucc; }