public List<CoteInfo> GetCoteInfoKeyList(string key)
{
string str = "";
if (this.IDDataType == 1)
{
str = this.IDName + " in (" + key + ")";
}
else
{
str = this.IDName + " in (" + key.ConvertStringID() + ")";
}
if (!string.IsNullOrWhiteSpace(this.DefalutCondition))
{
str = str + " and " + this.DefalutCondition;
}
WTF.Framework.MySqlHelper helper = new WTF.Framework.MySqlHelper(this.ConnectionStringName);
StringBuilder builder = new StringBuilder();
builder.Append(this.GetTabeleSql);
if (!string.IsNullOrWhiteSpace(str))
{
builder.Append(" where " + str + " ");
}
if ((key.Split(new char[] { ',' }).Length > 1) && !string.IsNullOrWhiteSpace(this.SortExpression))
{
builder.Append(" order by " + this.SortExpression);
}
MySqlDataReader reader = helper.ExecuteReader(builder.ToString(), new MySqlParameter[0]);
return this.ConvertCoteInfo(reader);
}
public List <CoteInfo> GetCoteInfoKeyList(string key)
{
if (string.IsNullOrWhiteSpace(key))
{
return(new List <CoteInfo>());
}
string str = "";
if (this.IDDataType == 1)
{
string str2 = "";
foreach (string str3 in key.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries))
{
if (str3.IsMatch(@"\d+"))
{
str2 = str2 + str3 + ",";
}
}
str = this.IDName + " in (" + str2.TrimEndComma() + ")";
}
else
{
str = this.IDName + " in (" + key.ConvertStringID() + ")";
}
if (!string.IsNullOrWhiteSpace(this.DefalutCondition))
{
str = str + " and " + this.DefalutCondition;
}
WTF.Framework.MySqlHelper helper = new WTF.Framework.MySqlHelper(this.ConnectionStringName);
StringBuilder builder = new StringBuilder();
builder.Append(this.GetTabeleSql);
if (!string.IsNullOrWhiteSpace(str))
{
builder.Append(" where " + str + " ");
}
if ((key.Split(new char[] { ',' }).Length > 1) && !string.IsNullOrWhiteSpace(this.SortExpression))
{
builder.Append(" order by " + this.SortExpression);
}
MySqlDataReader reader = helper.ExecuteReader(builder.ToString(), new MySqlParameter[0]);
return(this.ConvertCoteInfo(reader));
}
