/// <summary>
/// 获得数据List
/// </summary>
public RunRecordFileMainList GetDataList(RunRecordMainQueryCondition 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_Main where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from Tab_EndWork_RunRecrod_Main where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from Tab_EndWork_RunRecrod_Main 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];
RunRecordFileMainList list = new RunRecordFileMainList();
foreach (DataRow dr in dt.Rows)
{
RunRecordFileMain _EndWork_RunRecrod_Main = new RunRecordFileMain();
DataRowToModel(_EndWork_RunRecrod_Main, dr);
list.Add(_EndWork_RunRecrod_Main);
}
return(list);
}
/// <summary>
/// 获得一个实体对象
/// </summary>
public RunRecordFileMain GetModel(RunRecordMainQueryCondition 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_Main where 1=1 " + strSqlOption.ToString());
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
RunRecordFileMain _EndWork_RunRecrod_Main = null;
if (dt.Rows.Count > 0)
{
_EndWork_RunRecrod_Main = new RunRecordFileMain();
DataRowToModel(_EndWork_RunRecrod_Main, dt.Rows[0]);
}
return(_EndWork_RunRecrod_Main);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(RunRecordFileMain model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.dtUploadTime = ObjectConvertClass.static_ext_date(dr["dtUploadTime"]);
model.strPlanGUID = ObjectConvertClass.static_ext_string(dr["strPlanGUID"]);
model.dtPlanChuQinTime = ObjectConvertClass.static_ext_date(dr["dtPlanChuQinTime"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.strTrainNum = ObjectConvertClass.static_ext_string(dr["strTrainNum"]);
model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
model.strTrainmanNumber1 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber1"]);
model.strTrainmanName1 = ObjectConvertClass.static_ext_string(dr["strTrainmanName1"]);
model.strTrainmanNumber2 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber2"]);
model.strTrainmanName2 = ObjectConvertClass.static_ext_string(dr["strTrainmanName2"]);
model.strTrainmanNumber3 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber3"]);
model.strTrainmanName3 = ObjectConvertClass.static_ext_string(dr["strTrainmanName3"]);
model.strTrainmanNumber4 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber4"]);
model.strTrainmanName4 = ObjectConvertClass.static_ext_string(dr["strTrainmanName4"]);
model.strCardNumber = ObjectConvertClass.static_ext_string(dr["strCardNumber"]);
model.strSiteNumber = ObjectConvertClass.static_ext_string(dr["strSiteNumber"]);
model.strSiteName = ObjectConvertClass.static_ext_string(dr["strSiteName"]);
}
/// <summary>
/// 添加数据
/// </summary>
public string Add(SqlCommand command, RunRecordFileMain model, Boolean isExitPlan, int a)
{
string sqlConnString = ZhuanChuString;
string DetailTime = DateTime.Now.ToString();
int DetaieCount = a;
if (ZhuanChuIsEnable == "1")
{
try
{
if (!string.IsNullOrEmpty(model.strTrainmanNumber1) && model.dtPlanChuQinTime > DateTime.Now.AddDays(-1000))
{
DataTable dt = getMaxTimeAndCount(model.dtPlanChuQinTime.ToString(), model.strTrainmanNumber1);
if (ObjectConvertClass.static_ext_int(dt.Rows[0]["DetaieCount"]) != 0)
{
DetaieCount = ObjectConvertClass.static_ext_int(dt.Rows[0]["DetaieCount"]);
DetailTime = ObjectConvertClass.static_ext_string(dt.Rows[0]["DetailTime"]);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
StringBuilder strSql = new StringBuilder();
strSql.Append("DECLARE @ROWGUID_EndWork_RunRecrod_Main TABLE(ID uniqueidentifier) ");
strSql.Append("insert into Tab_EndWork_RunRecrod_Main ");
strSql.Append("(dtUploadTime,strPlanGUID,dtPlanChuQinTime,strTrainNo,strTrainNum,strTrainTypeName,strTrainmanNumber1,strTrainmanName1,strTrainmanNumber2,strTrainmanName2,strTrainmanNumber3,strTrainmanName3,strTrainmanNumber4,strTrainmanName4,strCardNumber,strSiteNumber,strSiteName,dtLastUpDateTime,nDetailCount)");
strSql.Append("OUTPUT INSERTED.STRGUID INTO @ROWGUID_EndWork_RunRecrod_Main ");
strSql.Append("values(@dtUploadTime,@strPlanGUID,@dtPlanChuQinTime,@strTrainNo,@strTrainNum,@strTrainTypeName,@strTrainmanNumber1,@strTrainmanName1,@strTrainmanNumber2,@strTrainmanName2,@strTrainmanNumber3,@strTrainmanName3,@strTrainmanNumber4,@strTrainmanName4,@strCardNumber,@strSiteNumber,@strSiteName,@dtLastUpDateTime,@nDetailCount)");
strSql.Append(";SELECT ID FROM @ROWGUID_EndWork_RunRecrod_Main");
SqlParameter[] parameters =
{
new SqlParameter("@dtUploadTime", model.dtUploadTime),
new SqlParameter("@strPlanGUID", model.strPlanGUID),
new SqlParameter("@dtPlanChuQinTime", model.dtPlanChuQinTime),
new SqlParameter("@strTrainNo", model.strTrainNo),
new SqlParameter("@strTrainNum", model.strTrainNum),
new SqlParameter("@strTrainTypeName", model.strTrainTypeName),
new SqlParameter("@strTrainmanNumber1", model.strTrainmanNumber1),
new SqlParameter("@strTrainmanName1", model.strTrainmanName1),
new SqlParameter("@strTrainmanNumber2", model.strTrainmanNumber2),
new SqlParameter("@strTrainmanName2", model.strTrainmanName2),
new SqlParameter("@strTrainmanNumber3", model.strTrainmanNumber3),
new SqlParameter("@strTrainmanName3", model.strTrainmanName3),
new SqlParameter("@strTrainmanNumber4", model.strTrainmanNumber4),
new SqlParameter("@strTrainmanName4", model.strTrainmanName4),
new SqlParameter("@strCardNumber", model.strCardNumber),
new SqlParameter("@strSiteNumber", model.strSiteNumber),
new SqlParameter("@strSiteName", model.strSiteName),
new SqlParameter("@nDetailCount", DetaieCount),
new SqlParameter("@dtLastUpDateTime", DetailTime)
};
command.CommandText = strSql.ToString();
command.Parameters.Clear();
command.Parameters.AddRange(parameters);
return(ObjectConvertClass.static_ext_string(command.ExecuteScalar()));
//return command.ExecuteNonQuery();
}
