コード例 #1
0
        protected void Grid2_RowClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            int classID = GetSelectedDataKeyID(Grid2);

            Session["EquipmentInfoType"] = classID;
            BindGrid();
        }
コード例 #2
0
        protected void GridOrderArrival_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string ddbh = GridOrderArrival.Rows[e.RowIndex].DataKeys[0].ToString();
            string url  = "ERPQuery/GoodsDhfx.aspx?fid=7214&dd=" + ddbh;

            PageContext.RegisterStartupScript("openTODOLINK('7214','" + url + "','到货情况分析')");
        }
コード例 #3
0
        protected void GridSupplier_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string strCode = GridSupplier.DataKeys[e.RowIndex][0].ToString();

            hfdsavecount.Text = strCode;
            cxsj(strCode);
        }
コード例 #4
0
ファイル: GoodsDhfx.aspx.cs プロジェクト: cjllove/ERP
        protected void Grid1_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string strBillno = Grid1.Rows[e.RowIndex].Values[1].ToString();

            billOpen(strBillno);
            WindowGoodsDD.Hidden = false;
        }
コード例 #5
0
ファイル: DosageForm.aspx.cs プロジェクト: cjllove/ERP
 protected void GridDosage_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
     hfdIsNew.Text   = "N";
     tbxCode.Enabled = false;
     tbxCode.Text    = PubFunc.GridDataGet(GridDosage, e.RowIndex)["Code"].ToString();
     tbxName.Text    = PubFunc.GridDataGet(GridDosage, e.RowIndex)["Name"].ToString();
     ckbFlag.Checked = PubFunc.GridDataGet(GridDosage, e.RowIndex)["FLAG"].ToString() == "Y" ? true : false;
 }
コード例 #6
0
ファイル: ConstantRtn.aspx.cs プロジェクト: cjllove/ERP
 protected override void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
     billOpen(GridList.Rows[e.RowIndex].Values[1].ToString());
     PubFunc.FormLock(FormDoc, true, "");
     if (docFLAG.SelectedValue == "N")
     {
         tbxINSERT.Enabled = true;
     }
 }
コード例 #7
0
ファイル: ToDoSetup.aspx.cs プロジェクト: cjllove/ERP
        protected void GridToDoType_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            hfdIsNew.Text     = "N";
            tbxDOTYPE.Enabled = false;
            string    seq = GridToDoType.Rows[e.RowIndex].Values[0].ToString();
            DataTable dt  = DbHelperOra.Query("select * from DAT_DO_TYPE where dotype='" + seq + "'").Tables[0];

            PubFunc.FormDataSet(FormDoType, dt.Rows[0]);
        }
コード例 #8
0
ファイル: BriefManage.aspx.cs プロジェクト: cjllove/ERP
        protected void GridToBrief_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            hfdIsNew.Text = "N";
            string    strcode = GridToBrief.Rows[e.RowIndex].Values[0].ToString();
            DataTable dt      = DbHelperOra.Query("select * from DOC_BRIEF_DOC where code='" + strcode + "'").Tables[0];

            PubFunc.FormDataSet(FormBR, dt.Rows[0]);
            PubFunc.FormDataSet(FormCON, dt.Rows[0]);
            labSHOW.Text = "";
        }
コード例 #9
0
ファイル: StorageAllocation.aspx.cs プロジェクト: cjllove/ERP
        protected override void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string strBillno = GridList.Rows[e.RowIndex].Values[1].ToString();

            billOpen(strBillno);
            if (DbHelperOra.Exists("select 1 from DAT_DD_DOC where SEQNO = '" + strBillno + "' AND FLAG='N'"))
            { //双击打开单据信息时,如果单据状态在数据库中依然是新单状态,到货日期允许修改
                docMEMO.Enabled = true;
            }
        }
コード例 #10
0
        protected void GridGoodsType_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            PubFunc.FormDataSet(FormGoodsType, GridGoodsType.Rows[e.RowIndex]);

            if (!string.IsNullOrWhiteSpace(GridGoodsType.Rows[e.RowIndex].Values[3].ToString()))
            {
                string getSelectedValue = DbHelperOra.GetSingle("select str1 from DOC_GOODSTYPE t where code='" + GridGoodsType.Rows[e.RowIndex].Values[0].ToString() + "'").ToString();
                cblSTR1.SelectedValueArray = getSelectedValue.Split(',');
            }
        }
コード例 #11
0
ファイル: BriefManage.aspx.cs プロジェクト: cjllove/ERP
        protected void GridCFGBrief_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string CODE   = GridCFGBrief.DataKeys[e.RowIndex][0].ToString();
            string USERID = GridCFGBrief.DataKeys[e.RowIndex][1].ToString();

            string    strSql = string.Format("SELECT CODE,USERID,STR2 FROM DOC_BRIEF_COM WHERE CODE='{0}' AND USERID='{1}'", CODE, USERID);
            DataTable dt     = DbHelperOra.Query(strSql).Tables[0];

            PubFunc.FormDataSet(FormConfig, dt.Rows[0]);
        }
