/// <summary> /// 计划信息更新保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gvBand_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Value != null) { Models.ys_WorkPlan md = new Models.ys_WorkPlan(); md.StaffId = clsPublic.GetObjGUID(gvData.GetFocusedRowCellValue("StaffId")); md.StaffName = clsPublic.GetObjectString(gvData.GetFocusedRowCellValue("StaffName")); md.WorkDay = clsPublic.ToDateTime(((BandedGridColumn)e.Column).OwnerBand.Caption); md.OperatorId = Models.SqlHelper.Session._UserId; md.OperatorName = Models.SqlHelper.Session._FullName; var FileValue = e.Value.ToString(); string FileName = e.Column.FieldName; switch (FileName.Substring(0, 1)) { case "F": FileName = "FocusWork"; md.FocusWork = FileValue; break; case "C": FileName = "CheckPlan"; md.CheckPlan = FileValue; break; case "P": FileName = "WorkPlan"; md.WorkPlan = FileValue; break; } if (!manager.Save(md, FileName)) { clsPublic.ShowMessage(MessageBoxIcon.Error, "保存出错", Text); } } }
/// <summary> /// 修改 /// </summary> /// <param name="model">实体</param> /// <param name="FiledName">字段</param> /// <returns></returns> public bool Modify(Models.ys_WorkPlan model, string FiledName) { string FiledValue = ""; if (FiledName == "CheckPlan") { FiledValue = model.CheckPlan; } else if (FiledName == "WorkPlan") { FiledValue = model.WorkPlan; } else if (FiledName == "FocusWork") { FiledValue = model.FocusWork; } else { return(false); } string sqlText = string.Format(@"UPDATE [RightingSys].[dbo].[ys_WorkPlan] SET [{0}] = '{1}' ,[OperatorId] = '{2}' ,[OperatorName] = '{3}' ,[CreateTime] = getdate() WHERE [WorkDay] = '{4}' and [StaffId] = '{5}'", FiledName, FiledValue, model.OperatorId, model.OperatorName, model.WorkDay, model.StaffId); return(Models.SqlHelper.ExecuteNoQuery(sqlText) > 0); }
/// <summary> /// 保存信息 /// </summary> /// <param name="md">实体</param> /// <param name="FiledName">字段</param> /// <returns></returns> public bool Save(Models.ys_WorkPlan md, string FiledName) { if (ExistsByStaffAndDay(md.StaffId, md.WorkDay)) { return(this.Modify(md, FiledName)); } else { return(this.AddNew(md, FiledName)); } }
/// <summary> /// 新增 /// </summary> /// <param name="model">实体</param> /// <param name="FiledName">字段</param> /// <returns></returns> private bool AddNew(Models.ys_WorkPlan model, string FiledName) { string FiledValue = ""; if (FiledName == "CheckPlan") { FiledValue = model.CheckPlan; } else if (FiledName == "WorkPlan") { FiledValue = model.WorkPlan; } else if (FiledName == "FocusWork") { FiledValue = model.FocusWork; } else { return(false); } string sqlText = string.Format(@"INSERT INTO [RightingSys].[dbo].[ys_WorkPlan] ([{0}] ,[WorkDay] ,[StaffId] ,[StaffName] ,[OperatorId] ,[OperatorName]) VALUES ('{1}' ,'{2}' ,'{3}' ,'{4}' ,'{5}' ,'{6}')", FiledName, FiledValue, model.WorkDay, model.StaffId, model.StaffName, model.OperatorId, model.OperatorName); return(Models.SqlHelper.ExecuteNoQuery(sqlText) > 0); }
/// <summary> /// 保存信息 /// </summary> /// <param name="md">实体</param> /// <param name="FiledName">字段</param> /// <returns></returns> public bool Save(Models.ys_WorkPlan md, string FiledName) { return(sev.Save(md, FiledName)); }