private void DataInit()
{
PubFunc.DdlDataGet(ddlDEPTID, "DDL_SYS_DEPTDEF");
PubFunc.DdlDataGet("DDL_TZLX", ddlTYPE);
dpkbegin.SelectedDate = DateTime.Now.AddDays(-1);
dpkend.SelectedDate = DateTime.Now;
}
private void DataInit()
{
//lstKSSJ.SelectedDate = DateTime.Now.AddDays(-30);
//lstJSSJ.SelectedDate = DateTime.Now;
//使用部门下拉表
PubFunc.DdlDataGet("DDL_SYS_DEPT", lstDEPTID);
PubFunc.DdlDataSql(lstDEPTID, @"select '' code, '--请选择--' name
from dual
union all
select code, name
from (select code, '[' || code || ']' || name name
from sys_dept
where type = '3'
and flag = 'Y'
order by code)
");
try
{
hfdQCRQ.Text = DbHelperOra.GetSingle("select value from SYS_PARA where code = 'YH_DSHS'").ToString();
QCQX.Text = hfdQCRQ.Text;
}
catch
{
QCQX.Text = "14";
}
}
// public string strPath = "";
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["page"] != null)
{
strPage = Request.QueryString["page"];
try
{
intPageIndex = Convert.ToInt32(strPage);
}
catch
{
intPageIndex = 1;
}
}
if (!IsPostBack)
{
Path.Text = ApiUtil.GetConfigCont("PIC_PATH");
PubFunc.DdlDataGet("DDL_SYS_DEPOT", ddlDEPTOUT);
Object obj;
if (HttpContext.Current.Request.Cookies["DEPTOUT"] == null)
{
obj = DbHelperOra.GetSingle("select nvl((SELECT A.STOCK FROM SYS_DEPT A WHERE A.CODE = '" + UserAction.UserDept + "'),(select value from sys_para where code = 'DEFDEPT')) from dual");
HttpCookie cookie = new HttpCookie("DEPTOUT");
cookie.Value = obj.ToString();
HttpContext.Current.Response.Cookies.Add(cookie);
}
else
{
obj = HttpContext.Current.Request.Cookies["DEPTOUT"].Value;
}
ddlDEPTOUT.SelectedValue = obj.ToString();
}
}
private void BindDDL()
{
PubFunc.DdlDataGet(lstAccount, "DDL_USER");
lstLRRQ1.SelectedDate = DateTime.Now;
lstLRRQ2.SelectedDate = DateTime.Now;
}
protected override void BindDDL()
{
string strpssid = @"SELECT CODE,NAME FROM(
SELECT '' CODE, '--请选择--' NAME
FROM DUAL
UNION
SELECT SUPID CODE, SUPNAME NAME
FROM DOC_SUPPLIER
WHERE ISPSS = 'Y'
UNION
SELECT DS.SUPID CODE, DS.SUPNAME NAME
FROM DOC_GOODSSUP DG, DOC_SUPPLIER DS
WHERE DG.SUPID = DS.SUPID(+)
AND DG.TYPE = 'Z'
) ORDER BY CODE DESC";
PubFunc.DdlDataGet("DDL_DOC_SUPPLIERALL", SUPNAME);
PubFunc.DdlDataSql(lstPSSID, strpssid);
PubFunc.DdlDataSql(docSUPID, strpssid);
PubFunc.DdlDataGet("DDL_SYS_DEPTDEF", lstDEPTID, docDEPTID);
PubFunc.DdlDataGet("DDL_SYS_DEPT", lstDEPTID);
PubFunc.DdlDataGet("DDL_SYS_DEPOTRANGE", UserAction.UserID, ddlDEPTOUT);
ddlDEPTOUT.SelectedIndex = 1;
btnAudit.Enabled = isOrder(ddlDEPTOUT.SelectedValue);
btnDb.Enabled = !btnAudit.Enabled;
//PubFunc.DdlDataGet("DDL_STUTEQHM", lstFLAG);
PubFunc.DdlDataGet("DDL_USER", lstLRY);
PubFunc.DdlDataGet("DDL_GOODS_TYPE", docCatid);
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-7);
lstLRRQ2.SelectedDate = DateTime.Now;
docDATE_SL1.SelectedDate = DateTime.Now.AddDays(-7);
docDATE_SL2.SelectedDate = DateTime.Now;
hfdDeptCode.Text = DbHelperOra.GetSingle("SELECT VALUE FROM SYS_PARA WHERE CODE='DEFDEPT'").ToString();
}
private void DataInit()
{
PubFunc.DdlDataGet("DDL_LICENSETYPE_S", lstLICENSETYPE);
PubFunc.DdlDataGet("DDL_DOC_SUPPLIERNULL", lstSUPID);
lstLRRQ1.SelectedDate = DateTime.Now;
lstLRRQ2.SelectedDate = DateTime.Now.AddDays(90);
}
private void BindDDL()
{
// 绑定到下拉列表
PubFunc.DdlDataGet("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTID);
lisDATE.SelectedDate = DateTime.Now;
dpkTime.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()
{
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 DataInit()
{
PubFunc.DdlDataGet("DDL_SYS_DEPOTRANGE", UserAction.UserID, lstDEPTOUT, docDEPTOUT);
lstDEPTOUT.SelectedValue = UserAction.UserDept;
docDEPTOUT.SelectedValue = UserAction.UserDept;
PubFunc.DdlDataGet("DDL_USER", lstLRY, docLRY, docSLR);
//PubFunc.DdlDataGet("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID, docDEPTID);
PubFunc.DdlDataGet("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID, docDEPTID);
//PubFunc.DdlDataGet("DDL_BILL_STATUSCKD", lstFLAG, docFLAG);
lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-7);
lstLRRQ2.SelectedDate = DateTime.Now;
//获取客户化GRF文件地址 By c 2016年1月21日12:18:29 At 威海509
string grf = Doc.DbGetGrf("KSSHTXD");
if (!string.IsNullOrWhiteSpace(grf))
{
SHTXD = grf;
}
string grf_fds = Doc.DbGetGrf("FDS_SHTXD");
if (grf_fds.Length > 0)
{
FDS_SHTXD = grf_fds;
}
//是否启用定数标签 By c 2016年1月27日12:07:12 At 威海509
string DSAUTO = Doc.DbGetSysPara("DSAUTO");
if (DSAUTO == "Y")
{
btnPBQ.Hidden = false;
}
}
private void DataInit()
{
PubFunc.DdlDataGet(ddlGoodsType, "DDL_GOODS_TYPE");
PubFunc.DdlDataGet(ddlDEPTID, "DDL_SYS_DEPTDEF");
//DepartmentBind.BindDDL("DDL_SYS_DEPTHASATH", UserAction.UserID, ddlDEPTID);
string strSql = @"
SELECT '--请选择--' NAME,'%' CODE,0 TreeLevel,1 islast FROM dual
union all
select '【'||code||'】'||name name,code,(class-1) TreeLevel,decode(islast,'Y',1,0) islast
from sys_category
ORDER BY code ";
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;
ddlCATID.DataBind();
}
private void DataInit()
{
PubFunc.DdlDataGet(ddlGoodsType, "DDL_GOODS_TYPE");
PubFunc.DdlDataGet(ddlSUPID, "DDL_DOC_SUPPLIERALL");
PubFunc.DdlDataGet(ddlPRODUCER, "DDL_PRODUCER");
string strSql = @"
SELECT '--请选择--' NAME,'%' CODE,0 TREELEVEL,1 ISLAST FROM DUAL
UNION ALL
SELECT '【'||CODE||'】'||NAME NAME,CODE,(CLASS-1) TREELEVEL,DECODE(ISLAST,'Y',1,0) ISLAST
FROM SYS_CATEGORY
ORDER BY CODE ";
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;
ddlCATID.DataBind();
}
public void DataInit()
{
PubFunc.DdlDataGet("DDL_USER", ddlUPTPER, ddlTESTPER, ddlCHECKPER);
tbxSYSNAME.Text = ConfigurationManager.AppSettings["APPNAME"];
dptUPTDATE.SelectedDate = DateTime.Now;
ddlUPTPER.SelectedValue = UserAction.UserID;
ddlCHECKPER.SelectedValue = "xiadl";
object obj = DbHelperOra.GetSingle(@"select version
from (select t.*, f_getusername(t.uptper) from sys_version t order by uptdate desc)
where rownum<2");
if (!string.IsNullOrWhiteSpace((obj ?? "").ToString()))
{
string[] s = obj.ToString().Split('.');
s[2] = (Convert.ToInt16(s[0]) + 1).ToString();
string str1 = string.Join(".", s);
tbxVERSION.Text = str1;
}
//BindWinChkToPersons();
btnSearch();
}
private void DataInit()
{
PubFunc.DdlDataGet(ddlCATID, "DDL_SYS_CATEGORYDEF");
PubFunc.DdlDataGet(ddlSUPID, "DDL_DOC_SUPPLIERNULL");
//PubFunc.DdlDataGet(ddlFLAG, "DDL_GOODS_STATUS");
TabStrip1.ActiveTabIndex = 0;
}
private void DataInit()
{
PubFunc.DdlDataGet("DDL_GOODS_TYPE", ddlCATID0, ddlCATID0, winCATID0);
PubFunc.DdlDataGet("DDL_GOODS_STATUS", srhFLAG);
//PubFunc.DdlDataGet(ddlCATID, "DDL_SYS_CATLAST");
string strSql = @"select code,'【'||code||'】'||name name,class TreeLevel,decode(islast,'Y',1,0) islast
from sys_category
ORDER BY code ";
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));
}
// 绑定到下拉列表（启用模拟树功能）
winCATID.EnableSimulateTree = true;
winCATID.DataTextField = "Name";
winCATID.DataValueField = "Id";
winCATID.DataEnableSelectField = "EnableSelect";
winCATID.DataSimulateTreeLevelField = "Level";
winCATID.DataSource = myList;
winCATID.DataBind();
winCATID0.SelectedValue = "2";
// 绑定到下拉列表（启用模拟树功能）
ddlCATID.EnableSimulateTree = true;
ddlCATID.DataTextField = "Name";
ddlCATID.DataValueField = "Id";
ddlCATID.DataEnableSelectField = "EnableSelect";
ddlCATID.DataSimulateTreeLevelField = "Level";
ddlCATID.DataSource = myList;
ddlCATID.DataBind();
ddlCATID.SelectedValue = "2";
}
private void initData()
{
PubFunc.DdlDataGet("DDL_SYS_DEPOTRANGE", UserAction.UserID, ddlDEPTID);
PubFunc.DdlDataGet("DDL_USER", docLRY, docSHR);
PubFunc.DdlDataGet("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDEPTID, lstDEPTID);
PubFunc.DdlDataGet("DDL_YS_DEPT", lstFLAG, docFLAG);
//201509191548 add by zhanghaicheng
PubFunc.DdlDataGet("DDL_SYS_DEPTRANGE", UserAction.UserID, ddlDeptYs);
// dpkRQSJ1.SelectedDate = DateTime.Now.AddDays(-30);
PubFunc.DdlDataGet(ddlReject, "DDL_BILL_REASON");
docFLAG.SelectedValue = "M"; //默认是新单状态（这个后续还要更改，先写成这样）
// dpkRQSJ2.SelectedDate = DateTime.Now;
//docSHRQ.SelectedDate = DateTime.Now;
docLRRQ.SelectedDate = DateTime.Now;
docLRY.SelectedValue = UserAction.UserID;
//docSHR.SelectedValue = UserAction.UserID;
//lstBEGRQ.SelectedDate = DateTime.Now.AddMonths(-1);
//lstENDRQ.SelectedDate = DateTime.Now;
ksyf.Text = DateTime.Now.ToString("yyyy-MM");
jsyf.Text = DateTime.Now.AddMonths(1).ToString("yyyy-MM");
ddlDEPTID.SelectedValue = UserAction.UserDept;
ddlDeptYs.SelectedValue = UserAction.UserDept;
//ddlDEPTID.Enabled = false;
dpEndDate.SelectedDate = DateTime.Now.AddDays(-1);
dpEndDate.Enabled = true;
dpStartDate.SelectedDate = DateTime.Now.AddMonths(-1);
// dpStartDate.MaxDate = DateTime.Now.AddMonths(-1);
//docYSRQ.Text = Convert.ToDateTime(dpkRQSJ2.Text).Year.ToString() + "-" + Convert.ToDateTime(dpkRQSJ2.Text).AddMonths(1).Month.ToString();
// docYSRQ.Text = DateTime.Now.ToString("yyyy") + "-" + ddlMonth.SelectedValue + "-" + "01";
docYSRQ.Text = DateTime.Now.AddMonths(1).ToString("yyyy-MM");
docYSRQ.Enabled = false;
}
private void DataInit()
{
PubFunc.DdlDataGet("DDL_SYS_DEPTDEF", ddlDEPTID);
lstLRRQ1.SelectedDate = DateTime.Now.AddMonths(-1);
lstLRRQ2.SelectedDate = DateTime.Now;
dpkRQ1.SelectedDate = DateTime.Now.AddMonths(-1);
dpkRQ2.SelectedDate = DateTime.Now;
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));
}
// 绑定到下拉列表（启用模拟树功能）
docCategory.EnableSimulateTree = true;
docCategory.DataTextField = "Name";
docCategory.DataValueField = "Id";
//ddlCATID.DataEnableSelectField = "EnableSelect";
docCategory.DataSimulateTreeLevelField = "Level";
docCategory.DataSource = myList;
docCategory.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 initData()
{
PubFunc.DdlDataGet("DDL_USER", docLRY, docSHR);
PubFunc.DdlDataGet("DDL_SYS_DEPOT", UserAction.UserID, ddlDEPTID, lstDEPTID);
PubFunc.DdlDataGet("DDL_DD_STATUSDD", lstFLAG, docFLAG);
PubFunc.DdlDataGet("DDL_SYS_DEPOT", UserAction.UserID, ddlDeptYs);
PubFunc.DdlDataGet(ddlReject, "DDL_BILL_REASON");
docFLAG.SelectedValue = "M"; //默认是新单状态M（这个后续还要更改，先写成这样）
docLRRQ.SelectedDate = DateTime.Now;
docLRY.SelectedValue = UserAction.UserID;
tbxJHYF.Text = DateTime.Now.AddMonths(1).ToString("yyyy-MM");
ddlDEPTID.SelectedValue = UserAction.UserDept;
ddlDeptYs.SelectedValue = UserAction.UserDept;
//ddlDEPTID.Enabled = false;
dpEndDate.SelectedDate = DateTime.Now.AddDays(-1);
dpEndDate.Enabled = true;
dpStartDate.SelectedDate = DateTime.Now.AddMonths(-2);
docYSRQ.Text = DateTime.Now.AddMonths(1).ToString("yyyy-MM");
docYSRQ.Enabled = false;
}
private void DataInit()
{
PubFunc.DdlDataGet("DDL_SYS_ROLE", lstROLELIST);
PubFunc.DdlDataGet("DDL_FUNCTION", lstFUNCID);
lstROLELIST.Items.RemoveAt(0);
lstROLELIST.SelectedValue = "01";
hfdIsNew.Text = "Y";
}
private void BindDDL()
{
trbBEGRQ.Text = DateTime.Now.AddMonths(-6).ToString("yyyy-MM");
trbENDRQ.Text = DateTime.Now.ToString("yyyy-MM");
tbxBEGRQ.Text = DateTime.Now.AddMonths(-1).ToString("yyyy-MM");
tbxENDRQ.Text = DateTime.Now.ToString("yyyy-MM");
PubFunc.DdlDataGet("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID, ddlDEPTID);
}
private void BindDDL()
{
dpkDATE1.SelectedDate = DateTime.Now;
dpkDATE2.SelectedDate = DateTime.Now;
PubFunc.DdlDataGet(ddlDEPTID, "DDL_SYS_DEPT");
PubFunc.DdlDataGet(ddlSUPID, "DDL_DOC_SUPPLIERNULL");
}
private void BindDDL()
{
dpkDATE1.SelectedDate = DateTime.Now.AddMonths(-3);
dpkDATE2.SelectedDate = DateTime.Now;
lisDATE1.SelectedDate = DateTime.Now.AddMonths(-3);
lisDATE2.SelectedDate = DateTime.Now;
PubFunc.DdlDataGet("DDL_DOC_SUPPLIERNULL", UserAction.UserID, lstSUPTID, ddlSUPID);
}
private void BindDDL()
{
PubFunc.DdlDataGet("DDL_DOC_SUPID", docPSSID);
PubFunc.DdlDataGet("DDL_GOODSTYPE", docDHLX);
docDHLX.SelectedValue = "2";
dpkRQ1.SelectedDate = DateTime.Now;
dpkRQ2.SelectedDate = DateTime.Now;
}
private void BindDDL()
{
dpkDATE1.SelectedDate = DateTime.Now.AddMonths(-3);
dpkDATE2.SelectedDate = DateTime.Now;
lisDATE1.SelectedDate = DateTime.Now.AddMonths(-3);
lisDATE2.SelectedDate = DateTime.Now;
PubFunc.DdlDataGet("DDL_SYS_DEPTRANGE", UserAction.UserID, lstDEPTID, ddlDEPTID);
}
private void BindDDL()
{
lstLRRQ2.SelectedDate = DateTime.Now;
lstLRRQ1.SelectedDate = DateTime.Now.AddMonths(-3);
PubFunc.DdlDataGet("DDL_SYS_DEPOTRANGE", UserAction.UserID, ddlDEPTID);
ddlDEPTID.SelectedIndex = 1;
PubFunc.DdlDataGet("DDL_GOODS_TYPE", ddlCATID);
}
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;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PubFunc.DdlDataGet("DDL_USER", ddlCJR, ddlXGR);
dpkCJRQ.SelectedDate = DateTime.Now;
}
}
private void BindDDL()
{
PubFunc.DdlDataGet(ddlDEPTID, "DDL_SYS_DEPTDEF");
lstLRRQ1.SelectedDate = DateTime.Now;
lstLRRQ2.SelectedDate = DateTime.Now;
dpkBegRQ.SelectedDate = DateTime.Now;
dpkEndRQ.SelectedDate = DateTime.Now;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PubFunc.DdlDataGet("DDL_GOODSTYPE", ddlCATID0);
ddlCATID0.SelectedValue = "2";
}
}