void BindGrid()
    {
        List <RzViewContent> rz1    = RZSource.Init.GetRzSourceByType("产品认证", "");
        List <RzViewContent> rz1_tp = new List <RzViewContent>();

        for (int i = 0; (i < 10 && i < rz1.Count); i++)
        {
            rz1_tp.Add(rz1[i]);
        }
        GridList1.DataSource = rz1_tp;
        GridList1.DataBind();
        List <RzViewContent> rz2    = RZSource.Init.GetRzSourceByType("体系认证", "");
        List <RzViewContent> rz2_tp = new List <RzViewContent>();

        for (int i = 0; (i < 10 && i < rz2.Count); i++)
        {
            rz2_tp.Add(rz2[i]);
        }
        GridList2.DataSource = rz2_tp;
        GridList2.DataBind();
    }
예제 #2
0
        protected void btnSearch2_Click(object sender, EventArgs e)
        {
            if (lstLRRQ11.SelectedDate == null || lstLRRQ22.SelectedDate == null)
            {
                Alert.Show("请输入条件【录入日期】!");
                return;
            }
            else if (lstLRRQ11.SelectedDate > lstLRRQ22.SelectedDate)
            {
                Alert.Show("开始日期大于结束日期,请重新输入!");
                return;
            }

            DateTime lrrq1Value = (DateTime)lstLRRQ11.SelectedDate;
            DateTime lrrq2Value = (DateTime)lstLRRQ22.SelectedDate;

            string custId = DbHelperOra.GetSingle("select value from sys_para where code='USERCODE'").ToString();
            string dno    = txtBillNo2.Text.Trim();

            string strBeginDate = lrrq1Value.ToString("yyyy-MM-dd");
            string strEndDate   = lrrq2Value.ToString("yyyy-MM-dd");

            String[] paramArray = { strBeginDate, strEndDate, dno, custId };

            //查询eas上调拨入库单
            string result = ApiClientService.QueryEASBill("DRK", paramArray);

            if (String.IsNullOrWhiteSpace(result) || "-1".Equals(result))
            {
                Alert.Show("与数据中心通讯失败,请稍后再试!", "消息提示", MessageBoxIcon.Warning);
                return;
            }

            string strBillNos = "";
            JArray jaResult   = JArray.Parse(result);//多单据数组

            foreach (JToken jt in jaResult)
            {
                JObject jResult = (JObject)jt;//单单据对象
                if ("success".Equals(jResult.Value <String>("result")))
                {
                    JArray ja = jResult.Value <JArray>("data");
                    if (ja.Count > 0)
                    {
                        strBillNos = strBillNos +   "'" + saveRKDocCom(ja) + "',";//把下传的单据保存到用于比较的临时表DAT_RK_DOC_COMPARE,DAT_RK_COM_COMPARE
                    }
                }
            }
            if (!String.IsNullOrWhiteSpace(strBillNos))
            {
                strBillNos = strBillNos.TrimEnd(',');
                string strSql = @"SELECT SEQNO,DDBH,NULL DHRQ,DHRQ DHRQ_EAS,NULL SUBNUM,SUBNUM SUBNUM_EAS,NULL SUBSUM,SUBSUM SUBSUM_EAS,(select VALUE from sys_para where code='USERCODE') CUSTID
                                from DAT_RK_DOC_COMPARE  where BILLNO IN (" + strBillNos + ") order by seqno";
                GridList2.DataSource = DbHelperOra.Query(strSql).Tables[0];
            }
            else
            {
                Alert.Show("没有查询到订单!", "消息提示", MessageBoxIcon.Warning);
                return;
            }

            GridList2.DataBind();
            GridDetail2.DataSource = null;
            GridDetail2.DataBind();
        }
