public bool delete(string tableName, int count = 10000) { bool ret = true; int COUNT = 0; string sql = String.Format("SELECT COUNT(1) FROM {0}.{1}", m_TableSchema, tableName); if (select(sql)) { m_reader.Read(); int c = m_reader.GetInt32(0); COUNT = c / count + 1; m_reader.Close(); } else { return(false); } sql = String.Format("DELETE (SELECT * FROM {0}.{1} FETCH FIRST {2} ROWS ONLY)", m_TableSchema, tableName, count); for (int n = 0; n < COUNT; n++) { update(sql); } return(ret); }
/// <summary> /// 根据日切日期查询zbmxz结果集 /// </summary> /// <param name="rqrq">日切日期</param> /// <returns></returns> public List <ZbmxzModel> GetZbmxzByRqrq(string rqrq) { List <ZbmxzModel> list = new List <ZbmxzModel>(); ZbmxzModel zbmxz; string cmdString = "select * from zbmxz where djrq >= '" + rqrq + "'"; this.Open(); try { db2Cmd = new DB2Command(cmdString, this.db2Conn); DB2DataReader dr = db2Cmd.ExecuteReader(); while (dr.Read()) { zbmxz = new ZbmxzModel(); zbmxz.Bc = dr.GetInt32(1).ToString(); zbmxz.Zh = dr.GetString(2); zbmxz.Jyrq = dr.GetDate(3).ToShortDateString(); zbmxz.Jysj = dr.GetDateTime(4).ToLongTimeString(); zbmxz.Fse = dr.GetDecimal(5).ToString(); zbmxz.Ye = dr.GetDecimal(6).ToString(); zbmxz.Yhls = dr.GetString(7); zbmxz.Pjhm = dr.GetString(8); zbmxz.Jdbz = dr.GetString(9); zbmxz.Ywlx = dr.GetString(10); zbmxz.Dfzh = dr.GetString(11); zbmxz.Dfhm = dr.GetString(12); zbmxz.Zxjsh = dr.GetString(13); list.Add(zbmxz); } } catch (Exception ex) { LogHelper.WriteLogException("Execute sql command error in Db2Operation.GetZbmxzByRqrq()", ex); throw; } finally { this.Close(); } return(list); }
private int colCant(string tab) { int c = 0; try { DB2Command cmd = new DB2Command("select count(*) from syscat.columns where tabname = '" + tab + "'", connect); using (DB2DataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { c = dr.GetInt32(0); } } } catch (DB2Exception e) { MessageBox.Show(e.ToString()); } return(c); }