/// <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; }