/// <summary>
/// 获得数据List
/// </summary>
public Plan_Beginwork_StepResultList GetDataList(string strTrainPlanGUID, int nWorkTypeID, string strWorkShopGUID)
{
StringBuilder strSql = new StringBuilder();
//strSql.Append("select * ");
//strSql.Append(" FROM TAB_Plan_Beginwork_StepResult where 1=1 ");
strSql.Append(" select a.strStepName,b.* from TAB_Plan_Beginwork_StepDef a left join TAB_Plan_Beginwork_StepResult b ");
strSql.Append(" on b.strStepName=a.strStepID and b.strTrainPlanGUID='" + strTrainPlanGUID + "' and b.nWorkTypeID=" + nWorkTypeID + " ");
strSql.Append(" where a.strWorkShopGUID='" + strWorkShopGUID + "' and a.nWorkTypeID=" + nWorkTypeID + "");
//if (!string.IsNullOrEmpty(strTrainPlanGUID))
// strSql.Append(" and strTrainPlanGUID='" + strTrainPlanGUID + "' ");
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0];
Plan_Beginwork_StepResultList list = new Plan_Beginwork_StepResultList();
foreach (DataRow dr in dt.Rows)
{
Plan_Beginwork_StepResult _Plan_Beginwork_StepResult = new Plan_Beginwork_StepResult();
DataRowToModel(_Plan_Beginwork_StepResult, dr);
list.Add(_Plan_Beginwork_StepResult);
}
return(list);
}
public List <Plan_Beginwork_StepResult> getStepResult(string strTrainPlanGUID, int nWorkTypeID)
{
string sql = "select * from TAB_Plan_Beginwork_StepResult where strTrainPlanGUID='" + strTrainPlanGUID + "' and nWorkTypeID='" + nWorkTypeID + "'";
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql).Tables[0];
Plan_Beginwork_StepResultList list = new Plan_Beginwork_StepResultList();
foreach (DataRow dr in dt.Rows)
{
Plan_Beginwork_StepResult _Plan_Beginwork_StepResult = new Plan_Beginwork_StepResult();
DataRowToModel(_Plan_Beginwork_StepResult, dr);
list.Add(_Plan_Beginwork_StepResult);
}
return(list);
// return dt;
}
