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