/// <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));
}
