Esempio n. 1
0
        /// <summary>
        /// 点击按钮传递平均单价
        /// </summary>
        /// <param name="e"></param>
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            if (e.Key.ToUpperInvariant().Equals("FPASSONMEDPRICE"))
            {
                string strSql = string.Format(@"/*dialect*/SELECT MAT.FNUMBER,
         sum(spData.FAMOUNT)/sum(spData.FACTUALQTY) avgPrice
FROM T_SP_PICKMTRL sp
INNER JOIN T_SP_PICKMTRLDATA spData
    ON sp.FID = spData.FID
INNER JOIN T_BD_MATERIAL MAT
    ON spData.FMATERIALID = MAT.FMATERIALID
WHERE sp.FPRDORGID = 111934 

group by MAT.FNUMBER");
                DynamicObjectCollection result = DBUtils.ExecuteDynamicObject(this.Context, strSql);
                if (result != null && result.Count() > 0)
                {
                    string sJson = CreateJson(result);
                    if (!sJson.Equals("传递参数拼接失败"))
                    {
                        WebMesTest.MaterialMessageFromCappServiceService requestMes = new WebMesTest.MaterialMessageFromCappServiceService();
                        requestMes.WeightingAvgNumerAsync(sJson);

                        //ResManager
                        //调用MES提供的接口
                    }
                }
            }
        }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FQUERY":
                string FSDate = this.View.Model.GetValue("FSDate") == null ? "" : this.View.Model.GetValue("FSDate").ToString();
                string FEDate = this.View.Model.GetValue("FEDate") == null ? "" : this.View.Model.GetValue("FEDate").ToString();
                string FOrgId = this.View.Model.GetValue("FOrgId") == null ? "0" :
                                (this.View.Model.GetValue("FOrgId") as DynamicObject)["Id"].ToString();
                string FDeptID = this.View.Model.GetValue("FDeptID") == null ? "0" :
                                 (this.View.Model.GetValue("FDeptID") as DynamicObject)["Id"].ToString();
                string FAccountId = this.View.Model.GetValue("FAccountId") == null ? "0" :
                                    (this.View.Model.GetValue("FAccountId") as DynamicObject)["Id"].ToString();


                DynamicFormShowParameter param = new DynamicFormShowParameter();
                param.ParentPageId       = this.View.PageId;
                param.FormId             = "ora_CZ_CostAmount";
                param.OpenStyle.ShowType = ShowType.MainNewTabPage;

                param.CustomParams.Add("FSDate", FSDate);
                param.CustomParams.Add("FEDate", FEDate);
                param.CustomParams.Add("FOrgId", FOrgId);
                param.CustomParams.Add("FDeptID", FDeptID);
                param.CustomParams.Add("FAccountId", FAccountId);

                this.View.ShowForm(param);
                break;
            }
        }
Esempio n. 3
0
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            DynamicObject o = (DynamicObject)this.Model.DataObject;

            long id = Convert.ToInt64(o["Id"]);

            if (e.Key.ToUpperInvariant().Equals("F_LHR_CHECK"))
            {
                DynamicFormShowParameter showParam = new DynamicFormShowParameter();
                showParam.FormId = "LHR_CHECKDATANOTES";
                this.View.ShowForm(showParam, new Action <FormResult>((FormResult) =>
                {
                    if (FormResult != null && FormResult.ReturnData != null)
                    {
                        //获取物料所在盘点表所在index

                        long materialId = ((CheckNotesReturnInfo)FormResult.ReturnData).Materialid;
                        string strSql   = string.Format(@"/*dialect*/select b.FSEQ from T_STK_STKCOUNTINPUT a inner join T_STK_STKCOUNTINPUTENTRY b on a.FID = b.FID where a.FID = {0} and b.FMATERIALID ={1}", id, materialId);
                        int result      = DBUtils.ExecuteScalar <int>(this.Context, strSql, -1, null);
                        if (result != -1)
                        {
                            this.Model.SetValue("FCountQty", ((CheckNotesReturnInfo)FormResult.ReturnData).Qty, result - 1);
                        }
                    }
                }));
            }
        }
