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