예제 #3
0
        protected void btnCompare2_Click(object sender, EventArgs e)
        {
            string strDDBHs = "";

            if (GridList2.Rows.Count > 0)
            {
                for (int i = 0; i < GridList2.Rows.Count; i++)
                {
                    if (i == GridList2.Rows.Count - 1)
                    {
                        strDDBHs = strDDBHs + "'" + GridList2.Rows[i].Values[1].ToString() + "'";
                    }
                    else
                    {
                        strDDBHs = strDDBHs + "'" + GridList2.Rows[i].Values[1].ToString() + "',";
                    }
                }
            }
            else
            {
                Alert.Show("没有查询到入库单,请先查询入库单!", "消息提示", MessageBoxIcon.Warning);
                return;
            }
            //取得查询条件
            DateTime lrrq1Value   = (DateTime)lstLRRQ11.SelectedDate;
            DateTime lrrq2Value   = (DateTime)lstLRRQ22.SelectedDate;
            string   strBeginDate = lrrq1Value.ToString("yyyy-MM-dd");
            string   strEndDate   = lrrq2Value.ToString("yyyy-MM-dd");
            string   dno          = txtBillNo2.Text.Trim();
            string   strWhere     = "";

            if (!String.IsNullOrWhiteSpace(dno))
            {
                strWhere = " seqno like '%" + dno + "%'";
            }
            else
            {
                strWhere = "  DHRQ>=to_date('" + strBeginDate + "','YYYY-MM-DD') and DHRQ<=to_date('" + strEndDate + "','YYYY-MM-DD')";
            }

            #region 关联DAT_RK_DOC表和DAT_RK_DOC_COMPARE表,重新绑定GridList2

//            string strSql = @"select A.*,B.LRRQ,B.SUBNUM,B.SUBSUM
//                              from (SELECT BILLNO,TO_CHAR(LRRQ,'YYYY-MM-DD') LRRQ_EAS,SUBNUM SUBNUM_EAS,SUBSUM SUBSUM_EAS,(select VALUE from sys_para where code='USERCODE') CUSTID from DAT_RK_DOC_COMPARE
//                              WHERE BILLNO in ({0})) A LEFT JOIN DAT_RK_DOC B ON A.BILLNO=B.SEQNO";

            string strSql = @"select null MEMO,c.* from
                            (select a.*,B.DHRQ DHRQ_EAS,B.SUBNUM SUBNUM_EAS from
                            (select SEQNO,DHrq,subnum from dat_rk_doc 
                            where MEMO='FROM_PLATFORM' AND {0} ) a
                            left join (select SEQNO,DHrq,subnum from dat_rk_doc_compare where {0} ) b
                            on a.seqno=b.seqno
                            union
                            select a.seqno,null DHRQ,null subnum,a.DHRQ DHRQ_EAS,A.subnum subnum_eas from
                            (select SEQNO,DHRQ,subnum from dat_rk_doc_compare 
                            where {0} ) a
                            where  not EXISTS ( select * from (select SEQNO,DHrq,subnum from dat_rk_doc where MEMO='FROM_PLATFORM' AND {0} ) b where a.seqno=b.seqno)) c
                            order by c.seqno asc";

            strSql = string.Format(strSql, strWhere);
            DataTable dt = DbHelperOra.Query(strSql).Tables[0];

            string GreenRowsList  = "";
            string RedRowsList    = "";
            string YellowRowsList = "";
            foreach (DataRow dr in dt.Rows)
            {
                string strDHRQ = "";
                if (dr["DHRQ"] != null && !"".Equals(dr["DHRQ"].ToString()))
                {
                    strDHRQ = dr["DHRQ"].ToString();
                }
                else
                {
                    //如果DHRQ是NULL或者空值,说明DAT_RK_DOC中没有该单据,标识黄色
                    YellowRowsList += dt.Rows.IndexOf(dr).ToString() + ",";
                    dr["MEMO"]      = "ERP没有EAS有";
                    continue;
                }
                string strDHRQ_EAS = "";
                if (dr["DHRQ_EAS"] != null && !"".Equals(dr["DHRQ_EAS"].ToString()))
                {
                    strDHRQ_EAS = dr["DHRQ_EAS"].ToString();
                }
                else
                {
                    //如果DHRQ_EAS是NULL或者空值,说明DAT_RK_DOC_COMPARE中没有该单据,标识白色
                    dr["MEMO"] = "ERP有EAS没有";
                    continue;
                }

                Decimal SUBNUM = 0;
                if (dr["SUBNUM"] != null && !"".Equals(dr["SUBNUM"].ToString()))
                {
                    try
                    {
                        SUBNUM = Convert.ToDecimal(dr["SUBNUM"]);
                    }
                    catch
                    { }
                }
                Decimal SUBNUM_EAS = Convert.ToDecimal(dr["SUBNUM_EAS"]);
                if (SUBNUM == SUBNUM_EAS)
                {
                    GreenRowsList += dt.Rows.IndexOf(dr).ToString() + ",";
                    dr["MEMO"]     = "完全匹配";
                }
                else
                {
                    RedRowsList += dt.Rows.IndexOf(dr).ToString() + ",";
                    dr["MEMO"]   = "条数不匹配";
                }
            }
            GridList2.DataSource = dt;
            GridList2.DataBind();
            PageContext.RegisterStartupScript("onGridDataLoad2('" + RedRowsList + "','" + GreenRowsList + "','" + YellowRowsList + "','" + GridList2.ClientID + "');");
            #endregion
        }