Esempio n. 4
0
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FUPLOAD":     //FUpload
                string FDocumentStatus = this.View.Model.GetValue("FDocumentStatus").ToString();
                if (FDocumentStatus == "Z")
                {
                    this.View.ShowWarnningMessage("请保存后再上传附件!");
                }
                else
                {
                    if (jSONObject == null)
                    {
                        this.View.ShowWarnningMessage("请先选择附件!");
                    }
                    else
                    {
                        string reault = BindForm_UploadAttach();
                        if (reault != "")
                        {
                            isUpload = true;
                            this.View.ShowMessage(reault);
                        }
                    }
                }
                break;
            }
        }
 public override void AfterButtonClick(AfterButtonClickEventArgs e)
 {
     base.AfterButtonClick(e);
     if (e.Key.EqualsIgnoreCase("F_SZXY_Ok"))
     {
         DynamicObject Mateialobj = this.Model.GetValue("F_SZXY_Mateial") as DynamicObject;
         DynamicObject Maclobj    = this.Model.GetValue("F_SZXY_Mac") as DynamicObject;
         int           Mateial    = 0;
         string        Mac        = string.Empty;
         if (Mateialobj != null && Maclobj != null)
         {
             Mateial = Convert.ToInt32(Mateialobj["Id"]);
             Mac     = Convert.ToString(Maclobj["Id"]);
         }
         ScanReturnInfo returnInfo = new ScanReturnInfo();
         returnInfo.Mateial = Mateial;
         returnInfo.Mac     = Mac;
         returnInfo.Row     = Convert.ToInt32(index);
         int m = Convert.ToInt32(index);
         this.View.ReturnToParentWindow(new FormResult(returnInfo));
         this.View.Close();
         //(this.View.ParentFormView as IDynamicFormViewService).ButtonClick("F_SZXY_Button", "");
     }
     else
     {
         //ScanReturnInfo returnInfo = new ScanReturnInfo();
         //returnInfo.Mateial = 0;
         //returnInfo.Mac = "";
         //this.View.ReturnToParentWindow(new FormResult(new FormResult(returnInfo)));
         this.View.Close();
     }
 }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToString().ToUpperInvariant();

            switch (key)
            {
            case "FNEWROW":
                AddNewEntryRow();
                break;

            case "FPUSH":
                if (CZ_GetValue("FDocumentStatus") != "C")
                {
                    this.View.ShowMessage("商机还未通过审核!");
                }
                else
                {
                    Act_Push();
                }
                break;

            case "FCOPY":
                Act_ABC_CopyNiche();
                break;
            }
        }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FPUSH":
                Act_BC_OpenPushOptions();
                break;
            }
        }
Esempio n. 8
0
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            MaterialEntity material = new MaterialEntity();

            material.UserName = "******";
            material.UseOrgId = "111934";
            string sJon = JsonConvert.SerializeObject(material);

            WebReference.MESWebService request = new WebReference.MESWebService();
            request.GetMaterialDataList(sJon);
        }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FSAVEASSCHEME":     //FSaveAsScheme -另存为方案
                Act_SaveAsScheme();
                break;
            }
        }
Esempio n. 10
0
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FGENE":     // FGene 生成
                Act_ABC_GeneLeaveForm();
                break;
            }
        }
Esempio n. 11
0
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FPUSHBTN":
                Act_ABC_PushChangeRefund();
                break;
            }
        }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FQUERYBTN":
                Act_QueryData();
                break;
            }
        }
