/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.EmployeeBase GetModel(Guid e_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(
"select top 1 e_ID,d_ID,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 EmployeeBase ");
strSql.Append(" where e_ID=@e_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@e_ID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = e_ID;
webs_YueyxShop.Model.EmployeeBase model = new webs_YueyxShop.Model.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.EmployeeBase DataRowToModel(DataRow row)
{
webs_YueyxShop.Model.EmployeeBase model = new webs_YueyxShop.Model.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["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;
}
