/// <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);
}
/// <summary>
/// 将兼职表的数据行转换成model
/// </summary>
/// <param name="dr"></param>
/// <param name="model">空</param>
public static void SetDr2Model(DataRow dr, PTJob model)
{
if (dr["pt_Id"].ToString() != "")
{
model.pt_Id = int.Parse(dr["pt_Id"].ToString());
}
model.pt_Kind = dr["pt_Kind"].ToString();
model.pt_Time = dr["pt_Time"].ToString();
model.pt_ReleaseTime = dr["pt_ReleaseTime"].ToString();
if (dr["pt_eId"].ToString() != "")
{
model.pt_eId = int.Parse(dr["pt_eId"].ToString());
model.Pt_employee = new Employee();
EmployeeTable.SetDr2Model(dr, model.Pt_employee);
}
if (dr["pt_Money"].ToString() != "")
{
model.pt_Money = int.Parse(dr["pt_Money"].ToString());
}
model.pt_Address = dr["pt_Address"].ToString();
model.pt_Tel = dr["pt_Tel"].ToString();
model.pt_State = dr["pt_State"].ToString();
model.pt_Name = dr["pt_Name"].ToString();
model.pt_Kind = dr["pt_Kind"].ToString();
if (dr["pt_StuId"].ToString() != "")
{
model.pt_StuId = int.Parse(dr["pt_StuId"].ToString());
model.Pt_student = new Student();
StudentTable.SetDr2Model(dr, model.Pt_student);
}
if (dr["pt_Need"].ToString() != "")
{
model.pt_Need = int.Parse(dr["pt_Need"].ToString());
}
}
/// <summary>
/// 取得兼职表的一条记录
/// </summary>
/// <param name="paras"></param>
/// <returns></returns>
public static PTJob QuerySingleByCondiction(SqlParameter[] paras)
{
PTJob model = null;
StringBuilder sbSql = new StringBuilder("select * from PTJobTable p,EmployeeTable e,StudentTable s where p.pt_eId = e.e_Id");
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 = SqlHelper.ExecuteDataTable(sbSql.ToString(), paras);
if (dt.Rows.Count > 0)
{
model = new PTJob();
foreach (DataRow dr in dt.Rows)
{
model = new PTJob();
SetDr2Model(dr, model);
}
}
return(model);
}
public List <PTJob> PTchange(string ptid)
{
int id = Int32.Parse(ptid);
ptjobmodel = PTJobBLL.GetPTJobById(id);
List <PTJob> a1 = new List <PTJob>();
a1.Add(ptjobmodel);
return(a1);
}
