/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.vw_EmployeeBase GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 e_ID,d_ID,d_MingCh,e_YongHM,e_MiM,e_MingC,e_GongH,e_XingB,e_ShengR,e_QQ,e_EMail,e_ShouJ,e_CreatedBy,e_CreatedOn,e_StateCode,e_DeleteStateCode,e_LeiB from vw_EmployeeBase ");
strSql.Append(" where ");
SqlParameter[] parameters = {
};
webs_YueyxShop.Model.vw_EmployeeBase model=new webs_YueyxShop.Model.vw_EmployeeBase();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.vw_EmployeeBase DataRowToModel(DataRow row)
{
webs_YueyxShop.Model.vw_EmployeeBase model=new webs_YueyxShop.Model.vw_EmployeeBase();
if (row != null)
{
if(row["e_ID"]!=null && row["e_ID"].ToString()!="")
{
model.e_ID= new Guid(row["e_ID"].ToString());
}
if(row["d_ID"]!=null && row["d_ID"].ToString()!="")
{
model.d_ID= new Guid(row["d_ID"].ToString());
}
if(row["d_MingCh"]!=null)
{
model.d_MingCh=row["d_MingCh"].ToString();
}
if(row["e_YongHM"]!=null)
{
model.e_YongHM=row["e_YongHM"].ToString();
}
if(row["e_MiM"]!=null)
{
model.e_MiM=row["e_MiM"].ToString();
}
if(row["e_MingC"]!=null)
{
model.e_MingC=row["e_MingC"].ToString();
}
if(row["e_GongH"]!=null)
{
model.e_GongH=row["e_GongH"].ToString();
}
if(row["e_XingB"]!=null && row["e_XingB"].ToString()!="")
{
model.e_XingB=int.Parse(row["e_XingB"].ToString());
}
if(row["e_ShengR"]!=null && row["e_ShengR"].ToString()!="")
{
model.e_ShengR=DateTime.Parse(row["e_ShengR"].ToString());
}
if(row["e_QQ"]!=null)
{
model.e_QQ=row["e_QQ"].ToString();
}
if(row["e_EMail"]!=null)
{
model.e_EMail=row["e_EMail"].ToString();
}
if(row["e_ShouJ"]!=null)
{
model.e_ShouJ=row["e_ShouJ"].ToString();
}
if(row["e_CreatedBy"]!=null && row["e_CreatedBy"].ToString()!="")
{
model.e_CreatedBy= new Guid(row["e_CreatedBy"].ToString());
}
if(row["e_CreatedOn"]!=null && row["e_CreatedOn"].ToString()!="")
{
model.e_CreatedOn=DateTime.Parse(row["e_CreatedOn"].ToString());
}
if(row["e_StateCode"]!=null && row["e_StateCode"].ToString()!="")
{
model.e_StateCode=int.Parse(row["e_StateCode"].ToString());
}
if(row["e_DeleteStateCode"]!=null && row["e_DeleteStateCode"].ToString()!="")
{
model.e_DeleteStateCode=int.Parse(row["e_DeleteStateCode"].ToString());
}
if(row["e_LeiB"]!=null && row["e_LeiB"].ToString()!="")
{
model.e_LeiB=int.Parse(row["e_LeiB"].ToString());
}
}
return model;
}
