/// <summary> /// 更新工资录入申请信息 /// </summary> /// <param name="model">工资录入申请信息</param> /// <returns></returns> private static SqlCommand UpdateSalaryEmployeeInfo(SalaryEmployeeModel model) { #region SQL文拼写 StringBuilder updateSql = new StringBuilder(); updateSql.AppendLine(" UPDATE officedba.SalaryEmployee "); updateSql.AppendLine(" SET "); updateSql.AppendLine(" Flag = @Flag "); updateSql.AppendLine(" ,SalaryMoney = @SalaryMoney "); updateSql.AppendLine(" ,ModifiedDate = getdate() "); updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID "); updateSql.AppendLine(" WHERE "); updateSql.AppendLine(" CompanyCD = @CompanyCD "); updateSql.AppendLine(" AND ItemNo = @ItemNo "); updateSql.AppendLine(" AND EmployeeID = @EmployeeID "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = updateSql.ToString(); //其他参数 SetSaveParameter(comm, model); //执行更新 return comm; }
/// <summary> /// 保存时参数设置 /// </summary> /// <param name="comm">命令</param> /// <param name="model">员工工资信息</param> private static void SetSaveParameter(SqlCommand comm, SalaryEmployeeModel model) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID));//员工ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@Flag", model.Flag));//区分 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemNo", model.ItemNo));//工资项编号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@SalaryMoney", model.SalaryMoney));//金额 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//更新用户ID }
/// <summary> /// 新建工资录入申请信息 /// </summary> /// <param name="model">工资录入申请信息</param> /// <returns></returns> private static SqlCommand InsertSalaryEmployeeInfo(SalaryEmployeeModel model) { #region 登陆SQL文 StringBuilder insertSql = new StringBuilder(); insertSql.AppendLine(" INSERT INTO "); insertSql.AppendLine(" officedba.SalaryEmployee "); insertSql.AppendLine(" (CompanyCD "); insertSql.AppendLine(" ,EmployeeID "); insertSql.AppendLine(" ,Flag "); insertSql.AppendLine(" ,ItemNo "); insertSql.AppendLine(" ,SalaryMoney "); insertSql.AppendLine(" ,ModifiedDate "); insertSql.AppendLine(" ,ModifiedUserID) "); insertSql.AppendLine(" VALUES "); insertSql.AppendLine(" (@CompanyCD "); insertSql.AppendLine(" ,@EmployeeID "); insertSql.AppendLine(" ,@Flag "); insertSql.AppendLine(" ,@ItemNo "); insertSql.AppendLine(" ,@SalaryMoney "); insertSql.AppendLine(" ,getdate() "); insertSql.AppendLine(" ,@ModifiedUserID) "); insertSql.AppendLine(" SET @SalaryEmployeeID = @@IDENTITY "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); //设置存储过程名 comm.CommandText = insertSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //添加返回参数 comm.Parameters.Add(SqlHelper.GetOutputParameter("@SalaryEmployeeID", SqlDbType.Int)); //执行插入并返回插入结果 return comm; }