protected void btnNew_Click(object sender, EventArgs e) { PubFunc.FormDataClear(FormMain); PubFunc.FormDataClear(FormAssist); hfdIsNew.Text = "Y"; hfdConfig.Text = ""; dpkINRQ.SelectedDate = DateTime.Now; ddlFLAG.SelectedValue = "N"; tbxBZHL.Text = "1"; //ddlCATID.SelectedValue = "BG"; //ddlCATID0.SelectedValue = "5"; ddlUNIT_ORDER.SelectedValue = "X"; ddlUNIT_SELL.SelectedValue = "X"; btn_state(true); //清空部门配置信息 GridDept.DataSource = null; GridDept.DataBind(); //新增状态商品不允许配置科室 王阿磊2015年8月26日 22:29:52 if (ddlFLAG.SelectedText == "新增") { GridDept.Enabled = false; } else { GridDept.Enabled = true; } }
private void FillGrid() { StrSql = new StringBuilder(); StrSql.Length = 0; StrSql.AppendLine("Select Id,DeptName From Dept_Mast Order By DeptName"); dtTemp = new DataTable(); dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString()); GridDept.DataSource = dtTemp; GridDept.DataBind(); }
private void DataInit() { PubFunc.DdlDataGet(ddlGoodsType, "DDL_GOODS_TYPE"); DataTable dtDept = DbHelperOra.Query("select CODE,NAME from SYS_DEPT WHERE FLAG='Y' and ISDELETE='N'").Tables[0]; if (dtDept.Rows.Count > 0) { GridDept.DataSource = dtDept; GridDept.DataBind(); } }
private void search_dept() { //预算信息 String Sql = @"SELECT SA.*,NVL(SB.YSJE,0) YSJE FROM (SELECT B.CODE,B.NAME,ABS(SUM(NVL(A.HSJE,0))) SYJE FROM VIEW_JS A,SYS_DEPT B WHERE TO_CHAR(A.RQSJ,'YYYY-MM') = TO_CHAR(SYSDATE,'YYYY-MM') AND A.DEPTID(+) = B.CODE AND B.TYPE IN('3','4') GROUP BY B.CODE,B.NAME) SA, (SELECT DEPTID,SUM(SUBSUM) YSJE FROM DAT_YS_DOC WHERE FLAG = 'Y' AND SYSDATE BETWEEN BEGRQ AND ENDRQ + 1 GROUP BY DEPTID) SB WHERE SA.CODE = SB.DEPTID(+)"; DataTable Dt = DbHelperOra.Query(Sql).Tables[0]; GridDept.DataSource = Dt; GridDept.DataBind(); }
protected void GridDept_Selected(object sender, EventArgs e) { //if (TabStripMain.ActiveTabIndex != 2) return; string seq = tbxGDID.Text; if (PubFunc.StrIsEmpty(seq) || GridDept.Rows.Count > 0) { return; } //string strSql = @"SELECT B.CODE CODE,B.NAME NAME,nvl(A.FLAG,0)||'/'||nvl(Store,0) OLD, // nvl(A.FLAG,0) FLAG,nvl(Store,0) Store,nvl(A.FLAG,0)||'/'||nvl(Store,0) NEW // FROM (select deptid,TO_NUMBER(DECODE(ISCFG,'Y','1','1','1','0')) FLAG,TO_NUMBER(DECODE(SPLB,'Y','1','1','1','0')) Store FROM DOC_GOODSCFG where gdseq='{0}') A, // SYS_DEPT B // WHERE B.CODE =A.DEPTID(+) ";//B.ISLAST='Y' AND string strSql = @"SELECT A.CODE,NVL(B.ISCFG,'N') FLAG,A.NAME FROM SYS_DEPT A ,(SELECT DEPTID,ISCFG FROM DOC_GOODSCFG WHERE GDSEQ = '{0}') B WHERE A.CODE = B.DEPTID(+) ORDER BY NVL(B.ISCFG,'N') DESC"; DataTable dtCFG = DbHelperOra.Query(string.Format(strSql, seq)).Tables[0]; GridDept.DataSource = dtCFG; GridDept.DataBind(); List <int> selectRow = new List <int>(); for (int i = 0; i < dtCFG.Rows.Count; i++) { if (dtCFG.Rows[i]["FLAG"].ToString() != "N") { selectRow.Add(i); } } GridDept.SelectedRowIndexArray = selectRow.ToArray(); //新增状态商品不允许配置科室 王阿磊2015年8月26日 22:29:52 if (ddlFLAG.SelectedText == "新增") { GridDept.Enabled = false; } else { GridDept.Enabled = true; } }
protected void GridGoods_RowDoubleClick(object sender, GridRowClickEventArgs e) { TabStripMain.ActiveTabIndex = 0; string seq = GridGoods.Rows[e.RowIndex].Values[1].ToString(); DataTable dt = DbHelperOra.Query("select * from doc_goods where gdseq='" + seq.Trim() + "'").Tables[0]; PubFunc.FormDataSet(FormMain, dt.Rows[0]); PubFunc.FormDataSet(FormAssist, dt.Rows[0]); GridDept.DataSource = null; //清除商品科室配置 GridDept.DataBind(); GridDept_Selected(null, null); //双击即绑定GridDept数据,而不是在点开标签页绑定 hfdIsNew.Text = "N"; hfdConfig.Text = ""; ddlISFLAG7.Enabled = false; if (string.IsNullOrWhiteSpace(ddlISFLAG7.SelectedValue) || ddlISFLAG7.SelectedValue == "Y") { if (!string.IsNullOrWhiteSpace(ddlFLAG.SelectedValue) && ddlFLAG.SelectedValue != "N") { tbsGDNAME.Enabled = false; nbbBARCODE.Enabled = false; ddlUNIT.Enabled = false; } else { tbsGDNAME.Enabled = true; nbbBARCODE.Enabled = true; ddlUNIT.Enabled = true; } tbxGDID.Enabled = false; ddlCATID.Enabled = false; ddlUNIT_DABZ.Enabled = true; nbbBARCODE_DABZ.Enabled = true; ddlUNIT_ZHONGBZ.Enabled = true; nbbNUM_ZHONGBZ.Enabled = true; nbbBARCODE_ZHONGBZ.Enabled = true; nbbNUM_DABZ.Enabled = true; ddlCATID.Enabled = true; //新增状态商品不允许配置科室 王阿磊2015年8月26日 22:29:52 if (ddlFLAG.SelectedText == "新增") { GridDept.Enabled = false; } else { GridDept.Enabled = true; } } else { btn_state(false); nbbHSJJ.Enabled = true; ddlUNIT_DABZ.Enabled = true; nbbBARCODE_DABZ.Enabled = true; ddlUNIT_ZHONGBZ.Enabled = true; nbbNUM_ZHONGBZ.Enabled = true; nbbBARCODE_ZHONGBZ.Enabled = true; nbbNUM_DABZ.Enabled = true; ddlCATID.Enabled = true; } }