/// <summary> /// 根据Id获取实体对象 /// </summary> /// <param name="baseInfoId">主键Id</param> /// <returns>获取到的实体对象</returns> public WebApi_BaseInfo GetWebApi_BaseInfoById(int baseInfoId) { string[] parameters = new[] { "BaseInfoId" }; object[] parameterValues = new object[] { baseInfoId }; DataSet ds = _slaveDB.SpExecuteDataSet("spGetWebApiById", parameters, parameterValues); WebApi_BaseInfo model = new WebApi_BaseInfo(); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { LoadWebApi_BaseInfoEntity(dr, model); } return(model); } return(null); } return(null); }
/// <summary> /// 新增WebApi_BaseInfo信息 /// </summary> /// <param name="data">实体对象</param> /// <returns>新增成功返回新增Api主键Id,新增失败返回0</returns> public int AddWebApi(WebApi_BaseInfo data) { int id = 0; if (data == null) { return(id); } string[] parameters = new[] { "Name", "Url", "Description", "OpenTime", "IsAuthorize", "HttpType", "CreateTime", "IsDelete", "UpdateTime", "RequestHeader", "RequestBody", "ReturnResult", "GroupId" }; Object[] parameterValues = new object[] { data.Name, data.Url, data.Description, data.OpenTime, data.IsAuthorize, data.HttpType, data.CreateTime, data.IsDelete, data.UpdateTime, data.RequestHeader, data.RequestBody, data.ReturnResult, data.GroupId }; DataTable dt = _masterDB.SpExecuteTable("spAddWebApiBaseInfo", parameters, parameterValues); if (dt != null && dt.Rows.Count > 0) { id = Convert.ToInt32(dt.Rows[0]["ApiId"]); } return(id); }
/// <summary> /// 将DataTable中的数据装载到List列表 /// </summary> /// <param name="dt">DataTable</param> /// <returns>返回列表对象</returns> private static List <WebApi_BaseInfo> LoadTableToList(DataTable dt) { if (dt.Rows.Count > 0) { List <WebApi_BaseInfo> list = new List <WebApi_BaseInfo>(); //循环遍历数据表中的每一行 foreach (DataRow dr in dt.Rows) { WebApi_BaseInfo model = new WebApi_BaseInfo(); LoadWebApi_BaseInfoEntity(dr, model); list.Add(model); } return(list); } return(null); }
/// <summary> /// 更新WebApi_BaseInfo信息 /// </summary> /// <param name="data">实体对象</param> /// <returns>更新成功返回true,更新失败返回false</returns> public bool UpdateWebApi(WebApi_BaseInfo data) { if (data == null) { return(false); } string[] parameters = new[] { "BaseInfoId", "Name", "Url", "Description", "OpenTime", "IsAuthorize", "HttpType", "IsDelete", "UpdateTime", "RequestHeader", "RequestBody", "ReturnResult", "GroupId" }; Object[] parameterValues = new object[] { data.BaseInfoId, data.Name, data.Url, data.Description, data.OpenTime, data.IsAuthorize, data.HttpType, data.IsDelete, data.UpdateTime, data.RequestHeader, data.RequestBody, data.ReturnResult, data.GroupId }; if (_masterDB.SpExecuteNonQuery("spUpdateWebApiBaseInfo", parameters, parameterValues) > 0) { return(true); } return(false); }
/// <summary> /// 将DataRow数据装载到实体对象 /// </summary> /// <param name="dr">DataRow对象</param> /// <param name="data">实体对象</param> private static void LoadWebApi_BaseInfoEntity(DataRow dr, WebApi_BaseInfo data) { if (dr.Table.Columns.Contains("BaseInfoId")) { if (!string.IsNullOrEmpty(dr["BaseInfoId"].ToString())) { data.BaseInfoId = int.Parse(dr["BaseInfoId"].ToString()); } } if (dr.Table.Columns.Contains("GroupId")) { if (!string.IsNullOrEmpty(dr["GroupId"].ToString())) { data.GroupId = int.Parse(dr["GroupId"].ToString()); } } if (dr.Table.Columns.Contains("Name")) { if (!string.IsNullOrEmpty(dr["Name"].ToString())) { data.Name = dr["Name"].ToString(); } } if (dr.Table.Columns.Contains("DemoStr")) { if (!string.IsNullOrEmpty(dr["DemoStr"].ToString())) { data.DemoStr = dr["DemoStr"].ToString(); } } if (dr.Table.Columns.Contains("Url")) { if (!string.IsNullOrEmpty(dr["Url"].ToString())) { data.Url = dr["Url"].ToString(); } } if (dr.Table.Columns.Contains("Description")) { if (!string.IsNullOrEmpty(dr["Description"].ToString())) { data.Description = dr["Description"].ToString(); } } if (dr.Table.Columns.Contains("ReturnResult")) { if (!string.IsNullOrEmpty(dr["ReturnResult"].ToString())) { data.ReturnResult = dr["ReturnResult"].ToString(); } } if (dr.Table.Columns.Contains("ActionUrl")) { if (!string.IsNullOrEmpty(dr["ActionUrl"].ToString())) { data.ActionUrl = dr["ActionUrl"].ToString(); } } if (dr.Table.Columns.Contains("RequestHeader")) { if (!string.IsNullOrEmpty(dr["RequestHeader"].ToString())) { data.RequestHeader = dr["RequestHeader"].ToString(); } } if (dr.Table.Columns.Contains("RequestBody")) { if (!string.IsNullOrEmpty(dr["RequestBody"].ToString())) { data.RequestBody = dr["RequestBody"].ToString(); } } if (dr.Table.Columns.Contains("OpenTime")) { if (dr["OpenTime"] != null) { data.OpenTime = Convert.ToDateTime(dr["OpenTime"]); } } if (dr.Table.Columns.Contains("UpdateTime")) { if (dr["UpdateTime"] != null) { data.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]); } } if (dr.Table.Columns.Contains("CreateTime")) { if (dr["CreateTime"] != null) { data.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } } if (dr.Table.Columns.Contains("IsDelete")) { if (dr["IsDelete"] != null) { data.IsDelete = Convert.ToBoolean(dr["IsDelete"]); } } if (dr.Table.Columns.Contains("IsAuthorize")) { if (dr["IsAuthorize"] != null) { data.IsAuthorize = Convert.ToBoolean(dr["IsAuthorize"]); } } if (dr.Table.Columns.Contains("HttpType")) { if (dr["HttpType"] != null) { data.HttpType = Convert.ToByte(dr["HttpType"]); } } if (dr.Table.Columns.Contains("ApiGroupName")) { if (!string.IsNullOrEmpty(dr["ApiGroupName"].ToString())) { data.ApiGroupName = dr["ApiGroupName"].ToString(); } } if (dr.Table.Columns.Contains("ApiGroupDesc")) { if (!string.IsNullOrEmpty(dr["ApiGroupDesc"].ToString())) { data.GroupDesc = dr["ApiGroupDesc"].ToString(); } } if (dr.Table.Columns.Contains("GroupUrl")) { if (!string.IsNullOrEmpty(dr["GroupUrl"].ToString())) { data.GroupUrl = dr["GroupUrl"].ToString(); } } }