protected void Grid2_RowClick(object sender, FineUIPro.GridRowClickEventArgs e) { int classID = GetSelectedDataKeyID(Grid2); Session["EquipmentInfoType"] = classID; BindGrid(); }
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 + "','到货情况分析')"); }
protected void GridSupplier_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e) { string strCode = GridSupplier.DataKeys[e.RowIndex][0].ToString(); hfdsavecount.Text = strCode; cxsj(strCode); }
protected void Grid1_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e) { string strBillno = Grid1.Rows[e.RowIndex].Values[1].ToString(); billOpen(strBillno); WindowGoodsDD.Hidden = false; }
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; }
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; } }
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]); }
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 = ""; }
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; } }
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(','); } }
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]); }
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(); }
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(); }
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]); } }
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; } }
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(); }
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]); }
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 + "');"); }
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 = ""; } }
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; } }
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 + "已存在!"); } }
protected override void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e) { //dpkPDRQ.Enabled = false; tbxBILLNO.Enabled = false; billOpen(GridList.Rows[e.RowIndex].Values[1].ToString()); }
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]; }
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()); }
protected override void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e) { //ymh系统偶尔报错未找到原因,暂时拦截操作 billOpen(GridList.DataKeys[e.RowIndex][0].ToString()); }
protected void GridList_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e) { billOpen(GridList.Rows[e.RowIndex].DataKeys[0].ToString()); }
protected void GridSupKC_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e) { }
protected void Grid1_RowClick(object sender, FineUIPro.GridRowClickEventArgs e) { BindGrid2(); }
protected override void listRow_DoubleClick(object sender, FineUIPro.GridRowClickEventArgs e) { billOpen(GridList.Rows[e.RowIndex].Values[1].ToString()); }
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()); }