Esempio n. 13
0
 public override void AfterButtonClick(AfterButtonClickEventArgs e)
 {
     base.AfterButtonClick(e);
     if (e.Key.ToUpperInvariant().Equals("F_LHR_CONFIRM"))
     {
         CheckNotesReturnInfo returnInfo     = new CheckNotesReturnInfo();
         DynamicObject        materialObject = this.Model.GetValue("F_LHR_MATERIAL") as DynamicObject;
         returnInfo.Qty        = Convert.ToDecimal(this.Model.GetValue("F_LHR_Qty"));
         returnInfo.Materialid = Convert.ToInt64(materialObject["Id"]);
         this.View.ReturnToParentWindow(new FormResult(returnInfo));
         this.View.Close();
     }
 }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            string buttonkey = e.Key;

            if (buttonkey == "FBTNOK")
            {
                string sql = string.Format(@"/*dialect*/UPDATE t1 SET 
t1.ftotaltime=t2.fmacworktime+t2.FHRPREPARETIME+t2.FHRWORKTIME+t2.FMACPREPARETIME,t1.fmacworktime=t2.fmacworktime,t1.FHRWORKTIME=t2.FHRWORKTIME
FROM T_CB_WORKHOURSENTRY t1 
INNER JOIN T_PRD_MORPTENTRY t2 ON t1.FSRCENTRYID=t2.FENTRYID
where t1.FSRCBILLFORMID='SFC_OperationReport'");
                DBUtils.Execute(this.Context, sql);
            }
            base.AfterButtonClick(e);
        }
Esempio n. 15
0
        /// <summary>
        /// 点击事件
        /// </summary>
        /// <param name="e"></param>
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToString().ToUpperInvariant();

            switch (key)
            {
            case "FNEWROW":     //新增行
                AddNewEntryRow();
                break;

            case "FPUSHBTN":     //下推
                PushFormByFormId();
                break;
            }
        }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FPUSHBTN":
                Act_ABC_PushMaintainContract();
                break;

            case "FNEWROW":     //新增行
                AddNewEntryRow();
                break;
            }
        }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FNEWROW":     //新增行
                AddNewEntryRow();
                break;

            case "FTRACKUP":     //上查
                Act_TrackUp();
                break;
            }
        }
        /// <summary>
        /// 返回数值
        /// </summary>
        /// <param name="e"></param>
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            if (e.Key.EqualsIgnoreCase("F_SZXY_OK"))
            {
                string value = "";
                int    m     = this.Model.GetEntryCurrentRowIndex("F_SZXY_Entity") + 1;
                if (m > 0)
                {
                    for (int i = 1; i <= m; i++)
                    {
                        string xvalue = Convert.ToString(this.Model.GetValue("F_SZXY_XCoordinate", i - 1)); //X坐标
                        string yvalue = Convert.ToString(this.Model.GetValue("F_SZXY_YCoordinate", i - 1)); //Y坐标
                        if (!xvalue.IsNullOrEmptyOrWhiteSpace() && !yvalue.IsNullOrEmptyOrWhiteSpace())
                        {
                            value += "|" + xvalue + "," + yvalue;
                        }
                    }
                }

                //此处写【确定】按钮所执行的方法
                AScanReturnInfo returnInfo = new AScanReturnInfo();

                if (!value.IsNullOrEmptyOrWhiteSpace())
                {
                    returnInfo.Value = value.Substring(1, value.Length - 1);
                }
                else
                {
                    returnInfo.Value = "";
                }
                // 把数据对象,返回给父界面
                //this.View.ReturnToParentWindow(new FormResult(returnInfo));
                this.View.ReturnToParentWindow(new FormResult(value.Substring(1, value.Length - 1)));
                this.View.Close();
            }
            else
            {
                //此处写【确定】按钮所执行的方法
                AScanReturnInfo returnInfo = new AScanReturnInfo();
                returnInfo.Value = "";
                // 把数据对象,返回给父界面
                //this.View.ReturnToParentWindow(new FormResult(returnInfo));
                this.View.ReturnToParentWindow(new FormResult(""));
                this.View.Close();
            }
        }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FPUSH":
                if (CZ_GetValue("FDocumentStatus") != "C")
                {
                    this.View.ShowMessage("报价未通过审核!");
                    return;
                }
                PushContact();
                break;
            }
        }
        /// <summary>
        /// 点击按钮传递平均单价
        /// </summary>
        /// <param name="e"></param>
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            if (e.Key.ToUpperInvariant().Equals("FPASSONMEDPRICE"))
            {
                string strSql = string.Format(@"SELECT MAT.FNUMBER,
         sum(spData.FAMOUNT)/sum(spData.FACTUALQTY) avgPrice
FROM T_SP_PICKMTRL sp
INNER JOIN T_SP_PICKMTRLDATA spData
    ON sp.FID = spData.FID
INNER JOIN T_BD_MATERIAL MAT
    ON spData.FMATERIALID = MAT.FMATERIALID
WHERE sp.FPRDORGID = 111934 
AND sp.FDATE>=convert(char,dateadd(dd,-day(getdate()),getdate()),23)
AND sp.FDATE<=convert(char,dateadd(dd,-day(dateadd(month,-1,getdate()))+1,dateadd(month,-1,getdate())),23)
group by MAT.FNUMBER");
                DBUtils.Execute(this.Context, strSql);
            }
        }