コード例 #12
0
        protected void GridIns_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            hfdRowIndex.Text = e.RowIndex.ToString();
            Int32 seq = e.RowIndex;

            PubFunc.FormDataSet(myFormShelf, ViewTable.Rows[seq]);
            ddllABC.SelectedValue     = ViewTable.Rows[seq]["ABC"].ToString();
            ddllHWZT.SelectedValue    = ViewTable.Rows[seq]["HWZT"].ToString();
            ddllKB.SelectedValue      = ViewTable.Rows[seq]["KB"].ToString();
            ddllMANAGER.SelectedValue = ViewTable.Rows[seq]["MANAGER"].ToString();
            ddllKFBH.SelectedValue    = ViewTable.Rows[seq]["KFBH"].ToString();
        }
コード例 #13
0
        protected void Grid1_OnRowClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            //Alert.Show("rowclick" + e.RowIndex.ToString() + ":::::" + Grid1.SelectedRowIndex);
            if (Grid1.SelectedRowIndex == -1)
            {
                return;
            }
            //Grid2.SelectedRowIndex = e.RowIndex;
            //string meetid = Grid1.Rows[e.RowIndex].Values[1].ToString();
            //Alert.Show(meetid);

            BindGrid2();
        }
コード例 #14
0
ファイル: CertificateCat.aspx.cs プロジェクト: cjllove/ERP
        protected void GridSupplier_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            tbxCODE.Enabled = false;
            hfdIsNew.Text   = "N";
            string strCode = GridSupplier.Rows[e.RowIndex].Values[0].ToString();
            string strSql  = string.Format("select * from doc_license where code='{0}'", strCode);

            DataTable dtProducer = DbHelperOra.Query(strSql).Tables[0];

            if (dtProducer.Rows.Count > 0)
            {
                PubFunc.FormDataSet(FormProducer, dtProducer.Rows[0]);
            }
        }
コード例 #15
0
        protected void GridCFGGoods_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string    seq = GridCFGGoods.Rows[e.RowIndex].Values[0].ToString();
            DataTable dt  = DbHelperOra.Query(string.Format("select PZ.*,SP.GDNAME,decode(nvl(pz.iscfg,'Y'),'Y','Y','1','Y','N') ISCFGID from DOC_GOODSCFG PZ,DOC_GOODS SP where PZ.GDSEQ=SP.GDSEQ AND PZ.GDSEQ='{0}' AND PZ.DEPTID ='{1}'", seq, ddlDept.SelectedValue)).Tables[0];

            PubFunc.FormDataSet(FormConfig, dt.Rows[0]);
            if (DbHelperOra.Exists("SELECT 1 FROM SYS_DEPT WHERE CODE = '" + ddlDept.SelectedValue + "' AND TYPE IN('1','2')") && cbxTB.Checked)
            {
                trbHJCODE1.Enabled = true;
            }
            else
            {
                trbHJCODE1.Enabled = false;
            }
        }
コード例 #16
0
ファイル: ProduceBom.aspx.cs プロジェクト: jjx2018/ruilin
 protected void Grid2_OnRowClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
     //Alert.Show("rowclick" + e.RowIndex.ToString() + ":::::" + Grid1.SelectedRowIndex);
     if (Grid1.SelectedRowIndex == -1)
     {
         return;
     }
     //Grid2.SelectedRowIndex = e.RowIndex;
     //string meetid = Grid1.Rows[e.RowIndex].Values[1].ToString();
     //Alert.Show(meetid);
     //btnAddDetail.Enabled = true;
     //btnDeleteSelected2.Enabled = true;
     //btnAddDetail.OnClientClick = Window1.GetShowReference("~/ruilin/OrderDetailNew.aspx?id=" + Grid1.DataKeys[Grid1.SelectedRowIndex][0].ToString() + "&od=" + Grid1.DataKeys[Grid1.SelectedRowIndex][1].ToString(), "新增产品");
     BindGrid2();
 }
