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);
}
