public int InsertByHashtable(string tableName, Hashtable paramlist) { StringBuilder sb = new StringBuilder("insert into {0}({1}) values({2})"); StringBuilder sbColumns = new StringBuilder(); StringBuilder sbValues = new StringBuilder(); foreach (DictionaryEntry item in paramlist) { if (sbColumns.Length == 0) { sbColumns.Append(item.Key); } else { sbColumns.Append("," + item.Key); } if (sbValues.Length == 0) { sbValues.Append("@" + item.Key); } else { sbValues.Append(",@" + item.Key); } } string sql = string.Format("insert into {0}({1}) values({2})", tableName, sbColumns.ToString(), sbValues.ToString()); return(DbHelperSQL2.ExecuteSql(sql, paramlist)); }
public DataTable Query(string sqlStr, Hashtable paramlist = null) { DataTable dt = null; // SqlParameter[] cmdParms = BuildSqlParameters(paramlist); dt = DbHelperSQL2.QueryReturnDataTable(sqlStr, paramlist); return(dt); }
public int InsertTable(Hashtable ht, string tableName) { StringBuilder sb = new StringBuilder(); StringBuilder sbVal = new StringBuilder(); foreach (DictionaryEntry item in ht) { sb.AppendFormat("{0},", item.Key); sbVal.AppendFormat("@{0},", item.Key); } string InsertSql = string.Format("insert into {0}({1}) values({2})", tableName, sb.ToString().Trim(','), sbVal.ToString().Trim(',')); return(DbHelperSQL2.ExecuteSql(InsertSql, ht)); }
public DateTime GetDBDate() { try { string sql = "select getdate()"; object ob = DbHelperSQL2.GetSingle(sql); DateTime dt = Convert.ToDateTime(ob); return(dt); } catch { return(DateTime.Now); } }
public int UpdateTable(Hashtable ht, string tableName, string idName = "id") { StringBuilder sb = new StringBuilder(); foreach (DictionaryEntry item in ht) { if (!item.Key.ToString().Equals(idName, StringComparison.CurrentCultureIgnoreCase)) { sb.AppendFormat(" {0} = @{0},", item.Key); } } string UpdateSql = string.Format("update {0} set {1} where {2}=@{2}", tableName, sb.ToString().Trim(','), idName); return(DbHelperSQL2.ExecuteSql(UpdateSql, ht)); }
public int InsertReturnID(string sql, Hashtable paramlist = null) { // SqlParameter[] cmdParms = BuildSqlParameters(paramlist); sql += ";select @@IDENTITY as id"; int rs = 0; using (IDataReader dr = DbHelperSQL2.ExecuteReader(sql, paramlist)) { if (dr.Read()) { rs = Convert.ToInt32(dr["id"]); } dr.Close(); } return(rs); }
public string GetStringData(string sql, Hashtable pararm = null) { string strobj = string.Empty; // SqlParameter[] parameters = BuildSqlParameters(pararm); object ob = DbHelperSQL2.GetSingle(sql, pararm); try { if (ob != null) { strobj = ob.ToString(); } } catch { } return(strobj); }
public double GetDoubleData(string sql, Hashtable pararm = null) { double dValue = 0; object ob = DbHelperSQL2.GetSingle(sql, pararm); try { if (ob != null) { if (double.TryParse(ob.ToString(), out dValue)) { return(dValue); } return(0); } } catch { } return(dValue); }
/// <summary> /// 分页查询 /// </summary> /// <param name="PageCount">总页数</param> /// <param name="DataSize">总数据量</param> /// <param name="table">表名</param> /// <param name="key">主键字段</param> /// <param name="strWhere">查询条件</param> /// <param name="order">排序(记得加 asc 或者 desc)</param> /// <param name="beginNUM">开始位置(一般为0)</param> /// <param name="PageIndex">当前页索引(从1开始)</param> /// <param name="PageSize">一页显示的数据条数</param> /// <param name="htParam">参数</param> /// <returns></returns> public DataSet PageQueryWithParams(ref int PageCount, ref int DataSize, string table, string key, string strField, string strWhere, string order, int beginNUM, int PageIndex, int PageSize) { SqlParameter PCount = new SqlParameter("@PCount", SqlDbType.Int); PCount.Direction = ParameterDirection.Output; SqlParameter RCount = new SqlParameter("@RCount", SqlDbType.Int); RCount.Direction = ParameterDirection.Output; SqlParameter[] parameters = { PCount, RCount, new SqlParameter("@sys_Table", SqlDbType.NVarChar), new SqlParameter("@sys_Key", SqlDbType.VarChar), new SqlParameter("@sys_Fields", SqlDbType.NVarChar), new SqlParameter("@sys_Where", SqlDbType.NVarChar), new SqlParameter("@sys_Order", SqlDbType.NVarChar), new SqlParameter("@sys_Begin", SqlDbType.Int), new SqlParameter("@sys_PageIndex", SqlDbType.Int), new SqlParameter("@sys_PageSize", SqlDbType.Int) }; parameters[2].Value = table; parameters[3].Value = key; parameters[4].Value = strField; parameters[5].Value = strWhere; parameters[6].Value = order; parameters[7].Value = beginNUM; parameters[8].Value = PageIndex; parameters[9].Value = PageSize; DataSet ds = DbHelperSQL2.RunProcedure("sys_Page_v2", parameters, "ds"); PageCount = Convert.ToInt32(PCount.Value); DataSize = Convert.ToInt32(RCount.Value); return(ds); }
public int GetIntData(string sql, Hashtable pararm = null) { int intValue = 0; // SqlParameter[] parameters = BuildSqlParameters(pararm); object ob = DbHelperSQL2.GetSingle(sql, pararm); try { if (ob != null) { if (int.TryParse(ob.ToString(), out intValue)) { return(intValue); } return(0); } } catch { } return(intValue); }
//public int UIDTran(Dictionary<string,IList<SqlParameter>> SQLStringList) //{ // Dictionary<string, SqlParameter[]> tranSQLStringList = new Dictionary<string, SqlParameter[]>(); // foreach (KeyValuePair<string, IList<SqlParameter>> myDE in SQLStringList) // { // IList<SqlParameter> htParams = (IList<SqlParameter>)myDE.Value; // SqlParameter[] parameters = htParams.ToArray<SqlParameter>(); // tranSQLStringList.Add(myDE.Key, parameters); // } // return DbHelperSQL2.ExecuteSqlTran(tranSQLStringList); //} public object GetSingle(string sql, Hashtable pararm = null) { // SqlParameter[] parameters = BuildSqlParameters(pararm); return(DbHelperSQL2.GetSingle(sql, pararm)); }
public int UID(string sql, Hashtable pararm = null) { // SqlParameter[] parameters = BuildSqlParameters(pararm); return(DbHelperSQL2.ExecuteSql(sql, pararm)); }
public int UID(string Sql) { return(DbHelperSQL2.ExecuteSql(Sql)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string sql, Hashtable paramlist = null) { // SqlParameter[] cmdParms = BuildSqlParameters(paramlist); return(DbHelperSQL2.Exists(sql, paramlist)); }
public int GetMaxID() { string sql = "select seq_id.nextval from dual"; return(Convert.ToInt32(DbHelperSQL2.GetSingle(sql))); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string sql) { return(DbHelperSQL2.Exists(sql)); }