/// <summary>
/// 获得数据List
/// </summary>
public Plan_Beginwork_StepList GetDataList(Plan_Beginwork_StepQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
if (QueryCondition.page == 0)
{
strSql.Append("select * ");
strSql.Append(" FROM TAB_Plan_Beginwork_Step where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_Plan_Beginwork_Step where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from TAB_Plan_Beginwork_Step where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
}
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
Plan_Beginwork_StepList list = null;
if (dt.Rows.Count > 0)
{
list = new Plan_Beginwork_StepList();
foreach (DataRow dr in dt.Rows)
{
Plan_Beginwork_Step _Plan_Beginwork_Step = new Plan_Beginwork_Step();
DataRowToModel(_Plan_Beginwork_Step, dr);
list.Add(_Plan_Beginwork_Step);
}
}
return(list);
}
/// <summary>
/// 获得记录总数
/// </summary>
public int GetDataCount(Plan_Beginwork_StepQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) ");
strSql.Append(" FROM TAB_Plan_Beginwork_Step where 1=1" + strSqlOption.ToString());
return(ObjectConvertClass.static_ext_int(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams)));
}
/// <summary>
/// 添加数据
/// </summary>
public bool AddList(List <Plan_Beginwork_Step> modelList)
{
bool result = true;
SqlConnection connection = new SqlConnection();
SqlTransaction transaction = null;
SqlCommand command = new SqlCommand();
command.Connection = connection;
connection.ConnectionString = SqlHelper.ConnString;
connection.Open();
transaction = connection.BeginTransaction();
command.Transaction = transaction;
Plan_Beginwork_StepQueryCondition QueryCondition = new Plan_Beginwork_StepQueryCondition();
try
{
foreach (Plan_Beginwork_Step model in modelList)
{
QueryCondition.strTrainPlanGUID = model.strTrainPlanGUID;
QueryCondition.strTrainmanGUID = model.strTrainmanGUID;
QueryCondition.nStepID = model.nStepID;
Plan_Beginwork_Step tempModel = GetModel(model.strTrainPlanGUID, model.strTrainmanGUID, model.nStepID, command);
if (tempModel == null)
{
Add(model, command);
}
else
{
model.nID = tempModel.nID;
Update(model, command);
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
finally
{
if (connection.State != ConnectionState.Closed)
{
connection.Close();
}
command.Dispose();
connection.Dispose();
}
return(result);
}
/// <summary>
/// 获得数据DataTable
/// </summary>
public DataTable GetDataTable(Plan_Beginwork_StepQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
if (QueryCondition.page == 0)
{
strSql.Append("select * ");
strSql.Append(" FROM TAB_Plan_Beginwork_Step where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_Plan_Beginwork_Step where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from TAB_Plan_Beginwork_Step where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
}
return(SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]);
}