private void BindDDL()
{
tab3DATE1.SelectedDate = DateTime.Now;
tab3DATE2.SelectedDate = DateTime.Now;
DepartmentBind.BindDDL("DDL_SYS_DEPOTRANGE", UserAction.UserID, lstDEPTOUT);
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID);
}
private void DataInit()
{
this.dpkout1.SelectedDate = DateTime.Now.AddMonths(-1);
this.dpkout2.SelectedDate = DateTime.Now;
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTID);
PubFunc.DdlDataGet("DDL_USER", lblLRY);
}
private void BindDDL()
{
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-7);
lstLRRQ1.MinDate = DateTime.Now.AddDays(-90);
lstLRRQ2.SelectedDate = DateTime.Now;
lstLRRQ2.MaxDate = DateTime.Now;
DepartmentBind.BindDDL("DDL_SYS_DEPTHASATH", UserAction.UserID, ddlDEPTID);
//PubFunc.DdlDataGet(ddlCATID, "DDL_SYS_CATLNULL");
string strSql = @"select * from
(SELECT '' CODE,'--请选择--' NAME,0 TreeLevel,0 islast FROM dual
union all
select code,
'【' || code || '】' || name name,
class TreeLevel,
decode(islast, 'Y', 1, 0) islast
from sys_category
ORDER BY code)
ORDER BY DECODE(CODE,'',99,0) DESC ,CODE ASC ";
List <CategoryTreeBean> myList = new List <CategoryTreeBean>();
DataTable categoryTreeTable = DbHelperOra.Query(strSql).Tables[0];
foreach (DataRow dr in categoryTreeTable.Rows)
{
myList.Add(new CategoryTreeBean(dr["code"].ToString(), dr["name"].ToString(), Convert.ToInt16(dr["TreeLevel"]), Convert.ToInt16(dr["islast"]) == 1));
}
// 绑定到下拉列表（启用模拟树功能）
ddlCATID.EnableSimulateTree = true;
ddlCATID.DataTextField = "Name";
ddlCATID.DataValueField = "Id";
//ddlCATID.DataEnableSelectField = "EnableSelect";
ddlCATID.DataSimulateTreeLevelField = "Level";
ddlCATID.DataSource = myList;//DbHelperOra.Query(strSql).Tables[0];
ddlCATID.DataBind();
}
private void DataInit()
{
ButtonHidden(btnCopy);
//PubFunc.DdlDataGet("DDL_SYS_DEPOT", lstDEPTOUT, docDEPTOUT);
PubFunc.DdlDataGet("DDL_SYS_DEPTDEF", lstDEPTOUT, docDEPTOUT);
DepartmentBind.BindDDL("DDL_SYS_DEPARTMENTRANGE", UserAction.UserID, lstDEPTID, docDEPTID);
//DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID, docDEPTID);
PubFunc.DdlDataGet("DDL_USER", lstSLR, docLRY, docSLR, docSHR);
//PubFunc.DdlDataGet("DDL_SYS_DEPTNULL", lstDEPTID, docDEPTID);
//PubFunc.DdlDataGet("DDL_BILL_STATUSDHD", docFLAG);
PubFunc.DdlDataSql(lstFLAG, @"SELECT '' CODE ,'--请选择--' NAME FROM dual
union all
SELECT 'N' CODE ,'新 单' NAME FROM dual
union all
SELECT 'Y' CODE ,'已审核' NAME FROM dual
");
PubFunc.DdlDataSql(docFLAG, @"SELECT '' CODE ,'--请选择--' NAME FROM dual
union all
SELECT 'N' CODE ,'新 单' NAME FROM dual
union all
SELECT 'Y' CODE ,'已审核' NAME FROM dual
");
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-1);
lstLRRQ2.SelectedDate = DateTime.Now;
}
private void BindDDL()
{
dpkDATE1.SelectedDate = DateTime.Now;
dpkDATE2.SelectedDate = DateTime.Now;
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTID);
PubFunc.DdlDataGet(ddlSUPID, "DDL_DOC_SUPPLIERNULL");
}
private void DataInit()
{
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID);
//lstDEPTID.SelectedValue = UserAction.UserDept;
//dpkMonth.Text = DateTime.Now.ToString("yyyy-MM");
dpkBegRQ.SelectedDate = DateTime.Now.AddDays(-DateTime.Now.Day + 1);
dpkEndRQ.SelectedDate = DateTime.Now;
}
private void DataInit()
{
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID);
PubFunc.DdlDataGet("DDL_BILL_STATUSSLD", lstFLAG);
lstFLAG.SelectedValue = "S";
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-1);
lstLRRQ2.SelectedDate = DateTime.Now;
}
private void BindDDL()
{
DepartmentBind.BindDDL("DDL_SYS_DEPTHASATH", UserAction.UserID, ddlDEPTID, lstDEPTID);
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-7);
lstLRRQ2.SelectedDate = DateTime.Now;
dpkBegRQ.SelectedDate = DateTime.Now.AddDays(-7);
dpkEndRQ.SelectedDate = DateTime.Now;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID);
tgbPJYF.Text = DateTime.Now.ToString("yyyy-MM");
}
}
private void DataInit()
{
PubFunc.DdlDataGet("DDL_SYS_DEPOT", ddlDEPTIN);
//PubFunc.DdlDataGet("DDL_SYS_DEPTRANGE", UserAction.UserID, docDEPTID, lstDEPTID);
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTIN);
dpkLRRQ1.SelectedDate = DateTime.Now.AddDays(-7);
dpkLRRQ2.SelectedDate = DateTime.Now.AddDays(-1);
}
private void BindDDL()
{
DepartmentBind.BindDDL("DDL_SYS_DEPTHASATH", UserAction.UserID, ddlDEPTID);
PubFunc.DdlDataGet("DDL_SYS_DEPTGROUPHASATH", ddlSTR5);
PubFunc.DdlDataGet("DDL_USER", ddlLRY);
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-1);
lstLRRQ2.SelectedDate = DateTime.Now;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTINT);
dpkout1.SelectedDate = DateTime.Now;
dpkout2.SelectedDate = DateTime.Now;
}
}
private void BindDDL()
{
// 绑定到下拉列表（启用模拟树功能）
DepartmentBind.BindDDL("DDL_SYS_DEPTHASATH", UserAction.UserID, ddlDEPTID);
PubFunc.DdlDataGet(ddlSHSID, "DDL_DOC_SHS");
ddlDEPTID.SelectedIndex = 0;
ddlSHSID.SelectedIndex = 0;
USERID.Text = UserAction.UserID;
}
private void DataInit()
{
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-1);
lstLRRQ2.SelectedDate = DateTime.Now;
//当前用户是护士长，申领人下拉只显示当前科室下的用户
if (UserAction.UserRole == "02")
{
string sqls = string.Format(@"select CODE,NAME from (
SELECT '--请选择--' NAME,'' CODE FROM dual
union all
select username name, userid code
from sys_operuser
where roleid = '{0}' and dept = '{1}' and islogin = '******')", UserAction.UserRole, UserAction.UserDept);
PubFunc.DdlDataSql(docLRY, sqls);
PubFunc.DdlDataSql(docSQR, sqls);
PubFunc.DdlDataSql(docSHR, sqls);
PubFunc.DdlDataSql(lstSQR, sqls);
}
else
{
PubFunc.DdlDataGet("DDL_USER", docLRY, docSQR, docSHR, lstSQR);
}
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, docDEPTID, lstDEPTID);
if (docDEPTID.Items.Count > 0)
{
docDEPTID.SelectedIndex = 1;
}
if (lstDEPTID.Items.Count > 0)
{
lstDEPTID.SelectedIndex = 1;
}
string FlagSql = @"SELECT '' CODE ,'--请选择--' NAME FROM dual";
if (Request.QueryString["oper"] != null && Request.QueryString["oper"].ToString() != "audit")
{
FlagSql += @" union all
SELECT 'M' CODE ,'新单' NAME FROM dual";
}
FlagSql += @" union all
SELECT 'N' CODE ,'已提交' NAME FROM dual
union all
SELECT 'Y' CODE ,'已审核' NAME FROM dual
union all
SELECT 'R' CODE ,'已驳回' NAME FROM dual";
PubFunc.DdlDataSql(docFLAG, FlagSql);
PubFunc.DdlDataSql(lstFLAG, FlagSql);
PubFunc.DdlDataGet(ddlReject, "DDL_BILL_REASON");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//PubFunc.DdlDataGet(ddlDEPTINT, "DDL_SYS_DEPTNULL");
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTINT);
dpkout1.SelectedDate = DateTime.Now.AddDays(-7);
dpkout2.SelectedDate = DateTime.Now;
}
}
private void DataInit()
{
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-1);
lstLRRQ2.SelectedDate = DateTime.Now;
PubFunc.DdlDataGet("DDL_USER", docSHR, docLRY, docSLR);
DepartmentBind.BindDDL("DDL_SYS_DEPOTRANGE", UserAction.UserID, docDEPTOUT, ddlDEPTOUT, docDEPTID, lstDEPTID);
PubFunc.DdlDataGet("DDL_BILL_STATUSDBD", docFLAG, lstFLAG);
docDEPTOUT.Items.RemoveAt(0);
docDEPTID.Items.RemoveAt(0);
}
private void BindDDL()
{
dpkDATE1.SelectedDate = DateTime.Now.AddDays(-7);
dpkDATE2.SelectedDate = DateTime.Now;
DatePicker1.SelectedDate = DateTime.Now.AddDays(-7);
DatePicker2.SelectedDate = DateTime.Now;
DepartmentBind.BindDDL("DDL_SYS_DEPARTMENTRANGE", UserAction.UserID, ddlDEPTID);
DepartmentBind.BindDDL("DDL_SYS_DEPARTMENTRANGE", UserAction.UserID, ddlDEPTID2);
USERID.Text = UserAction.UserID;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dpkout1.SelectedDate = DateTime.Now.AddDays(-1);
dpkout2.SelectedDate = DateTime.Now;
DepartmentBind.BindDDL("DDL_SYS_DEPTHASATH", UserAction.UserID, lstDEPTID);
lstDEPTID.SelectedIndex = 1;
}
}
private void DataInit()
{
//使用部门下拉表
//PubFunc.DdlDataGet("DDL_SYS_DEPTDEF", lstDEPTID);
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID);
CZR.Text = UserAction.UserName;
CZR.Enabled = false;
CZSJ.SelectedDate = DateTime.Now;
CZSJ.Enabled = false;
}
private void DataInit()
{
lstLRRQ1.SelectedDate = DateTime.Now.AddMonths(-1);
lstLRRQ2.SelectedDate = DateTime.Now;
PubFunc.DdlDataGet(ddlReject, "DDL_BILL_REASON");
PubFunc.DdlDataGet("DDL_STATUERP", ddlFLAG);
PubFunc.DdlDataGet("DDL_USER", ddlSPR, ddlLRY);
//PubFunc.DdlDataGet("DDL_SYS_DEPT", lstDEPTOUT, ddlDEPTID);
DepartmentBind.BindDDL("DDL_SYS_DEPTHASATH", UserAction.UserID, lstDEPTOUT, ddlDEPTID);
PubFunc.FormLock(FormDoc, true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dpkout1.SelectedDate = DateTime.Now.AddDays(-1);
dpkout2.SelectedDate = DateTime.Now;
DepartmentBind.BindDDL("DDL_SYS_DEPTALLRANGE", UserAction.UserID, lstDEPTID);
ERPUtility.CacheClear("SYS_DEPT");
hfdCurrent.Text = UserAction.UserID;
}
}
private void DataInit()
{
PubFunc.DdlDataGet("DDL_USER", ddlLRY, ddlSPR);
//PubFunc.DdlDataGet("DDL_SYS_DEPT", ddlDEPTID);
DepartmentBind.BindDDL("DDL_SYS_DEPTHASATH", UserAction.UserID, lstDEPTOUT, ddlDEPTID);
PubFunc.DdlDataGet("DDL_BILL_STATUS", ddlFLAG);
PubFunc.DdlDataGet("DDL_DAT_SYTYPE", ddlSYTYPE);
lstLRRQ1.SelectedDate = DateTime.Now;
lstLRRQ2.SelectedDate = DateTime.Now;
dpkLRRQ.SelectedDate = DateTime.Now;
ddlLRY.SelectedValue = UserAction.UserID;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lstStr1.SelectedDate = null;
dptStartDate.SelectedDate = DateTime.Now.AddDays(-7);
dpttEndDate.SelectedDate = DateTime.Now;
DepartmentBind.BindDDL("DDL_SYS_DEPOTRANGE", UserAction.UserID, ddlDEPTOUT);
PubFunc.DdlDataGet("DDL_DOC_SUPPLIER", ddlSUPID);
}
}
protected override void BindDDL()
{
PubFunc.DdlDataGet("DDL_DOC_SUPPLIER", lstPSSID, docPSSID);
PubFunc.DdlDataGet("DDL_USER", lstLRY, docCGY, docSHR, docLRY);
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, docDEPTID, lstDEPTID);
PubFunc.DdlDataGet("DDL_BILL_STATUSDHD", lstFLAG, docFLAG);
PubFunc.DdlDataGet(ddlReject, "DDL_BILL_REASON");
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-1);
lstLRRQ2.SelectedDate = DateTime.Now;
docDHRQ.SelectedDate = DateTime.Now;
}
private void DataInit()
{
lstLRRQ1.SelectedDate = DateTime.Now;
lstLRRQ2.SelectedDate = DateTime.Now;
PubFunc.DdlDataGet(docLRY, "DDL_USER");
PubFunc.DdlDataGet(ddlSPR, "DDL_USER");
PubFunc.DdlDataGet(ddlSHR, "DDL_USER");
//PubFunc.DdlDataGet("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTID, lstDEPTID);
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTID, lstDEPTID);
PubFunc.DdlDataGet(ddlFLAG, "DDL_ADDGOODSNEW");
PubFunc.DdlDataGet(lstFLAG, "DDL_ADDGOODSNEW");
}
private void BindDDL()
{
dpkDATE1.SelectedDate = DateTime.Now.AddMonths(-1);
dpkDATE2.SelectedDate = DateTime.Now;
DepartmentBind.BindDDL("DDL_SYS_DEPOTRANGE", UserAction.UserID, ddlDEPTID);
//PubFunc.DdlDataGet("DDL_DOC_SUPID", ddlSUPID);
PubFunc.DdlDataGet("DDL_DOC_SUPPLIER", ddlSUPID);
//计算合计数量
JObject summary = new JObject();
summary.Add("GDNAME", "本页合计");
GridGoods.SummaryData = summary;
}
private void DataInit()
{
DepartmentBind.BindDDL("DDL_SYS_DEPOTRANGE", UserAction.UserID, ddlDEPTOUT);
//DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTID);
DataTable dtDept = DbHelperOra.Query("SELECT DISTINCT DEPTID,DEPTNAME FROM (" + GetSearchSql() + ") ORDER BY DEPTNAME").Tables[0];
ddlDEPTID.DataTextField = "DEPTNAME";
ddlDEPTID.DataValueField = "DEPTID";
ddlDEPTID.DataSource = dtDept;
ddlDEPTID.DataBind();
ddlDEPTID.Items.Insert(0, new FineUIPro.ListItem()
{
Text = "---请选择---", Value = ""
});
}
private void DataInit()
{
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-1);
lstLRRQ2.SelectedDate = DateTime.Now;
PubFunc.DdlDataGet("DDL_USER", docSHR, docLRY, docCGY);
PubFunc.DdlDataGet(ddlReject, "DDL_BILL_REASON");
PubFunc.DdlDataGet("DDL_DOC_SHS", lstPSSID, docPSSID);
DepartmentBind.BindDDL("DDL_SYS_DEPOTRANGE", UserAction.UserID, docDEPTID, lstDEPTID);
PubFunc.DdlDataGet("DDL_USER", lstCGY, docLRY, docSHR, docCGY);
//PubFunc.DdlDataGet("DDL_SYS_DEPOT", lstDEPTID, docDEPTID);
PubFunc.DdlDataGet(ddlReject, "DDL_BILL_REASON");
PubFunc.DdlDataGet("DDL_BILL_FLAG_MNYR", docFLAG, lstFLAG);
PubFunc.DdlDataGet(docTHTYPE, "DDL_RETURNREASON");
//docDEPTOUT.Items.RemoveAt(0);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PubFunc.DdlDataGet("DDL_USER", docPJR);
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, docDEPTID);
if (Request.QueryString["billno"] != null)
{
load(Request.QueryString["billno"].ToString());
}
else
{
load();
}
}
}
private void BindDDL()
{
RQXZ.Text = DateTime.Today.ToString("yyyy-MM");
RQXZ2.Text = DateTime.Today.ToString("yyyy-MM");
DepartmentBind.BindDDL("DDL_SYS_DEPOTRANGE", UserAction.UserID, ddlDEPTID);
CleanItemForDDL("--请选择--", ddlDEPTID);
ddlDEPTID.SelectedIndex = 0;
DepartmentBind.BindDDL("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTID2);
CleanItemForDDL("--请选择--", ddlDEPTID2);
ddlDEPTID2.SelectedIndex = 0;
string strSql = @"select * from
(SELECT '' CODE,'--请选择--' NAME,0 TreeLevel,0 islast FROM dual
union all
select code,
'【' || code || '】' || name name,
class TreeLevel,
decode(islast, 'Y', 1, 0) islast
from sys_category
ORDER BY code)
ORDER BY DECODE(CODE,'',99,0) DESC ,CODE ASC ";
List <CategoryTreeBean> myList = new List <CategoryTreeBean>();
DataTable categoryTreeTable = DbHelperOra.Query(strSql).Tables[0];
foreach (DataRow dr in categoryTreeTable.Rows)
{
myList.Add(new CategoryTreeBean(dr["code"].ToString(), dr["name"].ToString(), Convert.ToInt16(dr["TreeLevel"]), Convert.ToInt16(dr["islast"]) == 1));
}
ddlCATID.EnableSimulateTree = true;
ddlCATID.DataTextField = "Name";
ddlCATID.DataValueField = "Id";
ddlCATID.DataSimulateTreeLevelField = "Level";
ddlCATID.DataSource = myList;
ddlCATID.DataBind();
ddlCATID2.EnableSimulateTree = true;
ddlCATID2.DataTextField = "Name";
ddlCATID2.DataValueField = "Id";
ddlCATID2.DataSimulateTreeLevelField = "Level";
ddlCATID2.DataSource = myList;
ddlCATID2.DataBind();
USERID.Text = UserAction.UserID;
}
