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> GetAllCoteInfoList() { StringBuilder builder = new StringBuilder(); builder.Append(this.GetTabeleSql); if (!string.IsNullOrWhiteSpace(this.DefalutCondition)) { builder.Append(" where " + this.DefalutCondition + " "); } if (!string.IsNullOrWhiteSpace(this.SortExpression)) { builder.Append(" order by " + this.SortExpression); } MySqlDataReader reader = new WTF.Framework.MySqlHelper(this.ConnectionStringName).ExecuteReader(builder.ToString(), new MySqlParameter[0]); return this.ConvertCoteInfo(reader); }
public List <CoteInfo> GetAllCoteInfoList(string RootIDValue) { if ((this.IDDataType == 1) && !RootIDValue.IsMatch(@"\d+")) { return(new List <CoteInfo>()); } StringBuilder builder = new StringBuilder(); if (string.IsNullOrWhiteSpace(this.IDPathName)) { builder.Append(this.GetTabeleSql); if (!string.IsNullOrWhiteSpace(this.DefalutCondition)) { builder.Append(" where " + this.DefalutCondition + " "); } if (!string.IsNullOrWhiteSpace(this.SortExpression)) { builder.Append(" order by " + this.SortExpression); } } else { builder.AppendLine("SET @IDPath='';"); string str = ""; if (this.IDDataType == 1) { str = this.IDName + "=" + RootIDValue; } else { str = this.IDName + "='" + RootIDValue.Trim() + "'"; } builder.AppendLine("SELECT " + this.IDPathName + " INTO @IDPath FROM " + this.CoteTableName + " WHERE " + str + ";"); builder.AppendLine(this.GetTabeleSql + " WHERE " + this.IDPathName + " LIKE CONCAT( @IDPath,'%') "); if (!string.IsNullOrWhiteSpace(this.DefalutCondition)) { builder.Append(" AND " + this.DefalutCondition + " "); } if (!string.IsNullOrWhiteSpace(this.SortExpression)) { builder.Append(" order by " + this.SortExpression); } } MySqlDataReader reader = new WTF.Framework.MySqlHelper(this.ConnectionStringName).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)); }