public static void insertDevRowGS(string processID, WsGetDataClient.WSGetData mgr, DataTable dt, string psDWBH, string psYear, string psBH)
{
psDWBH = string.IsNullOrEmpty(psDWBH) ? " " : psDWBH;
string sql = @"insert into {20} (F_DWBH, F_ID, F_GSBH, F_TIBH,
F_JS, F_FIELD,F_TEXT, F_TYPE,F_ALIGN, F_WIDTH, F_PROP, F_PREC,
F_DISP, F_REAL, F_HJBZ, F_PXBZ, F_YHBZ, F_FHBZ, F_HZBZ, F_COLOR)values
('{0}', '{1}', '{2}', '{3}',
'{4}', '{5}','{6}', '{7}','{8}', {9}, '{10}', '{11}',
'{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}');";
string sqldel = "delete from {0} WHERE F_DWBH='{1}' AND F_ID='{2}' AND F_GSBH='{3}' AND F_TIBH='{4}' ; ";
string vssql = "";
string tbname = "EATIGS" + psYear;
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
if (row["F_FIELD"].ToString() == "F_DT_FIELD" || row["F_FIELD"].ToString() == "F_NUM_FIELD" ||
row["F_FIELD"].ToString() == "F_TXT_FIELD")
{
tbname = "EATIGSDEVQRY";
}
vssql += string.Format(sqldel, tbname, psDWBH, row["F_ID"].ToString(), psBH,
row["F_TIBH"].ToString());
vssql += string.Format(sql, psDWBH, row["F_ID"].ToString(), psBH,
row["F_TIBH"].ToString(), row["F_JS"].ToString(), row["F_FIELD"].ToString(),
row["F_TEXT"].ToString(), row["F_TYPE"].ToString(), row["F_ALIGN"].ToString(),
row["F_WIDTH"].ToString(), row["F_PROP"].ToString(), row["F_PREC"].ToString(),
row["F_DISP"].ToString(), row["F_REAL"].ToString(), row["F_HJBZ"].ToString(),
row["F_PXBZ"].ToString(), row["F_YHBZ"].ToString(), row["F_FHBZ"].ToString(),
row["F_HZBZ"].ToString(), row["F_COLOR"].ToString(), tbname);
// OleDbHelp.execSql(vssql);
}
vssql = "begin " + vssql + " end;";
WebSvrGetData.execsql(processID, vssql, mgr);
}
public static void saveBBTitle(string processID, WsGetDataClient.WSGetData mgr, DataTable dt, string psDWBH, string psYear, string psType, string psBH, string psMC)
{
psDWBH = string.IsNullOrEmpty(psDWBH) ? " " : psDWBH;
string sql = @"insert into EAZBGS{12} (F_DWBH, F_ID, F_GSBH, F_GSMC,
F_CAPT, F_CAPH, F_SCAPH, F_BTGD, F_ROWH, F_BWGD, F_SPACE, F_SYBZ)values
('{0}', '{1}', '{2}', '{3}','{4}', {5}, {6}, {7}, {8}, {9}, {10}, '{11}') ";
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
if (psType == "edit")
{
sql = @" update EAZBGS{12} set F_GSMC='{3}',F_CAPT='{4}', F_CAPH={5}, F_SCAPH={6},
F_BTGD={7}, F_ROWH={8}, F_BWGD={9}, F_SPACE={10}, F_SYBZ='{11}' where F_DWBH='{0}' and F_ID='{1}' and F_GSBH='{2}' ";
}
else
{
WebSvrGetData.execsql(processID, string.Format("delete from EAZBGS{0} where F_DWBH='{1}' and F_ID='{2}' and F_GSBH='{3}' ", psYear, psDWBH, row["F_ID"].ToString(), psBH), mgr);
}
sql = string.Format(sql, psDWBH, row["F_ID"].ToString(), psBH,
psMC, row["F_CAPT"].ToString(), row["F_CAPH"].ToString(), row["F_SCAPH"].ToString(),
row["F_BTGD"].ToString(), row["F_ROWH"].ToString(), row["F_BWGD"].ToString(),
row["F_SPACE"].ToString(), row["F_SYBZ"].ToString(), psYear);
WebSvrGetData.execsql(processID, sql, mgr);
}
}
public static void saveBBSubTitle(string processID, WsGetDataClient.WSGetData mgr, DataTable dt, string psDWBH, string psYear, string psType, string psBH)
{
psDWBH = string.IsNullOrEmpty(psDWBH) ? " " : psDWBH;
string sql = @"insert into EAOTGS{8} (F_DWBH, F_ID, F_GSBH, F_OTBH, F_TEXT, F_OTBZ, F_JS, F_ALIGN)values
('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}');";
string sqldel = "delete from EAOTGS{0} WHERE F_DWBH='{1}' AND F_ID='{2}' AND F_GSBH='{3}' AND F_OTBH='{4}' ; ";
if (dt.Rows.Count > 0)
{
if (psType == "edit")
{
sql = @" update EAOTGS{8} set F_TEXT='{4}', F_OTBZ='{5}', F_JS='{6}', F_ALIGN='{7}'
where F_DWBH='{0}' and F_ID='{1}' and F_GSBH='{2}' and F_OTBH='{3}';";
}
string vssql = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
string vsOTBH = i.ToString().PadLeft(2, '0');
DataRow row = dt.Rows[i];
vssql += string.Format(sqldel, psYear, psDWBH, row["F_ID"].ToString(), psBH, vsOTBH);
vssql += string.Format(sql, psDWBH, row["F_ID"].ToString(), psBH,
vsOTBH, row["F_TEXT"].ToString(), row["F_OTBZ"].ToString(), row["F_JS"].ToString(), row["F_ALIGN"].ToString(), psYear);
// OleDbHelp.execSql(vssql);
}
vssql = "begin " + vssql + " end;";
WebSvrGetData.execsql(processID, vssql, mgr);
}
}
public static void execsqlAysnc(string processID, string sql, WsGetDataClient.WSGetData mgr)
{
sql = encstr + DesEncrypt.Encrypt(sql);
mgr.execsqlAsync(processID, sql);
mgr.execsqlCompleted += new execsqlCompletedEventHandler((o, a) => {
Console.WriteLine(o.ToString());
//Response.Write(string.Format("完成时间：{0}。 结果{1}<Br>", DateTime.Now.ToString("mm:ss.ffff"), a.Result));
});
}
public static void saveBBRowGS(string processID, WsGetDataClient.WSGetData mgr, DataTable dt, string psDWBH, string psYear, string psType, string psBH)
{
psDWBH = string.IsNullOrEmpty(psDWBH) ? " " : psDWBH;
/*SELECT F_DWBH, F_ID, F_GSBH, F_TIBH, F_JS, F_FIELD, F_TEXT, F_TYPE, F_ALIGN, F_WIDTH, F_PROP, F_PREC, F_DISP, F_REAL, F_HJBZ, F_PXBZ, F_YHBZ, F_FHBZ, F_HZBZ, F_COLOR
* FROM LSTIGS;*/
string sql = @"insert into {20} (F_DWBH, F_ID, F_GSBH, F_TIBH,
F_JS, F_FIELD,F_TEXT, F_TYPE,F_ALIGN, F_WIDTH, F_PROP, F_PREC,
F_DISP, F_REAL, F_HJBZ, F_PXBZ, F_YHBZ, F_FHBZ, F_HZBZ, F_COLOR,F_TSTEXT,F_GROUP,F_TSHID,F_ISGD,F_PSUMTYPE,F_FORMAT)values
('{0}', '{1}', '{2}', '{3}',
'{4}', '{5}','{6}', '{7}','{8}', {9}, '{10}', '{11}',
'{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}','{21}','{22}','{23}','{24}','{25}','{26}');";
if (dt.Rows.Count > 0)
{
/*增加修改编号功能，实现排序，所有的格式先删除，后增加，update语句不用了
*
* if (psType=="edit")
* {
* sql = @" update {20} set
* F_JS='{4}', F_FIELD='{5}',F_TEXT='{6}', F_TYPE='{7}',F_ALIGN='{8}', F_WIDTH={9}, F_PROP='{10}', F_PREC='{11}',
* F_DISP='{12}', F_REAL='{13}', F_HJBZ='{14}', F_PXBZ='{15}', F_YHBZ='{16}', F_FHBZ='{17}', F_HZBZ='{18}', F_COLOR='{19}'
* where F_DWBH='{0}' and F_ID='{1}' and F_GSBH='{2}' and F_TIBH='{3}' ;";
* } */
string vssql = " ";
string tbname = "EATIGS" + psYear;
vssql += string.Format("delete from {0} where F_DWBH='{1}' and F_ID='{2}' and F_GSBH='{3}'; ", tbname, psDWBH, dt.Rows[0]["F_ID"].ToString(), psBH);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
if (row["F_FIELD"].ToString() == "F_DT_FIELD" || row["F_FIELD"].ToString() == "F_NUM_FIELD" ||
row["F_FIELD"].ToString() == "F_TXT_FIELD")
{
tbname = "EATIGSDEVQRY";
}
vssql += string.Format(sql, psDWBH, row["F_ID"].ToString(), psBH,
row["F_TIBH"].ToString(), row["F_JS"].ToString(), row["F_FIELD"].ToString(),
row["F_TEXT"].ToString(), row["F_TYPE"].ToString(), row["F_ALIGN"].ToString(),
row["F_WIDTH"].ToString(), row["F_PROP"].ToString(), row["F_PREC"].ToString(),
row["F_DISP"].ToString(), row["F_REAL"].ToString(), row["F_HJBZ"].ToString(),
row["F_PXBZ"].ToString(), row["F_YHBZ"].ToString(), row["F_FHBZ"].ToString(),
row["F_HZBZ"].ToString(), row["F_COLOR"].ToString(), tbname,
row["F_TSTEXT"].ToString(), row["F_GROUP"].ToString(), row["F_TSHID"].ToString(),
row["F_ISGD"].ToString(), row["F_PSUMTYPE"].ToString(), row["F_FORMAT"].ToString());
// OleDbHelp.execSql(vssql);
}
vssql = "begin " + vssql + " end;";
WebSvrGetData.execsql(processID, vssql, mgr);
}
}
public static DataTable getDataTable(string processID, WsGetDataClient.WSGetData mgr, string sql)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
sql = encstr + DesEncrypt.Encrypt(sql);
ds = StringToDataSet.getDataSetFromZipDataFormat(mgr.getZipDataFormatByte(processID, sql));
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
//public static void Main()
//{
// ThreadDemo demo = new ThreadDemo(1000);
// demo.Action();
//}
public WebSvrThreadGetData(string psprocessID, long psPgnum, string psSql, string psOrderKey, WsGetDataClient.WSGetData psMgr, frmDevBBShow psFrmshow)
{
processID = psprocessID;
pgnum = psPgnum;
sql = psSql;
strOrderKey = psOrderKey;
mgr = psMgr;
frmshow = psFrmshow;
string dbtype = mgr.getDBType(processID);
string vssql = "";
if (dbtype == "ora")
{
vssql = "select * from ( {0} )z1 where rownum>{1} and rownum<={2} ";
}
else
{
if (string.IsNullOrEmpty(strOrderKey))
{
throw new Exception("数据量过大，请联系开发人员调用异步加载方式！");
}
vssql = @"select top {1} * from
( select top {2} * from ({0}) z1 order by {3}) z2
order by {3} desc ";
}
threads = new Thread[pgnum];
for (int m = 0; m < pgnum; m++)
{
long longs = m * WebSvrGetData.pgNum;
long longe = (m + 1) * WebSvrGetData.pgNum;
if (dbtype == "ora")
{
sql = string.Format(vssql, sql, longs + "", longe + "");
}
else
{
sql = string.Format(vssql, sql, WebSvrGetData.pgNum, longe + "", strOrderKey);
}
threads[m] = new Thread(new ParameterizedThreadStart(getData));
threads[m].Start(sql);
}
OnNumberClear += new EventHandler(ThreadDemo_OnNumberClear);
}
public void execsql(WsGetDataClient.WSGetData mgr, string processID, string sql)
{
sql = WebSvrGetData.encstr + DesEncrypt.Encrypt(sql);
mgr.execsql(processID, sql);
}
public static void execsql(string processID, string sql, WsGetDataClient.WSGetData mgr)
{
sql = encstr + DesEncrypt.Encrypt(sql);
mgr.execsql(processID, sql);
}
public static DataSet GetDataSet(string processID, string sql, string strOrderKey, WsGetDataClient.WSGetData mgr, string fieldStr, string IsRepeatDown)
{
DataSet ds = new DataSet();
sql = encstr + DesEncrypt.Encrypt(sql);
if (IsRepeatDown == "1")
{
string countsql = "select count(1) " + sql.Substring(sql.ToLower().IndexOf(" from "));
DataSet dscount = mgr.getDataSet(processID, countsql);
long dtcount = 0;
if (dscount != null && dscount.Tables.Count > 0)
{
dtcount = Convert.ToInt64(dscount.Tables[0].Rows[0][0]);
}
if (dtcount <= pgNum)
{
ds = StringToDataSet.getDataSetFromZipDataFormat(mgr.getZipDataFormatByte(processID, sql));
}
else
{
WebSvrGetDataAsync getDataSync = new WebSvrGetDataAsync(processID, dtcount, sql, strOrderKey, mgr, fieldStr);
ds = getDataSync.returnDataSet();
}
}
else
{
ds = StringToDataSet.getDataSetFromZipDataFormat(mgr.getZipDataFormatByte(processID, sql));
}
return(ds);
}
public static DataTable getDataTable(string processID, string ProName, string[] paramArr, string[] valueArr, WsGetDataClient.WSGetData mgr)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
ds = StringToDataSet.getDataSetFromZipDataFormat(mgr.getZipDataFormatByteProc(processID, ProName, paramArr, valueArr));
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
public static DataSet getDataSet(string processID, string ProName, string[] paramArr, string[] valueArr, WsGetDataClient.WSGetData mgr)
{
DataSet ds = new DataSet();
ds = StringToDataSet.getDataSetFromZipDataFormat(mgr.getZipDataFormatByteProc(processID, ProName, paramArr, valueArr));
return(ds);
}
private void ansyncGetDataSet(string processID, long dtcount, string sql, string strOrderKey, WsGetDataClient.WSGetData mgr)
{
string dbtype = mgr.getDBType(processID);
string vssql = "";
string sqlexe = "";
if (dbtype == "ora")
{
vssql = " select * from (select rownum rn {3} from ( {0} )z1)z2 where rn>{1} and rn<={2} ";
}
else
{
if (string.IsNullOrEmpty(strOrderKey))
{
throw new Exception("数据量过大，请联系开发人员调用异步加载方式！");
}
vssql = @"select top {1} * from
( select top {2} * from ({0}) z1 order by {3}) z2
order by {3} desc ";
}
if (loadNum > 0)
{
delArr = new AsyncDelegate[loadNum];
arArr = new IAsyncResult[loadNum];
bool[] blLoadDs = new bool[loadNum];
for (int m = 0; m < loadNum; m++)
{
blLoadDs[m] = false;
long longs = m * WebSvrGetData.pgNum;
long longe = (m + 1) * WebSvrGetData.pgNum;
if (m == loadNum - 1)
{
longe = _dtCount;
}
if (dbtype == "ora")
{
sqlexe = string.Format(vssql, sql, longs + "", longe + "", FieldStr);
}
else
{
sqlexe = string.Format(vssql, sql, Convert.ToString(longe - longs), longe + "", strOrderKey);
}
sqlexe = WebSvrGetData.encstr + DesEncrypt.Encrypt(sqlexe);
WebSvrGetDataAsyncDelegate delobj = new WebSvrGetDataAsyncDelegate();
delArr[m] = new AsyncDelegate(delobj.getData);
arArr[m] = delArr[m].BeginInvoke(mgr, processID, sqlexe, null, null);
}
bool delCompleted = false;
while (delCompleted == false)
{
delCompleted = true;
for (int n = 0; n < loadNum; n++)
{
IAsyncResult ar = arArr[n];
if (!ar.IsCompleted)
{
delCompleted = false;
break;
}
else
{
if (!blLoadDs[n])
{
blLoadDs[n] = true;
DataSet dsre = delArr[n].EndInvoke(ar);
ds.Merge(dsre);
}
}
}
Thread.Sleep(10);
}
}
}
public JTPUBQRDEFMgr(WsGetDataClient.WSGetData vsmgr, string vsPressID)
{
mgr = vsmgr;
}
public DataSet getData(WsGetDataClient.WSGetData mgr, string processID, string sql)
{
sql = WebSvrGetData.encstr + DesEncrypt.Encrypt(sql);
return(StringToDataSet.getDataSetFromZipDataFormat(mgr.getZipDataFormatByte(processID, sql)));
}
public static DataSet GetDataSet(string processID, string sql, string strOrderKey, WsGetDataClient.WSGetData mgr, string fieldStr)
{
DataSet ds = new DataSet();
sql = encstr + DesEncrypt.Encrypt(sql);
ds = StringToDataSet.getDataSetFromZipDataFormat(mgr.getZipDataFormatByte(processID, sql));
return(ds);
}
private void syncGetDataSet(string processID, long dtcount, string sql, string strOrderKey, WsGetDataClient.WSGetData mgr)
{
sql = WebSvrGetData.encstr + DesEncrypt.Encrypt(sql);
string dbtype = mgr.getDBType(processID);
string vssql = "";
if (dbtype == "ora")
{
vssql = "select * from ( {0} )z1 where rownum>{1} and rownum<={2} ";
}
else
{
if (string.IsNullOrEmpty(strOrderKey))
{
throw new Exception("数据量过大，请联系开发人员调用异步加载方式！");
}
vssql = @"select top {1} * from
( select top {2} * from ({0}) z1 order by {3}) z2
order by {3} desc ";
}
for (int m = 0; m < loadNum; m++)
{
long longs = m * WebSvrGetData.pgNum;
long longe = (m + 1) * WebSvrGetData.pgNum;
if (dbtype == "ora")
{
sql = string.Format(vssql, sql, longs + "", longe + "");
}
else
{
sql = string.Format(vssql, sql, WebSvrGetData.pgNum, longe + "", strOrderKey);
}
DataSet dsre = StringToDataSet.getDataSetFromZipDataFormat(mgr.getZipDataFormatByte(processID, sql));
if (ds == null)
{
ds = dsre.Copy();
}
else
{
foreach (DataRow row in dsre.Tables[0].Rows)
{
ds.Tables[0].Rows.Add(row.ItemArray);
}
}
}
}
public LSTIGSDEVQRYMgr(WsGetDataClient.WSGetData vsmgr, string vsPressID)
{
mgr = vsmgr;
}
public WebSvrGetDataAsync(string processID, long dtCount, string sql, string strOrderKey, WsGetDataClient.WSGetData mgr, string fieldStr)
{
_dtCount = dtCount;
FieldStr = fieldStr;
sql = WebSvrGetData.encstr + DesEncrypt.Encrypt(sql);
loadNum = dtCount % WebSvrGetData.pgNum == 0 ? dtCount / WebSvrGetData.pgNum : dtCount / WebSvrGetData.pgNum + 1;
ansyncGetDataSet(processID, dtCount, sql, strOrderKey, mgr);
}
