/// <summary> /// 更新计时工资项信息 /// </summary> /// <param name="model">计时工资项信息</param> /// <returns></returns> private static SqlCommand UpdateTimeItemInfo(TimeItemModel model) { #region SQL文拼写 StringBuilder updateSql = new StringBuilder(); updateSql.AppendLine(" UPDATE officedba.TimeItem "); updateSql.AppendLine(" SET TimeName = @TimeName "); updateSql.AppendLine(" ,UnitPrice = @UnitPrice "); updateSql.AppendLine(" ,UsedStatus = @UsedStatus "); updateSql.AppendLine(" ,ModifiedDate = getdate() "); updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID "); updateSql.AppendLine(" WHERE "); updateSql.AppendLine(" CompanyCD = @CompanyCD "); updateSql.AppendLine(" AND TimeNo = @TimeNo "); #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, TimeItemModel model) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@TimeNo", model.TimeNo));//计时工资项编号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@TimeName", model.TimeName));//计时工资项名称 comm.Parameters.Add(SqlHelper.GetParameterFromString("@UnitPrice", model.UnitPrice));//单价 comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));//启用状态(0停用,1启用) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//最后修改人 }
/// <summary> /// 新建计时工资项信息 /// </summary> /// <param name="model">计时工资项信息</param> /// <returns></returns> private static SqlCommand InsertTimeItemInfo(TimeItemModel model) { #region 登陆SQL文 StringBuilder insertSql = new StringBuilder(); insertSql.AppendLine(" INSERT INTO "); insertSql.AppendLine(" officedba.TimeItem "); insertSql.AppendLine(" (CompanyCD "); insertSql.AppendLine(" ,TimeNo "); insertSql.AppendLine(" ,TimeName "); insertSql.AppendLine(" ,UnitPrice "); insertSql.AppendLine(" ,UsedStatus "); insertSql.AppendLine(" ,ModifiedDate "); insertSql.AppendLine(" ,ModifiedUserID) "); insertSql.AppendLine(" VALUES "); insertSql.AppendLine(" (@CompanyCD "); insertSql.AppendLine(" ,@TimeNo "); insertSql.AppendLine(" ,@TimeName "); insertSql.AppendLine(" ,@UnitPrice "); insertSql.AppendLine(" ,@UsedStatus "); insertSql.AppendLine(" ,getdate() "); insertSql.AppendLine(" ,@ModifiedUserID) "); insertSql.AppendLine(" SET @SalaryID= @@IDENTITY "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); //设置存储过程名 comm.CommandText = insertSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //添加返回参数 comm.Parameters.Add(SqlHelper.GetOutputParameter("@SalaryID", SqlDbType.Int)); //执行插入并返回插入结果 return comm; }