/// <summary> /// 取得PTJob数据,可以是很多 /// </summary> /// <param name="paras"></param> /// <returns>兼职表的集合</returns> public static List <PTJob> QueryListCondiction(SqlParameter[] paras) { PTJob model = null; StringBuilder sbSql = new StringBuilder("select * from PTJobTable p,EmployeeTable e where p.pt_eId = e.e_Id and p.pt_StuId is null"); if (paras != null) { for (int i = 0; i < paras.Length; i++) { SqlParameter p = paras[i]; sbSql.Append(" and "); sbSql.Append(p.ParameterName.Substring(1)); sbSql.Append(" =" + p.ParameterName); } } DataTable dt = (paras == null) ? SqlHelper.ExecuteDataTable(sbSql.ToString()) : SqlHelper.ExecuteDataTable(sbSql.ToString(), paras); List <PTJob> list = null; if (dt.Rows.Count > 0) { list = new List <PTJob>(); foreach (DataRow dr in dt.Rows) { model = new PTJob(); SetDr2Model(dr, model); list.Add(model); } } return(list); }
public List <ProductionClassModel> GetAllType() { DataTable data = SqlHelper.ExecuteDataTable("SELECT * FROM SJProductionType ", null); return(SqlHelper.DataTableToModelList <ProductionClassModel>(data)); }
public static int GetOKPTJobNum(int e_id) { DataTable dt = SqlHelper.ExecuteDataTable("select * from PTJobTable where pt_eId =@e_id and pt_StuId is not null", new SqlParameter("e_id", e_id)); return(dt.Rows.Count); }
public List <BucketModel> GetAllBucket() { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJPackageBucketInfo ORDER BY FBucketID DESC ", null); return(SqlHelper.DataTableToModelList <BucketModel>(data)); }