Esempio n. 21
0
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FSYNCBTN":     //FSyncBtn
                if (mBtnLock)
                {
                    this.View.ShowMessage("[数据获取中...]此操作比较耗时,请勿频繁操作!");
                    return;
                }
                this.View.ShowMessage("确定进行数据的获取吗?\n提醒:此过程可能较为耗时,需要耐心等待!", MessageBoxOptions.YesNo, (result) =>
                {
                    if (result == MessageBoxResult.Yes)
                    {
                        mBtnLock    = true;
                        string from = this.Model.GetValue("FFromDt").ToString();
                        string to   = this.Model.GetValue("FToDt").ToString();
                        if (DateTime.Parse(to).CompareTo(DateTime.Parse(from)) <= 0)
                        {
                            this.View.ShowMessage("截止时间需要大于开始时间!");
                            return;
                        }
                        string FLog = "";
                        this.Model.SetValue("FLog", FLog);
                        SignInSyncUtils req = new SignInSyncUtils(this.Context);
                        //var that = this;
                        req.InsertDataWithinDate(from, to, (msg) => {
                            FLog += msg + "\n";
                        });
                        this.Model.SetValue("FLog", FLog);
                        mBtnLock = false;
                        this.View.ShowMessage("数据获取完成");
                    }
                });

                break;
            }
        }
 public override void AfterButtonClick(AfterButtonClickEventArgs e)
 {
     base.AfterButtonClick(e);
     if (e.Key.Equals("F_ORA_DETAIL_VIEW_PUBLIC"))
     {
         if (this.View.Model.GetValue("FContractParty") == null)
         {
             this.View.ShowErrMessage("请先选择往来单位");
         }
         else
         {
             DynamicFormShowParameter param = new DynamicFormShowParameter();
             param.ParentPageId       = this.View.PageId;
             param.FormId             = "ora_trasaction_detail_public_form";
             param.OpenStyle.ShowType = ShowType.Modal;
             param.CustomParams.Add("Type", this.View.Model.GetValue("FContractPartyType").ToString());
             param.CustomParams.Add("ObjId", (this.View.Model.GetValue("FContractParty") as DynamicObject)["Id"].ToString());
             this.View.ShowForm(param);
         }
     }
     else if (e.Key.Equals("F_ORA_DETAIL_VIEW"))
     {
         if (this.View.Model.GetValue("FApply") == null)
         {
             this.View.ShowErrMessage("请先选择申请人");
         }
         else
         {
             DynamicFormShowParameter param = new DynamicFormShowParameter();
             param.ParentPageId       = this.View.PageId;
             param.FormId             = "ora_transaction_detail_form";
             param.OpenStyle.ShowType = ShowType.Modal;
             param.CustomParams.Add("Type", "emp");
             param.CustomParams.Add("ObjId", (this.View.Model.GetValue("FApply") as DynamicObject)["Id"].ToString());
             this.View.ShowForm(param);
         }
     }
 }
