60 lines
1.7 KiB
C#
60 lines
1.7 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Configuration;
|
|
using System.Collections;
|
|
using System.Web;
|
|
using System.Web.Security;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Web.UI.WebControls.WebParts;
|
|
using System.Web.UI.HtmlControls;
|
|
using GThinking.N_MODEL.Page;
|
|
using GThinking.N_MODEL.Dialog;
|
|
using GThinking.N_PUBLIC;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using GThinking.N_MISPRO.Data;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
public partial class XLXLXHQuery : SingleQueryBase
|
|
{
|
|
XLXHB_M queryentity = new XLXHB_M();
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 101421000;
|
|
this.UMName = "ÏßÀÂÐͺÅ";
|
|
this.CurMaster = Master;
|
|
this.CurQueryTable = QueryTable;
|
|
this.CurQueryEntity = queryentity;
|
|
base.InitPage();
|
|
if (!IsPostBack)
|
|
{
|
|
InitControl();
|
|
}
|
|
}
|
|
|
|
#region ×Ô¶¨Òåʼþ
|
|
|
|
private void InitControl()
|
|
{
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sSQL = new TSQL(dberp);
|
|
sSQL.Clear();
|
|
sSQL.Add("select distinct XLXHB_CPYT,XLCPYT_CPYTMC from XLXHB left join XLCPYT on XLCPYT_CPYT=XLXHB_CPYT where isnull(XLXHB_CPYT,' ') <> ' ' ");
|
|
cbxCPYT.ClearItems();
|
|
cbxCPYT.Items.Add(new ListItem("", ""));
|
|
DataSet ds = dberp.OpenDataSet(sSQL);
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
|
{
|
|
cbxCPYT.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLCPYT_CPYTMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXHB_CPYT"].ToString().Trim()));
|
|
}
|
|
}
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
}
|
|
}
|