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