Esempio n. 23
0
 public override void AfterButtonClick(AfterButtonClickEventArgs e)
 {
     base.AfterButtonClick(e);
 }
        public override void AfterButtonClick(AfterButtonClickEventArgs e)
        {
            base.AfterButtonClick(e);
            string key = e.Key.ToUpperInvariant();

            switch (key)
            {
            case "FQUERYBTN":

                DynamicObjectCollection saleOrgs = (this.View.Model.GetValue("F_ora_h_sale_org") as DynamicObjectCollection);
                string FQOrderNo = this.View.Model.GetValue("FQOrderNo") == null ? "" : this.View.Model.GetValue("FQOrderNo").ToString().Trim();
                string orderType = this.View.Model.GetValue("F_ora_h_order_type") == null ? "" : this.View.Model.GetValue("F_ora_h_order_type").ToString();
                string purNo     = this.View.Model.GetValue("FQPurNo") == null ? "" : this.View.Model.GetValue("FQPurNo").ToString();
                DynamicObjectCollection FQFactoryIds = (this.View.Model.GetValue("FQFactoryId") as DynamicObjectCollection);
                string contractMoney = this.View.Model.GetValue("F_ora_h_money") == null ? "" : this.View.Model.GetValue("F_ora_h_money").ToString();
                string FSDate        = this.View.Model.GetValue("FSDate") == null ? "" : this.View.Model.GetValue("FSDate").ToString();
                string FEDate        = this.View.Model.GetValue("FEDate") == null ? "" : this.View.Model.GetValue("FEDate").ToString();
                DynamicObjectCollection FQDeptIds  = (this.View.Model.GetValue("FQDeptId") as DynamicObjectCollection);
                DynamicObjectCollection FQSalerIds = (this.View.Model.GetValue("FQSalerId") as DynamicObjectCollection);
                DynamicObjectCollection FQCustIds  = (this.View.Model.GetValue("FQCustId") as DynamicObjectCollection);
                string matCode        = this.View.Model.GetValue("F_ora_h_mat_code") == null ? "" : this.View.Model.GetValue("F_ora_h_mat_code").ToString();
                string matName        = this.View.Model.GetValue("F_ora_h_mat_name") == null ? "" : this.View.Model.GetValue("F_ora_h_mat_name").ToString();
                string proType        = this.View.Model.GetValue("F_ora_h_pro_type") == null ? "" : this.View.Model.GetValue("F_ora_h_pro_type").ToString();
                string proCap         = this.View.Model.GetValue("F_ora_h_pro_cap") == null ? "" : this.View.Model.GetValue("F_ora_h_pro_cap").ToString();
                string checkFile      = this.View.Model.GetValue("F_ora_h_check_file") == null ? "" : this.View.Model.GetValue("F_ora_h_check_file").ToString();
                string isReject       = this.View.Model.GetValue("F_ora_h_is_reject") == null ? "" : this.View.Model.GetValue("F_ora_h_is_reject").ToString();
                string projectName    = this.View.Model.GetValue("F_ora_h_project_name") == null ? "" : this.View.Model.GetValue("F_ora_h_project_name").ToString();
                string priceZone      = this.View.Model.GetValue("F_ora_h_price_zone") == null ? "" : this.View.Model.GetValue("F_ora_h_price_zone").ToString();
                string rejectReason   = this.View.Model.GetValue("F_ora_h_reject_reason") == null ? "" : this.View.Model.GetValue("F_ora_h_reject_reason").ToString();
                string cusCreateTime  = this.View.Model.GetValue("F_ora_h_cus_create_time") == null ? "" : this.View.Model.GetValue("F_ora_h_cus_create_time").ToString();
                string cusCreateTime2 = this.View.Model.GetValue("F_ora_h_cus_create_time2") == null ? "" : this.View.Model.GetValue("F_ora_h_cus_create_time2").ToString();
                string recConCode     = this.View.Model.GetValue("F_ora_h_rec_con_code") == null ? "" : this.View.Model.GetValue("F_ora_h_rec_con_code").ToString();
                string recConDesc     = this.View.Model.GetValue("F_ora_h_rec_con_desc") == null ? "" : this.View.Model.GetValue("F_ora_h_rec_con_desc").ToString();


                if (!FSDate.Equals("") && !FEDate.Equals(""))
                {
                    FEDate = FEDate.Replace("00:00:00", "23:59:59");
                }
                else if (!FSDate.Equals(""))
                {
                    FEDate = "2999-01-01 23:59:59";
                }
                else if (!FEDate.Equals(""))
                {
                    FSDate = "1900-01-01 00:00:00";
                }


                string salers = "";

                if (FQSalerIds != null && FQSalerIds.Count > 0)
                {
                    for (int i = 0; i < FQSalerIds.Count; i++)
                    {
                        salers = salers + "," + (FQSalerIds[i]["FQSalerId"] as DynamicObject)["Number"];
                    }
                    if (!salers.Equals(""))
                    {
                        salers = salers.Substring(1);
                    }
                }

                string cus = "";

                if (FQCustIds != null && FQCustIds.Count > 0)
                {
                    for (int i = 0; i < FQCustIds.Count; i++)
                    {
                        cus = cus + "," + (FQCustIds[i]["FQCustId"] as DynamicObject)["Id"];
                    }
                    if (!cus.Equals(""))
                    {
                        cus = cus.Substring(1);
                    }
                }

                string orgs = "";

                if (saleOrgs != null && saleOrgs.Count > 0)
                {
                    for (int i = 0; i < saleOrgs.Count; i++)
                    {
                        orgs = orgs + "," + (saleOrgs[i]["F_ora_h_sale_org"] as DynamicObject)["Number"];
                    }
                    if (!orgs.Equals(""))
                    {
                        orgs = orgs.Substring(1);
                    }
                }

                string deps = "";

                if (FQDeptIds != null && FQDeptIds.Count > 0)
                {
                    for (int i = 0; i < FQDeptIds.Count; i++)
                    {
                        deps = deps + "," + (FQDeptIds[i]["FQDeptId"] as DynamicObject)["Id"];
                    }
                    if (!deps.Equals(""))
                    {
                        deps = deps.Substring(1);
                    }
                }

                string facs = "";

                if (FQFactoryIds != null && FQFactoryIds.Count > 0)
                {
                    for (int i = 0; i < FQFactoryIds.Count; i++)
                    {
                        facs = facs + "," + (FQFactoryIds[i]["FQFactoryId"] as DynamicObject)["Number"];
                    }
                    if (!facs.Equals(""))
                    {
                        facs = facs.Substring(1);
                    }
                }

                string sql = string.Format("EXEC proc_czly_OrderDetail_plugin @QSDt='{0}', @QEDt='{1}', " +
                                           "@QOrderNo = '{2}', @QOrderType = '{3}', " +
                                           "@QSalerNo = '{4}', @QCustNo = '{5}', @QProdType = '{6}', @QVoltageLevel = '{7}', " +
                                           "@QSaleOrgNo = '{8}', @QDeptNo = '{9}', @QStockOrgNo = '{10}'," +
                                           "@QMaterialNo = '{11}', @QCkOrigin = '{12}', @QIsReject = '{13}'," +
                                           "@QRejectReson = '{14}', @QPriceRange = '{15}'",
                                           FSDate, FEDate, FQOrderNo,
                                           orderType, salers, cus, proType, proCap,
                                           orgs, deps, facs, matCode, checkFile, isReject,
                                           rejectReason, priceZone);


                this.View.ShowMessage(sql);

                var objs = DBUtils.ExecuteDynamicObject(this.Context, sql);

                this.View.Model.DeleteEntryData("F_ora_Entity");

                for (int i = 0; i < objs.Count; i++)
                {
                    this.View.Model.CreateNewEntryRow("F_ora_Entity");
                    this.View.Model.SetValue("F_ora_Month", ColFormat(objs[i]["FYearMonth"]), i);
                    this.View.Model.SetValue("F_ora_bill_date", ColFormat(objs[i]["FDate"]), i);
                    this.View.Model.SetValue("F_ora_saleno", ColFormat(objs[i]["FBillNo"]), i);
                    //this.View.Model.SetValue("F_ora_purno", ColFormat(objs[i]["采购订单号"]), i);
                    this.View.Model.SetValue("F_ora_check_contract", ColFormat(objs[i]["FCkOrigin"]), i);
                    this.View.Model.SetValue("F_ora_order_type", ColFormat(objs[i]["订单类型"]), i);
                    this.View.Model.SetValue("F_ora_req_del_date", ColFormat(objs[i]["要货日期"]), i);
                    this.View.Model.SetValue("F_ora_sale_org", ColFormat(objs[i]["销售组织"]), i);
                    this.View.Model.SetValue("F_ora_office", ColFormat(objs[i]["办事处"]), i);
                    this.View.Model.SetValue("F_ora_cus", ColFormat(objs[i]["客户编码"]), i);
                    this.View.Model.SetValue("F_ora_cus_name", ColFormat(objs[i]["客户名称"]), i);
                    this.View.Model.SetValue("F_ora_cus_type_name", ColFormat(objs[i]["客户分类"]), i);
                    this.View.Model.SetValue("F_ora_cus_ind_name", ColFormat(objs[i]["客户行业"]), i);
                    this.View.Model.SetValue("F_ora_pay_cond", ColFormat(objs[i]["收款条件"]), i);
                    this.View.Model.SetValue("F_ora_project_name", ColFormat(objs[i]["项目名称"]), i);
                    this.View.Model.SetValue("F_ora_cus_link", ColFormat(objs[i]["客户联系人"]), i);
                    this.View.Model.SetValue("F_ora_cus_tel", ColFormat(objs[i]["客户联系电话"]), i);
                    this.View.Model.SetValue("F_ora_mat", ColFormat(objs[i]["物料编码"]), i);
                    this.View.Model.SetValue("F_ora_mat_des", ColFormat(objs[i]["物料描述"]), i);
                    this.View.Model.SetValue("F_ora_mat_name", ColFormat(objs[i]["物料名称"]), i);
                    this.View.Model.SetValue("F_ora_num", ColFormat(objs[i]["订单数量"]), i);
                    this.View.Model.SetValue("F_ora_unit", ColFormat(objs[i]["单位"]), i);
                    this.View.Model.SetValue("F_ora_price", ColFormat(objs[i]["含税单价"]), i);
                    this.View.Model.SetValue("F_ora_price_sum", ColFormat(objs[i]["订单小计金额"]), i);
                    this.View.Model.SetValue("F_ora_baseprice", ColFormat(objs[i]["单台基价"]), i);
                    this.View.Model.SetValue("F_ora_baseprice_sum", ColFormat(objs[i]["总基价"]), i);
                    this.View.Model.SetValue("F_ora_money", ColFormat(objs[i]["订单总金额"]), i);
                    this.View.Model.SetValue("F_ora_cut_single", ColFormat(objs[i]["单台扣款"]), i);
                    this.View.Model.SetValue("F_ora_cut", ColFormat(objs[i]["汇总扣款"]), i);
                    this.View.Model.SetValue("F_ora_send_unit", ColFormat(objs[i]["单位"]), i);
                    this.View.Model.SetValue("F_ora_send_num", ColFormat(objs[i]["发货数量"]), i);
                    this.View.Model.SetValue("F_ora_pro_type", ColFormat(objs[i]["产品大类"]), i);
                    this.View.Model.SetValue("F_ora_cap", ColFormat(objs[i]["产品容量"]), i);
                    this.View.Model.SetValue("F_ora_send_sum", ColFormat(objs[i]["发货金额"]), i);
                    this.View.Model.SetValue("F_ora_dec", ColFormat(objs[i]["下浮比例"]), i);
                    this.View.Model.SetValue("F_ora_price_region", ColFormat(objs[i]["价格区间"]), i);
                    this.View.Model.SetValue("F_ora_fac", ColFormat(objs[i]["工厂代码"]), i);
                    this.View.Model.SetValue("F_ora_fac_des", ColFormat(objs[i]["工厂"]), i);
                    this.View.Model.SetValue("F_ora_saler", ColFormat(objs[i]["销售员编号"]), i);
                    this.View.Model.SetValue("F_ora_saler_name", ColFormat(objs[i]["销售员"]), i);
                    this.View.Model.SetValue("F_ora_order_rej_rea", ColFormat(objs[i]["拒绝原因"]), i);
                    this.View.Model.SetValue("F_ora_creator", ColFormat(objs[i]["创建者"]), i);
                    this.View.Model.SetValue("F_ora_creator_name", ColFormat(objs[i]["创建者名称"]), i);
                    this.View.Model.SetValue("F_ora_inner_code", ColFormat(objs[i]["内码"]), i);
                    this.View.Model.SetValue("F_ora_rec_con_code", ColFormat(objs[i]["收款条件编码"]), i);
                    this.View.Model.SetValue("F_ora_cus_create_time", ColFormat(objs[i]["客户创建时间"]), i);
                }


                this.View.UpdateView("F_ora_Entity");

                break;
            }
        }