public List <ApplicationInterfaceRelation> GetApplicationInterfaceRealtionList(IDbCommand icmd, string fields, string condition)
{
icmd.Parameters.Clear();
MySqlCommand cmd = icmd as MySqlCommand;
cmd.CommandType = CommandType.Text;
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select {0} from applicationinterfacerelation ", fields);
if (!string.IsNullOrEmpty(condition))
{
sb.AppendFormat("{0} ", condition);
}
cmd.CommandText = sb.ToString();
List <ApplicationInterfaceRelation> list = new List <ApplicationInterfaceRelation>();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
if (dt.Rows.Count > 0)
{
ApplicationInterfaceRelation info = null;
foreach (DataRow dr in dt.Rows)
{
info = new ApplicationInterfaceRelation();
info.AllParse(dr);
if (null != info)
{
list.Add(info);
}
}
}
return(list);
}
public ApplicationInterfaceRelation GetApplicationInterfaceRelation(IDbCommand icmd, Guid appid, Guid interfaceid, Guid destinappid)
{
icmd.Parameters.Clear();
MySqlCommand cmd = icmd as MySqlCommand;
cmd.CommandType = CommandType.Text;
string sql = @"select Id,appId,appname,interfaceId,interfacename,updatetime,destinappid,destinappname from applicationinterfacerelation where appId = '{0}' and interfaceId = '{1}' and destinappid = '{2}'";
cmd.CommandText = string.Format(sql, appid, interfaceid, destinappid);
ApplicationInterfaceRelation info = null;
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
if (dt.Rows.Count > 0)
{
info = new ApplicationInterfaceRelation();
info.AllParse(dt.Rows[0]);
}
return(info);
}