/// <summary> /// 得到一个对象实体 /// </summary> public zlzw.Model.GeneralBasicSettingModel DataRowToModel(DataRow row) { zlzw.Model.GeneralBasicSettingModel model = new zlzw.Model.GeneralBasicSettingModel(); if (row != null) { if (row["SettingID"] != null && row["SettingID"].ToString() != "") { model.SettingID = int.Parse(row["SettingID"].ToString()); } if (row["SettingKey"] != null) { model.SettingKey = row["SettingKey"].ToString(); } if (row["SettingValue"] != null) { model.SettingValue = row["SettingValue"].ToString(); } if (row["SettingDesc"] != null) { model.SettingDesc = row["SettingDesc"].ToString(); } if (row["SettingCategory"] != null) { model.SettingCategory = row["SettingCategory"].ToString(); } if (row["DisplayName"] != null) { model.DisplayName = row["DisplayName"].ToString(); } if (row["OrderNumber"] != null && row["OrderNumber"].ToString() != "") { model.OrderNumber = int.Parse(row["OrderNumber"].ToString()); } if (row["CanUsable"] != null && row["CanUsable"].ToString() != "") { model.CanUsable = int.Parse(row["CanUsable"].ToString()); } if (row["IsInnerSetting"] != null && row["IsInnerSetting"].ToString() != "") { model.IsInnerSetting = int.Parse(row["IsInnerSetting"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public zlzw.Model.GeneralBasicSettingModel GetModel(int SettingID) { SqlParameter[] parameters = { new SqlParameter("@SettingID", SqlDbType.Int,4) }; parameters[0].Value = SettingID; zlzw.Model.GeneralBasicSettingModel model = new zlzw.Model.GeneralBasicSettingModel(); DataSet ds = DbHelperSQL.RunProcedure("GeneralBasicSetting_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }