/// <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; }