/// <summary> /// 获得数据List /// </summary> public Plan_Beginwork_StepDefList GetDataList(Plan_Beginwork_StepDefQueryCondition 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_Plan_Beginwork_StepDef where 1=1 " + strSqlOption.ToString()); } else { strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_Plan_Beginwork_StepDef where 1 = 1 " + strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows + " nID from TAB_Plan_Beginwork_StepDef where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc"); } DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; Plan_Beginwork_StepDefList list = new Plan_Beginwork_StepDefList(); foreach (DataRow dr in dt.Rows) { Plan_Beginwork_StepDef _Plan_Beginwork_StepDef = new Plan_Beginwork_StepDef(); DataRowToModel(_Plan_Beginwork_StepDef, dr); list.Add(_Plan_Beginwork_StepDef); } return(list); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToModel(Plan_Beginwork_StepDef model, DataRow dr) { model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]); model.strStepName = ObjectConvertClass.static_ext_string(dr["strStepName"]); model.strStepBrief = ObjectConvertClass.static_ext_string(dr["strStepBrief"]); model.nStepIndex = ObjectConvertClass.static_ext_int(dr["nStepIndex"]); model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); }
/// <summary> /// 检查数据是否存在 /// </summary> public bool Exists(Plan_Beginwork_StepDef _Plan_Beginwork_StepDef) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(*) from TAB_Plan_Beginwork_StepDef where nID=@nID"); SqlParameter[] parameters = { new SqlParameter("nID", _Plan_Beginwork_StepDef.nID) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)) > 0); }
public List <Plan_Beginwork_StepDef> getStep(string strWorkShopGUID, int nWorkTypeID) { string sql = "select * from TAB_Plan_Beginwork_StepDef where strWorkShopGUID='" + strWorkShopGUID + "' and nWorkTypeID='" + nWorkTypeID + "' order by nStepIndex"; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql).Tables[0]; List <Plan_Beginwork_StepDef> list = new List <Plan_Beginwork_StepDef>(); foreach (DataRow dr in dt.Rows) { Plan_Beginwork_StepDef Plan_Beginwork_StepDefM = new Plan_Beginwork_StepDef(); DataRowToStepModel(Plan_Beginwork_StepDefM, dr); list.Add(Plan_Beginwork_StepDefM); } return(list); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void DataRowToStepModel(Plan_Beginwork_StepDef model, DataRow dr) { model.nID = ObjectConvertClass.static_ext_int(dr["nID"]); model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]); model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]); model.strStepName = ObjectConvertClass.static_ext_string(dr["strStepName"]); model.strStepBrief = ObjectConvertClass.static_ext_string(dr["strStepBrief"]); model.nStepIndex = ObjectConvertClass.static_ext_int(dr["nStepIndex"]); model.strStepID = ObjectConvertClass.static_ext_string(dr["strStepID"]); model.nIsNecessary = ObjectConvertClass.static_ext_int(dr["nIsNecessary"]); //model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]); //model.nStepIndex = ObjectConvertClass.static_ext_int(dr["nStepIndex"]); //model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]); //model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]); }
/// <summary> /// 添加数据 /// </summary> public int Add(Plan_Beginwork_StepDef model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_Plan_Beginwork_StepDef"); strSql.Append("(strWorkShopGUID,strWorkShopName,strStepName,strStepBrief,nStepIndex)"); strSql.Append("values(@strWorkShopGUID,@strWorkShopName,@strStepName,@strStepBrief,@nStepIndex)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID), new SqlParameter("@strWorkShopName", model.strWorkShopName), new SqlParameter("@strStepName", model.strStepName), new SqlParameter("@strStepBrief", model.strStepBrief), new SqlParameter("@nStepIndex", model.nStepIndex), }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters))); }
/// <summary> /// 获得一个实体对象 /// </summary> public Plan_Beginwork_StepDef GetModel(Plan_Beginwork_StepDefQueryCondition 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_StepDef where 1=1 " + strSqlOption.ToString()); DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; Plan_Beginwork_StepDef _Plan_Beginwork_StepDef = null; if (dt.Rows.Count > 0) { _Plan_Beginwork_StepDef = new Plan_Beginwork_StepDef(); DataRowToModel(_Plan_Beginwork_StepDef, dt.Rows[0]); } return(_Plan_Beginwork_StepDef); }
/// <summary> /// 更新数据 /// </summary> public bool Update(Plan_Beginwork_StepDef model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update TAB_Plan_Beginwork_StepDef set "); strSql.Append(" strWorkShopGUID = @strWorkShopGUID, "); strSql.Append(" strWorkShopName = @strWorkShopName, "); strSql.Append(" strStepName = @strStepName, "); strSql.Append(" strStepBrief = @strStepBrief, "); strSql.Append(" nStepIndex = @nStepIndex, "); strSql.Append(" where nID = @nID "); SqlParameter[] parameters = { new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID), new SqlParameter("@strWorkShopName", model.strWorkShopName), new SqlParameter("@strStepName", model.strStepName), new SqlParameter("@strStepBrief", model.strStepBrief), new SqlParameter("@nStepIndex", model.nStepIndex), }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters) > 0); }