Example #1
0
        private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (beidDate.EditValue == null)
            {
                beidDate.EditValue = DateTime.Now.Date;
            }
            var      cdDate = beidDate.EditValue.ToString();
            DateTime dDate;

            if (!DateTime.TryParse(cdDate, out dDate))
            {
                dDate = DateTime.Now.Date;
            }
            //通过WebService获取报单系统数据
            var js = new CompareService.EasAndWmsCompareReport();

            var easData = js.GetMoveMaterialReq(dDate);

            var wf    = new WmsFunction(BaseStructure.WmsCon);
            var cGuid = Guid.NewGuid();

            //写临时表
            for (var i = 0; i < easData.Rows.Count; i++)
            {
                var cmdInsertTemp = new SqlCommand("insert into Tmp_Compare(cInvCode,cInvName,iQuantity,cUnit,cGuid,cOrderNumber) " +
                                                   "Values(@cInvCode,@cInvName,@iQuantity,@cUnit,@cGuid,@cOrderNumber)");
                cmdInsertTemp.Parameters.AddWithValue("@cInvCode", easData.Rows[i]["cInvCode"].ToString());
                cmdInsertTemp.Parameters.AddWithValue("@cInvName", easData.Rows[i]["cInvName"].ToString());
                cmdInsertTemp.Parameters.AddWithValue("@iQuantity", easData.Rows[i]["iSumQuantity"].ToString());
                cmdInsertTemp.Parameters.AddWithValue("@cUnit", easData.Rows[i]["cUnit"].ToString());
                cmdInsertTemp.Parameters.AddWithValue("@cGuid", cGuid);
                cmdInsertTemp.Parameters.AddWithValue("@cOrderNumber", easData.Rows[i]["cOrderNumber"].ToString());
                wf.ExecSqlCmd(cmdInsertTemp);
            }

            var cmd = new SqlCommand("CompareProduceDetail")
            {
                CommandType = CommandType.StoredProcedure
            };

            cmd.Parameters.AddWithValue("@dDate", dDate);
            cmd.Parameters.AddWithValue("@cGuid", cGuid);

            uGridProBoxBarCode.DataSource = wf.GetSqlTable(cmd);

            var cmdDelete = new SqlCommand("Delete from Tmp_Compare where cGuid=@cGuid");

            cmdDelete.Parameters.AddWithValue("@cGuid", cGuid);
            wf.ExecSqlCmd(cmdDelete);

            tsgfMain.GetGridStyle(tsgfMain.FormId);
        }
        private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (beidDate.EditValue == null)
            {
                beidDate.EditValue = DateTime.Now.Date;
            }
            if (beiEndDate.EditValue == null)
            {
                beiEndDate.EditValue = DateTime.Now.Date;
            }
            var      cdDate      = beidDate.EditValue.ToString();
            var      cdEndDate   = beiEndDate.EditValue.ToString();
            var      orderPrefix = txtOrderPrefix.EditValue.ToString();
            DateTime dDate;
            DateTime dEndDate;

            if (!DateTime.TryParse(cdDate, out dDate))
            {
                dDate = DateTime.Now.Date.AddDays(-10);
            }
            if (!DateTime.TryParse(cdEndDate, out dEndDate))
            {
                dEndDate = DateTime.Now.Date.AddDays(10);
            }
            //通过WebService获取报单系统数据
            var js = new CompareService.EasAndWmsCompareReport();

            //var easData = js.GetSaleOrder(dDate, dEndDate);
            var easData = js.GetSaleOrder(dDate, dEndDate, orderPrefix);

            var wf    = new WmsFunction(BaseStructure.WmsCon);
            var cGuid = Guid.NewGuid();

            //写临时表
            for (var i = 0; i < easData.Rows.Count; i++)
            {
                var cmdInsertTemp = new SqlCommand("insert into Tmp_Compare(cOrderNumber,cGuid) " +
                                                   "Values(@cOrderNumber,@cGuid)");
                cmdInsertTemp.Parameters.AddWithValue("@cOrderNumber", easData.Rows[i]["cOrderNumber"].ToString());
                cmdInsertTemp.Parameters.AddWithValue("@cGuid", cGuid);
                wf.ExecSqlCmd(cmdInsertTemp);
            }

            var cmd = new SqlCommand("CompareSaleDeliveryOrder")
            {
                CommandType = CommandType.StoredProcedure
            };

            cmd.Parameters.AddWithValue("@dDate", dDate);
            cmd.Parameters.AddWithValue("@dEndDate", dEndDate);
            cmd.Parameters.AddWithValue("@cGuid", cGuid);
            cmd.Parameters.AddWithValue("@cOrderPrefix", orderPrefix);
            cmd.Parameters.AddWithValue("@isDifference", chkDifference.Checked ? 1 : 0);

            uGridProBoxBarCode.DataSource = wf.GetSqlTable(cmd);

            //var cmdDelete = new SqlCommand("Delete from Tmp_Compare where cGuid=@cGuid");
            //cmdDelete.Parameters.AddWithValue("@cGuid", cGuid);
            //wf.ExecSqlCmd(cmdDelete);
            tsgfMain.GetGridStyle(tsgfMain.FormId);
        }