コード例 #17
0
        protected void GridCFGGoods_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string seq = GridCFGGoods.DataKeys[e.RowIndex][0].ToString();
            //string supid = GridCFGGoods.Rows[e.RowIndex].Values[3].ToString();
            string supid  = ddlGhs.SelectedValue;
            String pssid  = ddlPssId.SelectedValue;
            string strSql = @"SELECT A.GDSEQ,A.GDSPEC,NVL(HISNAME,A.GDNAME) GDNAME,A.UNIT,A.PIZNO,B.STR3,B.ORDERZQ,B.TYPE,f_getproducername(A.PRODUCER) PRODUCERNAME,f_getunitname(a.unit) UNITNAME FROM DOC_GOODS A,DOC_GOODSSUP B WHERE A.GDSEQ = '" + seq + "' AND A.GDSEQ = B.GDSEQ AND B.SUPID='" + supid + "'";

            if (ddlMODE.SelectedValue != "Z")
            {
                strSql += string.Format("  AND B.PSSID='" + pssid + "'");
            }
            DataTable dt = DbHelperOra.Query(strSql).Tables[0];

            PubFunc.FormDataSet(FormConfig, dt.Rows[0]);
        }
コード例 #18
0
ファイル: OrderCompareSpd.aspx.cs プロジェクト: cjllove/ERP
        protected void GridList_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string strBillNo = GridList.Rows[e.RowIndex].Values[1].ToString();

            ToolbarBillno.Text = strBillNo;
            string    strSql        = @"SELECT NULL MEMO,A.SEQNO,B.ROWNO,A.GDSEQ,A.GDNAME,B.GDSEQ GDSEQ_EAS,F_GETUNITNAME(A.UNIT) UNIT,B.UNIT UNIT_EAS,A.GDSPEC,B.GDSPEC GDSPEC_EAS,A.DHS,B.DHS DHS_EAS
                              FROM DAT_DD_COM A LEFT JOIN DAT_DD_COM_COMPARE B ON A.SEQNO=B.SEQNO AND A.GDSEQ=B.GDSEQ 
                              WHERE A.SEQNO='" + strBillNo + "'";
            DataTable dt            = DbHelperOra.Query(strSql).Tables[0];
            string    GreenRowsList = "";
            string    RedRowsList   = "";

            foreach (DataRow dr in dt.Rows)
            {
                string strGDSEQ     = dr["GDSEQ"].ToString();
                string strGDSEQ_EAS = "";
                if (dr["GDSEQ_EAS"] != null && !"".Equals(dr["GDSEQ_EAS"].ToString()))
                {
                    strGDSEQ_EAS = dr["GDSEQ_EAS"].ToString();
                }
                else
                {
                    dr["MEMO"] = "ERP有EAS没有";
                    continue;//如果GDSEQ_EAS是null,表明表体中少商品,用默认白色标注
                }
                string  strUNIT       = dr["UNIT"].ToString();
                string  strUNIT_EAS   = dr["UNIT_EAS"].ToString();
                string  strGDSPEC     = dr["GDSPEC"].ToString();
                string  strGDSPEC_EAS = dr["GDSPEC_EAS"].ToString();
                Decimal DHS           = Convert.ToDecimal(dr["DHS"]);
                Decimal DHS_EAS       = Convert.ToDecimal(dr["DHS_EAS"]);

                if (strGDSEQ.Equals(strGDSEQ_EAS) && DHS == DHS_EAS)
                {
                    dr["MEMO"]     = "完全匹配";
                    GreenRowsList += dt.Rows.IndexOf(dr).ToString() + ",";
                }
                else
                {
                    dr["MEMO"]   = "字段不匹配";
                    RedRowsList += dt.Rows.IndexOf(dr).ToString() + ",";
                }
            }
            GridDetail.DataSource = dt;
            GridDetail.DataBind();
            PageContext.RegisterStartupScript("onGridDataLoad('" + RedRowsList + "','" + GreenRowsList + "','" + GridDetail.ClientID + "');");
        }
コード例 #19
0
        protected void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            GridPerson.DataSource = null;
            GridPerson.DataBind();

            hfdIsNew.Text = "N";
            string    seqno  = GridList.Rows[e.RowIndex].DataKeys[0].ToString();
            string    strSql = string.Format("select * from SYS_MyMemo where seqno='{0}'", seqno);
            DataTable dt     = DbHelperOra.Query(strSql).Tables[0];

            if (dt.Rows.Count > 0)
            {
                hfdSeqno.Text              = dt.Rows[0]["SEQNO"].ToString();
                tbxTITLE.Text              = dt.Rows[0]["TITLE"].ToString();
                dptWARINGRQ.SelectedDate   = Convert.ToDateTime(dt.Rows[0]["WARINGRQ"]);
                rblISPRIVATE.SelectedValue = dt.Rows[0]["ISPRIVATE"].ToString();
                hfdLOOKPER.Text            = dt.Rows[0]["LOOKPER"].ToString();
                taxMEMO.Text = dt.Rows[0]["MEMO"].ToString();
                if (dt.Rows[0]["ISPRIVATE"].ToString() != "N")
                {
                    string strSQL = @"SELECT O.USERID,O.USERNAME,MU.FLAG,MU.LRRQ,CASE
                                                     WHEN MU.FLAG = 'N' THEN
                                                      '新备忘'
                                                     WHEN MU.FLAG = 'C' THEN
                                                      '已查看'
                                                     ELSE
                                                      '已提醒'
                                                   END AS FLAGNAME,MU.LOOKRQ FROM SYS_MYMEMO_USER MU,SYS_OPERUSER O 
                                              WHERE MU.LOOKPER=O.USERID AND MU.SEQNO='{0}'";
                    GridPerson.DataSource = DbHelperOra.Query(string.Format(strSQL, hfdSeqno.Text)).Tables[0];
                    GridPerson.DataBind();
                    btnDistribution.Enabled = true;
                }
                else
                {
                    btnDistribution.Enabled = false;
                }
            }
            else
            {
                hfdSeqno.Text = "";
            }
        }
