/// <summary> /// 保存计时工资项信息 /// </summary> /// <param name="lstEdit">计时工资项信息</param> /// <param name="companyCD">公司代码</param> /// <param name="modifyUserID">最后修改用户</param> /// <returns></returns> public static bool SaveTimeItemInfo(ArrayList lstEdit, string companyCD, string modifyUserID) { //定义返回变量 bool isSucc = true; //信息存在时,进行操作 if (lstEdit != null && lstEdit.Count > 0) { //保存库列表 ArrayList lstSave = new ArrayList(); //遍历所有计时工资项,进行增删改操作 for (int i = 0; i < lstEdit.Count; i++) { //获取值 TimeItemModel model = (TimeItemModel)lstEdit[i]; //设置公司代码 model.CompanyCD = companyCD; //最后修改人 model.ModifiedUserID = modifyUserID; //更新 if ("1".Equals(model.EditFlag)) { //执行更新操作 lstSave.Add(UpdateTimeItemInfo(model)); } //插入 else if ("0".Equals(model.EditFlag)) { //执行插入操作 lstSave.Add(InsertTimeItemInfo(model)); } //删除 else { //执行删除操作 lstSave.Add(DeleteTimeItemInfo(model.ID)); } } //执行保存操作 isSucc = SqlHelper.ExecuteTransWithArrayList(lstSave); //获取插入数据的ID for (int j = 0; j < lstEdit.Count; j++) { //获取值 TimeItemModel model = (TimeItemModel)lstEdit[j]; //插入时 if ("0".Equals(model.EditFlag)) { //获取插入的命令 SqlCommand comm = (SqlCommand)lstSave[j]; //设置计时工资项编号 model.ID = comm.Parameters["@SalaryID"].Value.ToString(); } } } return(isSucc); }
/// <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)); //最后修改人 }
protected override void OnRender(DrawingContext drawingContext) { base.OnRender(drawingContext); for (int i = 0; i < Items.Count; i++) { if (i + 1 == Items.Count) { TimeItemModel timeItemModel1 = Items[i] as TimeItemModel; GridCell gridCell = this.ItemContainerGenerator.ContainerFromIndex(i) as GridCell; if (gridCell == null) { continue; } if ((i + 1) % 3 == 0) { gridCell.IsDottedLine = false; } else { gridCell.IsDottedLine = true; } gridCell.StartTime = timeItemModel1.TimeName; gridCell.EndTime = timeItemModel1.TimeName.AddMinutes(5); gridCell.ProjectEndTime = GanttProjectRow.EndTime; gridCell.ProjectStartTime = GanttProjectRow.StartTime; gridCell.Content = null; } else { TimeItemModel timeItemModel1 = Items[i] as TimeItemModel; TimeItemModel timeItemModel2 = Items[i + 1] as TimeItemModel; GridCell gridCell = this.ItemContainerGenerator.ContainerFromIndex(i) as GridCell; if (gridCell == null) { continue; } if ((i + 1) % 3 == 0) { gridCell.IsDottedLine = false; } else { gridCell.IsDottedLine = true; } gridCell.StartTime = timeItemModel1.TimeName; gridCell.EndTime = timeItemModel2.TimeName; gridCell.ProjectEndTime = GanttProjectRow.EndTime; gridCell.ProjectStartTime = GanttProjectRow.StartTime; gridCell.Content = null; } } }
/// <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="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); }