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());
}
