/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(Plan_Beginwork_StepData model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.strFieldName = ObjectConvertClass.static_ext_string(dr["strFieldName"]);
model.nStepData = ObjectConvertClass.static_ext_int(dr["nStepData"]);
model.dtStepData = ObjectConvertClass.static_ext_date(dr["dtStepData"]);
model.strStepData = ObjectConvertClass.static_ext_string(dr["strStepData"]);
}
/// <summary>
/// 检查数据是否存在
/// </summary>
public bool Exists(Plan_Beginwork_StepData _Plan_Beginwork_StepData)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from TAB_Plan_Beginwork_StepData where nID=@nID");
SqlParameter[] parameters =
{
new SqlParameter("nID", _Plan_Beginwork_StepData.nID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)) > 0);
}
/// <summary>
/// 获得数据List
/// </summary>
public List <Plan_Beginwork_StepData> GetDataList(string strTrainmanNumber, string dtBeginStartTime, string dtEndStartTime)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 strTrainPlanGUID ");
strSql.Append(" FROM TAB_Plan_Beginwork_StepIndex where 1=1 ");
if (!string.IsNullOrEmpty(strTrainmanNumber))
{
strSql.Append(" and strTrainmanNumber='" + strTrainmanNumber + "'");
}
if (!string.IsNullOrEmpty(dtBeginStartTime))
{
strSql.Append(" and dtStartTime>='" + dtBeginStartTime + "'");
}
if (!string.IsNullOrEmpty(dtEndStartTime))
{
strSql.Append(" and dtStartTime<'" + dtEndStartTime + "'");
}
object TrainPlanGUID = SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString());
string strTrainPlanGUID = "";
if (TrainPlanGUID != null)
{
strTrainPlanGUID = TrainPlanGUID.ToString();
}
else
{
return(null);
}
string strSqlData = "select * from TAB_Plan_Beginwork_StepData where strTrainPlanGUID='" + strTrainPlanGUID + "' ";
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSqlData.ToString()).Tables[0];
List <Plan_Beginwork_StepData> list = new List <Plan_Beginwork_StepData>();
foreach (DataRow dr in dt.Rows)
{
Plan_Beginwork_StepData _Plan_Beginwork_StepData = new Plan_Beginwork_StepData();
DataRowToModel(_Plan_Beginwork_StepData, dr);
list.Add(_Plan_Beginwork_StepData);
}
return(list);
}
/// <summary>
/// 添加数据
/// </summary>
public int Add(Plan_Beginwork_StepData model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Plan_Beginwork_StepData");
strSql.Append("(strTrainPlanGUID,strFieldName,nStepData,dtStepData,strStepData)");
strSql.Append("values(@strTrainPlanGUID,@strFieldName,@nStepData,@dtStepData,@strStepData)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@strTrainPlanGUID", model.strTrainPlanGUID),
new SqlParameter("@strFieldName", model.strFieldName),
new SqlParameter("@nStepData", model.nStepData),
new SqlParameter("@dtStepData", model.dtStepData),
new SqlParameter("@strStepData", model.strStepData)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)));
}
/// <summary>
/// 获得一个实体对象
/// </summary>
public Plan_Beginwork_StepData GetModel(Plan_Beginwork_StepDataQueryCondition 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_Plan_Beginwork_StepData where 1=1 " + strSqlOption.ToString());
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
Plan_Beginwork_StepData _Plan_Beginwork_StepData = null;
if (dt.Rows.Count > 0)
{
_Plan_Beginwork_StepData = new Plan_Beginwork_StepData();
DataRowToModel(_Plan_Beginwork_StepData, dt.Rows[0]);
}
return(_Plan_Beginwork_StepData);
}
/// <summary>
/// 更新数据
/// </summary>
public bool Update(Plan_Beginwork_StepData model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update TAB_Plan_Beginwork_StepData set ");
strSql.Append(" strTrainPlanGUID = @strTrainPlanGUID, ");
strSql.Append(" strFieldName = @strFieldName, ");
strSql.Append(" nStepData = @nStepData, ");
strSql.Append(" dtStepData = @dtStepData, ");
strSql.Append(" strStepData = @strStepData ");
strSql.Append(" where nID = @nID ");
SqlParameter[] parameters =
{
new SqlParameter("@strTrainPlanGUID", model.strTrainPlanGUID),
new SqlParameter("@strFieldName", model.strFieldName),
new SqlParameter("@nStepData", model.nStepData),
new SqlParameter("@dtStepData", model.dtStepData),
new SqlParameter("@strStepData", model.strStepData)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