コード例 #20
0
ファイル: PicturesBrowse.aspx.cs プロジェクト: cjllove/ERP
        protected void GridGoods_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            billOpen(GridGoods.Rows[e.RowIndex].Values[1].ToString());
            labelpic.Text = GridGoods.Rows[e.RowIndex].Values[1].ToString();//双击单元格返回gdseq
            DataTable dtpic = DbHelperOra.Query(string.Format("select * from doc_goodspicture where gdseq='{0}'", GridGoods.Rows[e.RowIndex].Values[1].ToString())).Tables[0];

            if (dtpic.Rows.Count > 0)
            {
                hfdPic3.Text = dtpic.Rows.Count.ToString();
            }
            if (labelpic1.Text.Length > 0)
            {
                labelpic1.Text = "";
            }
            if (mynow > 1)
            {
                mynow = 1;
            }
        }
コード例 #21
0
ファイル: InventoryPlan.aspx.cs プロジェクト: cjllove/ERP
        protected void GridGoods_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string err = "";
            //GridLot.DataKeys[rowIndex][0];
            DataTable dtDoc = DbHelperOra.Query(string.Format("SELECT CODE,NAME,'N' FLAG,'新单' FLAGNAME,f_getusername(MANAGER) PERSON,'0' SYSL,'0' SYHSJE,'0' SYBHSJE,'' KSWC,'' MEMO FROM SYS_DEPT WHERE CODE ='{0}'", GridLot.DataKeys[e.RowIndex][0])).Tables[0];

            foreach (DataRow row in dtDoc.Rows)
            {
                if (dept_exis(row))
                {
                    err = "[" + row["CODE"].ToString() + "]";
                    continue;
                }
                PubFunc.GridRowAdd(GridGoods, row, false);
            }
            WindowLot.Hidden = true;
            if (err.Length > 0)
            {
                Alert.Show("您选择的部门编码" + err + "已存在!");
            }
        }
コード例 #22
0
 protected override void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
     //dpkPDRQ.Enabled = false;
     tbxBILLNO.Enabled = false;
     billOpen(GridList.Rows[e.RowIndex].Values[1].ToString());
 }
コード例 #23
0
 protected void GridToBrief_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
     string    strcode = GridToBrief.Rows[e.RowIndex].Values[0].ToString();
     DataTable dt      = DbHelperOra.Query("select * from DOC_BRIEF_DOC where code='" + strcode + "'").Tables[0];
 }
コード例 #24
0
        protected void GridGoods_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            string GoodsInfo = GetRowValue(GridGoods.Rows[e.RowIndex]);

            FineUIPro.PageContext.RegisterStartupScript(FineUIPro.ActiveWindow.GetWriteBackValueReference(GoodsInfo) + FineUIPro.ActiveWindow.GetHidePostBackReference());
        }
コード例 #25
0
        protected override void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
        {
            //ymh系统偶尔报错未找到原因,暂时拦截操作

            billOpen(GridList.DataKeys[e.RowIndex][0].ToString());
        }
コード例 #26
0
ファイル: CertificateManage.aspx.cs プロジェクト: cjllove/ERP
 protected void GridList_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
     billOpen(GridList.Rows[e.RowIndex].DataKeys[0].ToString());
 }
コード例 #27
0
ファイル: SupplierCheckList.aspx.cs プロジェクト: cjllove/ERP
 protected void GridSupKC_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
 }
コード例 #28
0
 protected void Grid1_RowClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
     BindGrid2();
 }
コード例 #29
0
ファイル: PriceAdjustment.aspx.cs プロジェクト: cjllove/ERP
 protected override void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
     billOpen(GridList.Rows[e.RowIndex].Values[1].ToString());
 }
コード例 #30
0
 protected override void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
 {
     billOpen(GridList.DataKeys[e.RowIndex][0].ToString(), GridList.DataKeys[e.RowIndex][1].ToString(), GridList.DataKeys[e.RowIndex][2].ToString(), GridList.DataKeys[e.RowIndex][3].ToString());
 }