private void btnSave_Click(object sender, EventArgs e)
{
if (!getCtrlValue())
{
return;
}
defMgr.Save(ety, DtWhere);
MessageBox.Show("保存成功");
DtWhere = defMgr.getWhereDt(ety.JTPUBQRDEF_ID);
gridControl1.DataSource = DtWhere.DefaultView;
btnParamEnabled();
// string sql = insertDefineParam();
// if (!string.IsNullOrEmpty(sql))
// {
// WebSvrGetData.execsql(this.ProcessID, sql, mgr);
//}
}
private void frmDefEdit_Load(object sender, EventArgs e)
{
DataTable dtsrc = mgr.getDataSet(DevQryPubFun.GSYDBSrc, "select * from GSYDTSRC").Tables[0];
foreach (DataRow row in dtsrc.Rows)
{
JTPUBQRDEF_DBSRC.Properties.Items.Add(row["GSYDTSRC_ID"].ToString());
}
JTPUBQRDEF_DBSRC.Properties.Items.Add(DevQryPubFun.GSYDBSrc);
defMgr = new JTPUBQRDEFMgr(mgr, this.ProcessID);
if (!string.IsNullOrEmpty(ID))
{
ety = defMgr.getEty(ID);
setCtrlValue();
}
DtWhere = defMgr.getWhereDt(ID);
gridControl1.DataSource = DtWhere.DefaultView;
btnParamEnabled();
}
private DataTable getQryData()
{
JTPUBQRDEFMgr defmgr = new JTPUBQRDEFMgr(mgr, ProcessID);
JTPUBQRDEFEty ety = defmgr.getEty(this.ID);
DataTable dt = null;
if (ety.JTPUBQRDEF_TYPE.ToUpper() == "SQL")
{
string sql = ety.JTPUBQRDEF_SQL + " " + ety.JTPUBQRDEF_WHERE;
if (mgr.getDBType(ety.JTPUBQRDEF_DBSRC) == "ORA")
{
sql = ety.JTPUBQRDEF_ORA + " " + ety.JTPUBQRDEF_WHERE;
}
dt = getDataTable(sql, ety.JTPUBQRDEF_DBSRC);
}
else
{
string[] paramArr = null;
string[] valueArr = null;
DataTable dtwhere = defmgr.getWhereDt(this.ID);
if (dtwhere.Rows.Count > 0)
{
paramArr = new string[dtwhere.Rows.Count];
valueArr = new string[dtwhere.Rows.Count];
for (int i = 0; i < dtwhere.Rows.Count; i++)
{
paramArr[i] = dtwhere.Rows[i]["PARAMDEF_NAME"].ToString();
valueArr[i] = "";
}
}
string proc = ety.JTPUBQRDEF_SQL;
if (mgr.getDBType(ety.JTPUBQRDEF_DBSRC) == "ORA")
{
proc = ety.JTPUBQRDEF_ORA;
}
dt = WebSvrGetData.getDataTable(ety.JTPUBQRDEF_DBSRC, ety.JTPUBQRDEF_SQL, paramArr, valueArr, mgr);
}
return(dt);
}
private void btnTest_Click(object sender, EventArgs e)
{
JTPUBQRDEFMgr defmgr = new JTPUBQRDEFMgr(mgr, ProcessID);
JTPUBQRDEFEty ety = defmgr.getEty(this.ID);
DevQryShow frm = new DevQryShow();
if (ety.JTPUBQRDEF_TYPE.ToUpper() == "SQL")
{
string sql = ety.JTPUBQRDEF_SQL;
if (mgr.getDBType(ety.JTPUBQRDEF_DBSRC) == "ORA")
{
sql = ety.JTPUBQRDEF_ORA;
}
frm.showWithParam(ety.JTPUBQRDEF_DBSRC, " ", " ", "", this.ID, "", "2", "2", "", sql, ety.JTPUBQRDEF_SUBTIL, "0", " ");
}
else
{
string vsParam = "";
string vsValue = "";
DataTable dtwhere = defmgr.getWhereDt(this.ID);
if (dtwhere.Rows.Count > 0)
{
for (int i = 0; i < dtwhere.Rows.Count; i++)
{
vsParam += "^" + dtwhere.Rows[i]["PARAMDEF_NAME"].ToString();
vsValue += "^";
}
vsParam = vsParam.Substring(1);
vsValue = vsValue.Substring(1);
}
string proc = ety.JTPUBQRDEF_SQL;
if (mgr.getDBType(ety.JTPUBQRDEF_DBSRC) == "ORA")
{
proc = ety.JTPUBQRDEF_ORA;
}
frm.showProc(ety.JTPUBQRDEF_DBSRC, " ", " ", "", this.ID, "", "2", "2", "", proc, ety.JTPUBQRDEF_SUBTIL, "0", vsParam, vsValue);
}
}