/// <summary>
/// 获得数据List
/// </summary>
public RunRecordFileDetailList GetDataList(RunRecrodDetailQueryCondition 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_EndWork_RunRecrod_Detail where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from Tab_EndWork_RunRecrod_Detail where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from Tab_EndWork_RunRecrod_Detail where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
}
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
RunRecordFileDetailList list = new RunRecordFileDetailList();
foreach (DataRow dr in dt.Rows)
{
RunRecordFileDetail _EndWork_RunRecrod_Detail = new RunRecordFileDetail();
DataRowToModel(_EndWork_RunRecrod_Detail, dr);
list.Add(_EndWork_RunRecrod_Detail);
}
return(list);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(RunRecordFileDetail model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strPlanGUID = ObjectConvertClass.static_ext_string(dr["strPlanGUID"]);
model.strFileName = ObjectConvertClass.static_ext_string(dr["strFileName"]);
model.strTrainNum = ObjectConvertClass.static_ext_string(dr["strTrainNum"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.nFileSize = ObjectConvertClass.static_ext_int(dr["nFileSize"]);
model.dtFileTime = ObjectConvertClass.static_ext_date(dr["dtFileTime"]);
}
/// <summary>
/// 检查数据是否存在
/// </summary>
public bool Exists(RunRecordFileDetail _EndWork_RunRecrod_Detail)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from Tab_EndWork_RunRecrod_Detail where strID=@strID");
SqlParameter[] parameters =
{
new SqlParameter("strID", _EndWork_RunRecrod_Detail.nID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters)) > 0);
}
/// <summary>
/// 获得一个实体对象
/// </summary>
public RunRecordFileDetail GetModel(RunRecrodDetailQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * ");
strSql.Append(" FROM Tab_EndWork_RunRecrod_Detail where 1=1 " + strSqlOption.ToString());
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
RunRecordFileDetail _EndWork_RunRecrod_Detail = null;
if (dt.Rows.Count > 0)
{
_EndWork_RunRecrod_Detail = new RunRecordFileDetail();
DataRowToModel(_EndWork_RunRecrod_Detail, dt.Rows[0]);
}
return(_EndWork_RunRecrod_Detail);
}
/// <summary>
/// 添加数据
/// </summary>
public int Add(SqlCommand command, RunRecordFileDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Tab_EndWork_RunRecrod_Detail");
strSql.Append("(strPlanGUID,strFileName,strTrainNum,strTrainmanNumber,strTrainNo,nFileSize,dtFileTime,strRecordGUID)");
strSql.Append("values(@strPlanGUID,@strFileName,@strTrainNum,@strTrainmanNumber,@strTrainNo,@nFileSize,@dtFileTime,@strRecordGUID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@strPlanGUID", model.strPlanGUID),
new SqlParameter("@strFileName", model.strFileName),
new SqlParameter("@strTrainNum", model.strTrainNum),
new SqlParameter("@strTrainmanNumber", model.strTrainmanNumber),
new SqlParameter("@strTrainNo", model.strTrainNo),
new SqlParameter("@nFileSize", model.nFileSize),
new SqlParameter("@dtFileTime", model.dtFileTime),
new SqlParameter("@strRecordGUID", model.strRecordGUID)
};
command.CommandText = strSql.ToString();
command.Parameters.Clear();
command.Parameters.AddRange(parameters);
return(command.ExecuteNonQuery());
}
