/// <summary>
/// 列表界面查询方法
/// </summary>
/// <param name="pageIndex">当前页</param>
/// <param name="pageCount">每页记录数</param>
/// <param name="orderBy">排序方法</param>
/// <param name="TotalCount">总记录数</param>
/// <param name="model">实体类</param>
/// <returns></returns>
public static DataTable SelectListData(int pageIndex, int pageCount, string orderBy, ref int TotalCount
, ProjectConstructionModel model)
{
SqlCommand comm = new SqlCommand();
StringBuilder sql = new StringBuilder(C_SELECT_ALL);
sql.Append(" WHERE 1=1 ");
comm.CommandText = sql.ToString();
return(SqlHelper.PagerWithCommand(comm, pageIndex, pageCount, orderBy, ref TotalCount));
}
/// <summary>
/// 修改数据记录
/// </summary>
/// <param name="model">实体类</param>
/// <returns>修改操作的执行命令</returns>
public static SqlCommand UpdateCommand(ProjectConstructionModel model)
{
// SQL语句
SqlCommand comm = new SqlCommand();
comm.CommandText = C_UPDATE;
// 参数设置
SqlParameter[] parameters = SetInsertAndUpdateParameters();
parameters = SetInsertAndUpdateParametersValue(parameters, model);
comm.Parameters.AddRange(parameters);
return(comm);
}
/// <summary>
/// 修改数据记录
/// </summary>
/// <param name="model">实体类</param>
/// <returns>修改数据是否成功:true成功,false不成功</returns>
public static bool Update(ProjectConstructionModel model)
{
bool returnValue = false; // 返回值
// SQL语句
StringBuilder sqlSentence = new StringBuilder(C_UPDATE);
// 参数设置
SqlParameter[] parameters = SetInsertAndUpdateParameters();
parameters = SetInsertAndUpdateParametersValue(parameters, model);
//执行SQL
returnValue = SqlHelper.ExecuteTransSql(sqlSentence.ToString(), parameters) > 0;
return(returnValue);
}
/// <summary>
/// 插入操作的执行命令
/// </summary>
/// <param name="model">实体类</param>
/// <returns>插入操作的执行命令</returns>
public static SqlCommand InsertCommand(ProjectConstructionModel model)
{
// SQL语句
SqlCommand comm = new SqlCommand();
comm.CommandText = C_INSERT + " SET @IndexID = @@IDENTITY ";
// 参数设置
SqlParameter[] parameters = SetInsertAndUpdateParameters();
parameters = SetInsertAndUpdateParametersValue(parameters, model);
comm.Parameters.AddRange(parameters);
SqlParameter IndexID = new SqlParameter("@IndexID", SqlDbType.Int);
IndexID.Direction = ParameterDirection.Output;
comm.Parameters.Add(IndexID);
return(comm);
}
/// <summary>
/// 设置新增和修改的参数数组的值
/// </summary>
/// <param name="parameters">参数数组</param>
/// <param name="model">实体类</param>
/// <returns>返回参数数组</returns>
private static SqlParameter[] SetInsertAndUpdateParametersValue(SqlParameter[] parameters, ProjectConstructionModel model)
{
if (!model.SummaryID.HasValue)
{
parameters[m_summaryIDCol].Value = System.DBNull.Value;
}
else
{
parameters[m_summaryIDCol].Value = model.SummaryID; // 概要编号
}
parameters[m_companyCDCol].Value = model.CompanyCD; // 企业编码
parameters[m_summaryNameCol].Value = model.SummaryName; // 概要名称
if (!model.StructID.HasValue)
{
parameters[m_structIDCol].Value = System.DBNull.Value;
}
else
{
parameters[m_structIDCol].Value = model.StructID; // 所属工程概要编号
}
if (!model.ProcessScale.HasValue)
{
parameters[m_processScaleCol].Value = System.DBNull.Value;
}
else
{
parameters[m_processScaleCol].Value = model.ProcessScale; // 工艺定额
}
if (!model.KeyPress.HasValue)
{
parameters[m_keyPressCol].Value = System.DBNull.Value;
}
else
{
parameters[m_keyPressCol].Value = model.KeyPress; // 是否为受约进度(0:不是，1是)
}
parameters[m_proessIDCol].Value = model.ProessID; // 受约进度编号(多编号用”,”隔开)
if (!model.BeginDate.HasValue)
{
parameters[m_beginDateCol].Value = System.DBNull.Value;
}
else
{
parameters[m_beginDateCol].Value = model.BeginDate; // 开始时间
}
if (!model.EndDate.HasValue)
{
parameters[m_endDateCol].Value = System.DBNull.Value;
}
else
{
parameters[m_endDateCol].Value = model.EndDate; // 结束时间
}
if (!model.StartFlag.HasValue)
{
parameters[m_startFlagCol].Value = System.DBNull.Value;
}
else
{
parameters[m_startFlagCol].Value = model.StartFlag; // 是否执行(0:不执行，1执行)
}
if (!model.GmanagerID.HasValue)
{
parameters[m_gmanagerIDCol].Value = System.DBNull.Value;
}
else
{
parameters[m_gmanagerIDCol].Value = model.GmanagerID; // 工程负责人
}
parameters[m_projectMemoCol].Value = model.ProjectMemo; // 工程备注
return(parameters);
}
