private SqlCommand GetSqlTextCmd() { string sql = base.GetSqlWithoutOrderBy(this._u8DataEngineHelper.SqlFromDataEngine); Hashtable paras = new Hashtable(); if (sql.Contains("@") && this._filterSrv != null) { foreach (string key in this._filterSrv.Keys) { if (key.Contains(".")) { continue; } FilterItem fi = this._filterSrv[key]; string parakey = "@" + fi.Key.ToLower(); if (parakey != _cmdParaFilterString.ToLower() && fi.Value1 != null && !paras.Contains(parakey)) { paras.Add(parakey, fi.Value1); } if (fi.HasSecondValue) { parakey = "@" + fi.Key.ToLower() + "__2"; if (fi.Value2 != null && !paras.Contains(parakey)) { paras.Add(parakey, fi.Value2); } } } } SqlCommand cmd = SqlCommandHelper.GetSqlCommand(sql, paras); cmd.CommandType = CommandType.Text; return(cmd); }
/// <summary> /// 从存储过程将数据填写到临时表 /// </summary> /// <param name="storeprocedureName">存储过程名称</param> /// <param name="tempTableName">目标临时表名称</param> /// <param name="paras">存储过程的参数键值集合</param> public void Storeprocedure2TempTable( string storeprocedureName, string tempTableName, Hashtable paras) { Storeprocedure2TempTable( SqlCommandHelper.GetSqlCommand(storeprocedureName, paras), tempTableName); }
private SqlCommand GetStoreProcedureCmd() { Hashtable paras = new Hashtable(); if (this._u8DataEngineHelper.CmdParameters != null && this._filterSrv != null) { foreach (object obj in this._u8DataEngineHelper.CmdParameters) { if (obj.ToString().ToLower() == "@tablename") { paras.Add("@tablename", null); } else if (obj.ToString().ToLower() == "@filterstring") { paras.Add("@filterstring", this._u8DataEngineHelper.RawFilterString); } else { string key = obj.ToString(); if (key.Contains(".")) { continue; } if (key.EndsWith("__2")) { FilterItem fi = this._filterSrv[key.Substring(1, key.Length - 4)]; if (fi != null && fi.HasSecondValue && fi.Value2 != null) { paras.Add(key, fi.Value2); } } else { FilterItem fi = this._filterSrv[key.Substring(1)]; if (fi != null && fi.Value1 != null) { paras.Add(key, fi.Value1); } } } //FilterItem fi = this._filterSrv[obj.ToString()]; //if (fi != null) // paras.Add(fi.Key, fi.Value1); } } return(SqlCommandHelper.GetSqlCommand( this._u8DataEngineHelper.SqlFromDataEngine, paras)); }
protected override SqlCommand GetHandlingCommand() { return(SqlCommandHelper.GetSqlCommand( base._customDataSource.StoreProcName, GetCmdParas())); }