コード例 #1
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());
            try {
                string     hMode                  = Dispatch.EitherField("HiddenMode");
                string     id                     = Dispatch.EitherField("opco_OppoCompetitorId");
                int        errorflag              = 0;
                string     errormessage           = string.Empty;
                Record     OppoCompetitor         = FindRecord("OppoCompetitor", "opco_OppoCompetitorId=" + id);
                string     opco_opportunityid     = OppoCompetitor.GetFieldAsString("opco_opportunityid");
                EntryGroup OppoCompetitorNewEntry = new EntryGroup("OppoCompetitorNewEntry");
                OppoCompetitorNewEntry.Fill(OppoCompetitor);

                AddTabHead("Delete OppoCompetitor");
                if (hMode == "Delete")
                {
                    OppoCompetitor.DeleteRecord = true;
                    OppoCompetitor.SaveChanges();

                    ////double  =OppoCompetitor.GetFieldAsDouble("");
                    ////Record BusReport= FindRecord("BusReport", "cpet_competitorid=" + cpet_competitorid);
                    ////double  = BusReport.GetFieldAsDouble("");
                    //// =  - ;
                    ////BusReport.SetField("", );
                    ////BusReport.SaveChanges();

                    string opportunityid = Dispatch.EitherField("Key7");
                    string url           = string.Empty;

                    if (!string.IsNullOrEmpty(opportunityid))
                    {
                        url = UrlDotNet(ThisDotNetDll, "RunListPage") + "&J=OppoCompetitor&T=Opportunity";
                    }
                    else
                    {
                        url = UrlDotNet(ThisDotNetDll, "RunCompetitorListPage") + "&J=OppoCompetitor&T=Competitor";
                    }

                    Dispatch.Redirect(url);
                }
                if (errorflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Delete';";
                    OppoCompetitorNewEntry.GetHtmlInViewMode(OppoCompetitor);
                    vpMainPanel.Add(OppoCompetitorNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("ConfirmDelete", "Delete.gif", sUrl);
                    string url = UrlDotNet(ThisDotNetDll, "RunListPage") + "&J=OppoCompetitor&T=Opportunity";
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            } catch (Exception e) {
                AddError(e.Message);
            }
        }
コード例 #2
0
        /*
        public override void BuildContents()
        {
            Record checklist = new Record("ChecklistMaster");

            EntryGroup entry = new EntryGroup("Checklist");

            entry.GetHtmlInEditMode();

            AddContent(entry);

            string sUrl = "javascript:document.EntryForm.HiddenMode.value='Save';";
            AddSubmitButton("Save", "Save.gif", sUrl);

            checklist.SaveChanges();

        }
        */
        public override void AfterSave(EntryGroup screen)
        {
            Record checklist = new Record("ChecklistMaster");
            screen.Fill(checklist);
            checklist.SaveChanges();

            base.AfterSave(screen);
            Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "FlispDisplayCheckList"));
        }
コード例 #3
0
        //    public QuotationDetailDataPageDelete()
        //        : base("Follow", "foll_FollowID", "FollowNewEntry")
        //    {
        //        this.CancelButton = false;
        //        this.DeleteButton = false;
        //    }

        public override void BuildContents()
        {
            try
            {
                AddContent(HTML.Form());
                string qutaid = Dispatch.EitherField("quta_Quotationid");
                if (string.IsNullOrEmpty(qutaid))
                {
                    qutaid = Dispatch.EitherField("key37");
                }
                string     QuotationDetailid = Dispatch.EitherField("qtdt_QuotationDetailID");
                Record     rec = FindRecord("QuotationDetail", "qtdt_QuotationDetailID=" + QuotationDetailid);
                EntryGroup QuotationDetailentry = new EntryGroup("QuotationDetailNewEntry");
                QuotationDetailentry.Fill(rec);
                AddTabHead("QuotationDetail");
                //GetTabs("QuotationDetail", "QuotationDetail");
                string hMode = Dispatch.EitherField("HiddenMode");
                if (hMode == "Save")
                {
                    Record qutarec = FindRecord("Quotation", "quta_Quotationid=" + qutaid);
                    string oppoid  = qutarec.GetFieldAsString("quta_opportunityid");
                    //Record rec =  base.FindCurrentRecord("QuotationDetail");

                    double      thislocal = rec.GetFieldAsDouble("qtdt_localeamount");
                    QuerySelect qs        = this.GetQuery();
                    qs.SQLCommand = "Update Opportunity set oppo_qutaprice = case when (ISNULL(oppo_qutaprice," + thislocal + ")-" + thislocal + ") < 0 then 0 else (ISNULL(oppo_qutaprice," + thislocal + ")-" + thislocal + ") end  where Oppo_OpportunityId =" + oppoid;
                    qs.ExecuteNonQuery();

                    rec.DeleteRecord = true;
                    string code = rec.GetFieldAsString("qtdt_code");
                    rec.SaveChanges();

                    //
                    qs.SQLCommand = "Update QuotationDetail set qtdt_code=qtdt_code-1 where qtdt_code >'" + code + "' and qtdt_deleted is null and qtdt_qutaid =" + qutaid;
                    qs.ExecuteNonQuery();

                    qs.SQLCommand = @"Update Quotation set quta_localeamount = (select sum(qtdt_localeamount) from QuotationDetail where qtdt_deleted is null and qtdt_qutaid= " + qutaid + @")
                        ,quta_foreignamount =  (select sum(qtdt_foreignamount) from QuotationDetail where qtdt_deleted is null and qtdt_qutaid= " + qutaid + @")    where quta_Quotationid=" + qutaid;
                    qs.ExecuteNonQuery();
                    Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "RunDataPage") + "&quta_Quotationid=" + qutaid);
                }


                /* Add your code here */

                AddContent(HTML.InputHidden("HiddenMode", ""));
                QuotationDetailentry.GetHtmlInViewMode(rec);
                AddContent(QuotationDetailentry);
                AddSubmitButton("确认删除", "delete.gif", "javascript:document.EntryForm.HiddenMode.value='Save';");
                AddUrlButton("Cancel", "Cancel.gif", UrlDotNet(ThisDotNetDll, "RunDataPage") + "&quta_Quotationid=" + qutaid);
            }
            catch (Exception error)
            {
                this.AddError(error.Message);
            }
        }
コード例 #4
0
ファイル: EntityDataPageNew.cs プロジェクト: Cross985/XXGJ2.0
        public override void BuildContents()
        {
            AddContent(HTML.Form());

            try {
                string     hMode = Dispatch.EitherField("HiddenMode");
                string     opsu_opportunityid  = Dispatch.EitherField("Key7");
                int        errorflag           = 0;
                string     errormessage        = string.Empty;
                EntryGroup OppoSupportNewEntry = new EntryGroup("OppoSupportNewEntry");
                //CostAdjustmentProductNewEntry.Title = "Add CostAdjustmentProduct";
                Entry opsu_opportunityidEntry = OppoSupportNewEntry.GetEntry("opsu_opportunityid");
                if (opsu_opportunityidEntry != null)
                {
                    opsu_opportunityidEntry.DefaultValue = opsu_opportunityid;
                    opsu_opportunityidEntry.ReadOnly     = true;
                }

                AddTabHead("OppoSupport");
                if (hMode == "Save")
                {
                    Record OppoSupport = new Record("OppoSupport");
                    OppoSupportNewEntry.Fill(OppoSupport);
                    if (OppoSupportNewEntry.Validate())
                    {
                        OppoSupport.SaveChanges();
                        string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&opsu_OppoSupportid=" + OppoSupport.GetFieldAsString("opsu_OppoSupportid") + "&J=Summary";
                        Dispatch.Redirect(url);
                        errorflag = -1;
                    }
                    else
                    {
                        errorflag = 1;
                    }
                }
                if (errorflag != -1)
                {
                    if (errorflag == 2)
                    {
                        AddError(errormessage);
                    }

                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    OppoSupportNewEntry.GetHtmlInEditMode();
                    vpMainPanel.Add(OppoSupportNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("Save", "Save.gif", sUrl);
                    AddUrlButton("Cancel", "cancel.gif", UrlDotNet(ThisDotNetDll, "RunListPage") + "&J=OppoSupport&T=Opportunity");
                }
            } catch (Exception e) {
                AddError(e.Message);
            }
        }
コード例 #5
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());
            try {
                string     hMode              = Dispatch.EitherField("HiddenMode");
                string     id                 = Dispatch.EitherField("optr_OppoTrackId");
                int        errorflag          = 0;
                string     errormessage       = string.Empty;
                Record     OppoTrack          = FindRecord("OppoTrack", "optr_OppoTrackId=" + id);
                string     optr_opportunityid = OppoTrack.GetFieldAsString("optr_opportunityid");
                string     oppoid             = Dispatch.EitherField("key7");
                EntryGroup OppoTrackNewEntry  = new EntryGroup("OppoTrackNewEntry");
                OppoTrackNewEntry.Fill(OppoTrack);

                AddTabHead("Delete OppoTrack");
                if (hMode == "Delete")
                {
                    OppoTrack.DeleteRecord = true;
                    OppoTrack.SaveChanges();

                    QuerySelect qs = this.GetQuery();
                    qs.SQLCommand = @"Update Opportunity set oppo_nexttrackdate = (select MAX(optr_nexttrackdate) from OppoTrack where optr_deleted is null and optr_opportunityid=" + optr_opportunityid + @")
                        ,oppo_trackdate = (select MAX(optr_date) from OppoTrack where optr_deleted is null and optr_opportunityid=" + optr_opportunityid + @" )
                        ,oppo_targetclose = (select optr_targetclose  from OppoTrack where optr_OppoTrackId = " + OppoTrack.RecordId.ToString() + @" )
                        ,oppo_forecast = (select optr_forecast from OppoTrack where optr_OppoTrackId = " + OppoTrack.RecordId.ToString() + @") 
                        ,oppo_certainty = (select optr_certainty  from OppoTrack where optr_OppoTrackId = " + OppoTrack.RecordId.ToString() + @") where oppo_opportunityid=" + optr_opportunityid;
                    qs.ExecuteNonQuery();

                    string url = string.Empty;
                    if (string.IsNullOrEmpty(oppoid))
                    {
                        url = UrlDotNet("SalesMenu", "RunOppoTrack") + "&J=OppoTrack&T=SalesManagement";
                    }
                    else
                    {
                        url = UrlDotNet(ThisDotNetDll, "RunListPage") + "&J=OppoTrack&T=Opportunity";
                    }
                    Dispatch.Redirect(url);
                }
                if (errorflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Delete';";
                    OppoTrackNewEntry.GetHtmlInViewMode(OppoTrack);
                    vpMainPanel.Add(OppoTrackNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("ConfirmDelete", "Delete.gif", sUrl);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&optr_OppoTrackId=" + id + "&J=Summary";
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            } catch (Exception e) {
                AddError(e.Message);
            }
        }
コード例 #6
0
        /*
         * public override void BuildContents()
         * {
         *  Record checklist = new Record("ChecklistMaster");
         *
         *  EntryGroup entry = new EntryGroup("Checklist");
         *
         *  entry.GetHtmlInEditMode();
         *
         *  AddContent(entry);
         *
         *  string sUrl = "javascript:document.EntryForm.HiddenMode.value='Save';";
         *  AddSubmitButton("Save", "Save.gif", sUrl);
         *
         *  checklist.SaveChanges();
         *
         * }
         */

        public override void AfterSave(EntryGroup screen)
        {
            Record checklist = new Record("ChecklistMaster");

            screen.Fill(checklist);
            checklist.SaveChanges();

            base.AfterSave(screen);
            Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "FlispDisplayCheckList"));
        }
コード例 #7
0
        /*
         * public override void BuildContents()
         * {
         *  AddInfo("Capture Application Information");
         *
         *  Record oppo = new Record("Opportunity");
         *
         *  EntryGroup webPicker = new EntryGroup("OpportunityWebPicker");
         *
         *  EntryGroup entry = new EntryGroup("OpportunityDetailBox");
         *
         *  entry.GetHtmlInEditMode();
         *  webPicker.GetHtmlInEditMode();
         *
         *
         *  AddContent(webPicker);
         *  AddContent(entry);
         *
         *  AddSaveButton();
         *
         *  oppo.SaveChanges();
         *
         *  //Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "FlispApplicationsList"));
         *
         *  //AddUrlButton("Go To List", "new.gif", UrlDotNet(ThisDotNetDll, "FlispApplicationsList"));
         *
         *  //base.BuildContents();
         *
         * }*/

        public override void AfterSave(EntryGroup screen)
        {
            Record oppo = new Record("Opportunity");

            screen.Fill(oppo);
            oppo.SaveChanges();

            Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "FlispApplicationList"));
            base.AfterSave(screen);
        }
コード例 #8
0
ファイル: EntityDataPageNew.cs プロジェクト: Cross985/XXGJ2.0
        public override void BuildContents()
        {
            AddContent(HTML.Form());

            try {
                string hMode = Dispatch.EitherField("HiddenMode");
                string mapl_maractpoolid = Dispatch.EitherField("mapl_maractpoolid");
                if (string.IsNullOrEmpty(mapl_maractpoolid)) {
                    mapl_maractpoolid = Dispatch.EitherField("Key58");
                }
                int errorflag = 0;
                string errormessage = string.Empty;
                EntryGroup MarActPlanNewEntry = new EntryGroup("MarActPlanNewEntry");
                //CostAdjustmentProductNewEntry.Title = "Add CostAdjustmentProduct";
                Entry mapl_maractpoolidEntry = MarActPlanNewEntry.GetEntry("mapl_maractpoolid");
                if (mapl_maractpoolidEntry != null) {
                    mapl_maractpoolidEntry.DefaultValue = mapl_maractpoolid;
                    mapl_maractpoolidEntry.ReadOnly = true;
                }

                AddTabHead("MarActPlan");
                if (hMode == "Save") {
                    Record MarActPlan = new Record("MarActPlan");
                    MarActPlanNewEntry.Fill(MarActPlan);
                    if (MarActPlanNewEntry.Validate()) {

                        MarActPlan.SaveChanges();

                        string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&mapl_maractplanid=" + MarActPlan.RecordId + "&J=Summary";
                        Dispatch.Redirect(url);
                        errorflag = -1;
                    } else {
                        errorflag = 1;
                    }
                }
                if (errorflag != -1) {
                    if (errorflag == 2) {
                        AddError(errormessage);
                    }

                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    MarActPlanNewEntry.GetHtmlInEditMode();
                    vpMainPanel.Add(MarActPlanNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("Save", "Save.gif", sUrl);
                    AddUrlButton("Cancel", "cancel.gif", UrlDotNet(ThisDotNetDll, "RunListPage") + "&J=MarActPlan&T=MarketingManagement");
                }

            } catch (Exception e) {
                AddError(e.Message);
            }
        }
コード例 #9
0
 public override void BuildContents()
 {
     try
     {
         AddContent(HTML.Form());
         string     qutaid        = Dispatch.EitherField("quta_Quotationid");
         EntryGroup qutacompEntry = new EntryGroup("QuotationCompanyEntry");
         qutacompEntry.Title = "商机客户";
         EntryGroup qutaEntry = new EntryGroup("QuotationNewEntry");
         qutaEntry.Title = "报价信息";
         Record qutaRec = FindRecord("Quotation", "quta_Quotationid=" + qutaid);
         qutacompEntry.Fill(qutaRec);
         qutaEntry.Fill(qutaRec);
         AddTabHead("Quotation");
         int    errflag = 0;
         string hMode   = Dispatch.EitherField("HiddenMode");
         if (hMode == "Save")
         {
             if (qutaEntry.Validate() == true && qutacompEntry.Validate())
             {
                 qutaEntry.Fill(qutaRec);
                 qutacompEntry.Fill(qutaRec);
                 string quta_opportunityid = qutaRec.GetFieldAsString("quta_opportunityid");
                 string quta_updateoppo    = qutaRec.GetFieldAsString("quta_updateoppo");
                 if (quta_updateoppo.ToLower() == "y")
                 {
                     QuerySelect qs = this.GetQuery();
                     qs.SQLCommand = "Update Opportunity set oppo_qutaprice= (select sum(quta_localeamount) from Quotation where quta_deleted is null and quta_updateoppo = 'Y' and quta_opportunityid = " + quta_opportunityid + " ) where oppo_Opportunityid =" + quta_opportunityid;
                     qs.ExecuteNonQuery();
                 }
                 qutaRec.SaveChanges();
                 Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "RunDataPage") + "&quta_Quotationid=" + qutaid);
             }
         }
         if (errflag != -1)
         {
             AddContent(HTML.InputHidden("HiddenMode", ""));
             qutacompEntry.GetHtmlInEditMode(qutaRec);
             qutaEntry.GetHtmlInEditMode(qutaRec);
             VerticalPanel vp = new VerticalPanel();
             vp.AddAttribute("width", "100%");
             vp.Add(qutacompEntry);
             vp.Add(qutaEntry);
             AddContent(vp);
             AddSubmitButton("Save", "Save.gif", "javascript:document.EntryForm.HiddenMode.value='Save';");
             AddUrlButton("Delete", "Delete.gif", UrlDotNet(ThisDotNetDll, "RunDataPageDelete") + "&quta_Quotationid=" + qutaid);
             AddUrlButton("Cancel", "Cancel.gif", UrlDotNet(ThisDotNetDll, "RunDataPage") + "&quta_Quotationid=" + qutaid);
         }
     }
     catch (Exception error)
     {
         this.AddError(error.Message);
     }
 }
コード例 #10
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());
            try
            {
                string hMode             = Dispatch.EitherField("HiddenMode");
                string id                = Dispatch.EitherField("dper_decoratepersonid");
                int    errorflag         = 0;
                string errormessage      = string.Empty;
                Record DecoratePerson    = FindRecord("DecoratePerson", "dper_decoratepersonid=" + id);
                string dper_competitorid = DecoratePerson.GetFieldAsString("dper_competitorid");

                EntryGroup CompetitionPersonNewEntry = new EntryGroup("CompetitionPersonNewEntry");
                CompetitionPersonNewEntry.Fill(DecoratePerson);

                AddTabHead("Delete Person");
                if (hMode == "Delete")
                {
                    DecoratePerson.DeleteRecord = true;
                    DecoratePerson.SaveChanges();

                    ////double  =Person.GetFieldAsDouble("");
                    ////Record BusReport= FindRecord("BusReport", "cpet_competitorid=" + cpet_competitorid);
                    ////double  = BusReport.GetFieldAsDouble("");
                    //// =  - ;
                    ////BusReport.SetField("", );
                    ////BusReport.SaveChanges();

                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&cpet_competitorid=" + dper_competitorid + "&J=Summary";
                    url = url.Replace("Key37", "DecoratePersonid");
                    url = url + "&Key37=" + dper_competitorid;
                    Dispatch.Redirect(url);
                }
                if (errorflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Delete';";
                    CompetitionPersonNewEntry.GetHtmlInViewMode(DecoratePerson);
                    vpMainPanel.Add(CompetitionPersonNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("ConfirmDelete", "Delete.gif", sUrl);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&cpet_competitorid=" + dper_competitorid + "&J=Summary";
                    url = url.Replace("Key37", "DecoratePersonid");
                    url = url + "&Key37=" + dper_competitorid;
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            }
            catch (Exception e)
            {
                AddError(e.Message);
            }
        }
コード例 #11
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());
            try
            {
                string     hMode             = Dispatch.EitherField("HiddenMode");
                string     id                = Dispatch.EitherField("brra_BrandRateId");
                int        errorflag         = 0;
                string     errormessage      = string.Empty;
                Record     BrandRate         = FindRecord("BrandRate", "brra_BrandRateId=" + id);
                string     maif_MarketInfoId = BrandRate.GetFieldAsString("brra_marketinfoid");
                EntryGroup BrandRateNewEntry = new EntryGroup("BrandRateNewEntry");
                BrandRateNewEntry.Fill(BrandRate);

                AddTabHead("Delete BrandRate");
                if (hMode == "Delete")
                {
                    BrandRate.DeleteRecord = true;
                    BrandRate.SaveChanges();

                    ////double  =BrandRate.GetFieldAsDouble("");
                    ////Record MarketInfo= FindRecord("MarketInfo", "maif_MarketInfoId=" + maif_MarketInfoId);
                    ////double  = MarketInfo.GetFieldAsDouble("");
                    //// =  - ;
                    ////MarketInfo.SetField("", );
                    ////MarketInfo.SaveChanges();

                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&maif_MarketInfoId=" + maif_MarketInfoId + "&J=Summary";
                    url = url.Replace("Key37", "BrandRateid");
                    url = url + "&Key37=" + maif_MarketInfoId;
                    Dispatch.Redirect(url);
                }
                if (errorflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Delete';";
                    BrandRateNewEntry.GetHtmlInViewMode(BrandRate);
                    vpMainPanel.Add(BrandRateNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("ConfirmDelete", "Delete.gif", sUrl);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&maif_MarketInfoId=" + maif_MarketInfoId + "&J=Summary";
                    url = url.Replace("Key37", "BrandRateid");
                    url = url + "&Key37=" + maif_MarketInfoId;
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            }
            catch (Exception e)
            {
                AddError(e.Message);
            }
        }
コード例 #12
0
ファイル: EntityDataPageNew.cs プロジェクト: Cross985/XXGJ
        public override void BuildContents()
        {
            try
            {
                AddContent(HTML.Form());

                EntryGroup qutacompEntry = new EntryGroup("QuotationCompanyEntry");
                qutacompEntry.Title = "商机客户";
                EntryGroup qutaEntry = new EntryGroup("QuotationNewEntry");
                qutaEntry.Title = "报价信息";

                AddTabHead("Quotation");
                int    errflag = 0;
                string hMode   = Dispatch.EitherField("HiddenMode");
                if (hMode == "Save")
                {
                    Record QutaRec = new Record("Quotation");
                    qutacompEntry.Fill(QutaRec);
                    qutaEntry.Fill(QutaRec);
                    if (qutaEntry.Validate() == true && qutacompEntry.Validate())
                    {
                        string oppoid = Dispatch.EitherField("oppo_OpportunityId");
                        if (string.IsNullOrEmpty(oppoid))
                        {
                            oppoid = Dispatch.EitherField("key7");
                        }
                        QutaRec.SetField("quta_OpportunityId", oppoid);
                        QutaRec.SaveChanges();
                        Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "RunDataPage") + "&quta_Quotationid=" + QutaRec.RecordId.ToString());
                    }
                }
                if (errflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    qutacompEntry.GetHtmlInEditMode();
                    qutaEntry.GetHtmlInEditMode();
                    VerticalPanel vp = new VerticalPanel();
                    vp.AddAttribute("width", "100%");
                    vp.Add(qutacompEntry);
                    vp.Add(qutaEntry);
                    AddContent(vp);
                    AddSubmitButton("Save", "Save.gif", "javascript:document.EntryForm.HiddenMode.value='Save';");
                    AddUrlButton("Cancel", "Cancel.gif", UrlDotNet(ThisDotNetDll, "RunListPage") + "&J=Quotation&T=Opportunity");
                }
            }
            catch (Exception error)
            {
                this.AddError(error.Message);
            }
        }
コード例 #13
0
        private void UnlinkCompany(int companyId)
        {
            Record record = base.FindRecord("Company", string.Format("Comp_CompanyId={0}", companyId));

            record.SetField(this._Sage300Field, "");
            record.SetField("Comp_IdGrp", "");
            record.SetField("Comp_CodeTaxGrp", "");
            record.SetField("Comp_CodeTerm", "");
            record.SetField("Comp_AmtCrLimt", "");
            record.SetField("comp_database", "");
            record.SetField("comp_status", "Active");
            record.SetField("Comp_Type", "Dormant");
            record.SaveChanges();
        }
コード例 #14
0
ファイル: EntityDataPageNew.cs プロジェクト: Cross985/XXGJ
        public override void BuildContents()
        {
            try
            {
                AddContent(HTML.Form());
                //string compid = Dispatch.EitherField("comp_companyid");
                EntryGroup CompEntry = new EntryGroup("CompanyBoxLong");
                CompEntry.Title = "基础信息";
                EntryGroup DealEntry = new EntryGroup("CompanyDealEntry");
                DealEntry.Title = "交易信息";
                EntryGroup StatusEntry = new EntryGroup("CompanyStatusEntry");
                StatusEntry.Title = "状态信息";

                GetTabs("CompanySummary", "Summary");
                int    errflag = 0;
                string hMode   = Dispatch.EitherField("HiddenMode");
                if (hMode == "Save")
                {
                    Record CompRec = new Record("Company");
                    CompEntry.Fill(CompRec);
                    DealEntry.Fill(CompRec);
                    StatusEntry.Fill(CompRec);
                    if (CompEntry.Validate() == true && DealEntry.Validate() && DealEntry.Validate() == true && StatusEntry.Validate())
                    {
                        CompRec.SaveChanges();
                        Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "RunDataPage") + "&comp_companyid=" + CompRec.RecordId.ToString());
                    }
                }
                if (errflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    CompEntry.GetHtmlInEditMode();
                    DealEntry.GetHtmlInEditMode();
                    //StatusEntry.GetHtmlInEditMode();
                    VerticalPanel vp = new VerticalPanel();
                    vp.AddAttribute("width", "100%");
                    vp.Add(CompEntry);
                    vp.Add(DealEntry);
                    //vp.Add(StatusEntry);
                    AddContent(vp);
                    AddSubmitButton("Save", "Save.gif", "javascript:document.EntryForm.HiddenMode.value='Save';");
                    AddUrlButton("Cancel", "Cancel.gif", UrlDotNet(ThisDotNetDll, "RunListPage") + "&T=CompanyList");
                }
            }
            catch (Exception error)
            {
                this.AddError(error.Message);
            }
        }
コード例 #15
0
ファイル: AddressEdit.cs プロジェクト: Cross985/XXGJ2.0
        public override void BuildContents()
        {
            try
            {
                AddContent(HTML.Form());
                string compid = Dispatch.EitherField("comp_companyid");
                if (string.IsNullOrEmpty(compid))
                {
                    compid = Dispatch.EitherField("key1");
                }
                string     addrid    = Dispatch.EitherField("addr_AddressID");
                string     hMode     = Dispatch.EitherField("HiddenMode");
                EntryGroup AddrEntry = new EntryGroup("CompanyAddressEntry");
                AddrEntry.Title = "地址信息";
                Record AddrRec = FindRecord("Address", "addr_AddressID=" + addrid);
                int    errflag = 0;
                AddTabHead("Address");
                //GetTabs("CompanyAddress", "Address");
                if (hMode == "Save")
                {
                    AddrEntry.Fill(AddrRec);
                    if (AddrEntry.Validate() == true)
                    {
                        AddrRec.SetField("usst_companyid", compid);
                        AddrRec.SaveChanges();
                        Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "RunAddressList") + "&comp_companyid=" + compid + "&J=Summary&T=CompanySummary");
                    }
                }
                if (errflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    AddrEntry.GetHtmlInEditMode(AddrRec);
                    VerticalPanel vp = new VerticalPanel();
                    vp.AddAttribute("width", "100%");
                    vp.Add(AddrEntry);
                    AddContent(vp);

                    string url = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    AddSubmitButton("Save", "Save.gif", url);
                    AddUrlButton("Delete", "Delete.gif", UrlDotNet(ThisDotNetDll, "RunAddressDelete") + "&comp_companyid=" + compid + "&addr_AddressID=" + addrid);
                    AddUrlButton("Cancel", "cancel.gif", UrlDotNet(ThisDotNetDll, "RunAddressList") + "&comp_companyid=" + compid + "&J=Summary&T=CompanySummary");
                }
            }
            catch (Exception ex)
            {
                AddError(ex.Message + "AddrEditPage");
            }
        }
コード例 #16
0
        public override void BuildContents()
        {
            try
            {
                AddContent(HTML.Form());
                string compid = Dispatch.EitherField("comp_companyid");
                if (string.IsNullOrEmpty(compid))
                {
                    compid = Dispatch.EitherField("key1");
                }
                string     hMode     = Dispatch.EitherField("HiddenMode");
                EntryGroup IntiEntry = new EntryGroup("InvoiceTitleNewEntry");
                IntiEntry.Title = "发票抬头";
                int errflag = 0;
                AddTabHead("InvoiceTitle");
                if (hMode == "Save")
                {
                    Record IntiRec = new Record("InvoiceTitle");
                    IntiEntry.Fill(IntiRec);
                    if (IntiEntry.Validate() == true)
                    {
                        IntiRec.SetField("inti_companyid", compid);
                        IntiRec.SaveChanges();
                        Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "RunInvoiceTitleList") + "&comp_companyid=" + compid + "&J=InvoiceTitle&T=Company");
                    }
                }
                if (errflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    IntiEntry.GetHtmlInEditMode();
                    VerticalPanel vp = new VerticalPanel();
                    vp.AddAttribute("width", "100%");
                    vp.Add(IntiEntry);
                    AddContent(vp);

                    string url = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    AddSubmitButton("Save", "Save.gif", url);
                    AddUrlButton("Cancel", "cancel.gif", UrlDotNet(ThisDotNetDll, "RunInvoiceTitleList") + "&comp_companyid=" + compid + "&J=InvoiceTitle&T=Company");
                }
            }
            catch (Exception ex)
            {
                AddError(ex.Message + "IntiAddPage");
            }
        }
コード例 #17
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());
            try
            {
                string     hMode                  = Dispatch.EitherField("HiddenMode");
                string     id                     = Dispatch.EitherField("spde_SalePlanDetailid");
                int        errorflag              = 0;
                string     errormessage           = string.Empty;
                Record     SalePlanDetail         = FindRecord("SalePlanDetail", "spde_SalePlanDetailid=" + id);
                string     spde_monthplanid       = SalePlanDetail.GetFieldAsString("spde_monthplanid");
                EntryGroup DecoratePersonNewEntry = new EntryGroup("SalePlanDetailNewEntry");
                DecoratePersonNewEntry.Fill(SalePlanDetail);

                AddTabHead("Delete SalePlanDetail");
                if (hMode == "Delete")
                {
                    SalePlanDetail.DeleteRecord = true;
                    SalePlanDetail.SaveChanges();
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&mopl_MonthPlanId=" + spde_monthplanid + "&J=Summary";
                    url = url.Replace("Key37", "SalePlanDetailid");
                    url = url + "&Key37=" + spde_monthplanid;
                    Dispatch.Redirect(url);
                }
                if (errorflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Delete';";
                    DecoratePersonNewEntry.GetHtmlInViewMode(SalePlanDetail);
                    vpMainPanel.Add(DecoratePersonNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("ConfirmDelete", "Delete.gif", sUrl);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&mopl_MonthPlanId=" + spde_monthplanid + "&J=Summary";
                    url = url.Replace("Key37", "SalePlanDetailid");
                    url = url + "&Key37=" + spde_monthplanid;
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            }
            catch (Exception e)
            {
                AddError(e.Message);
            }
        }
コード例 #18
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());
            try
            {
                string     hMode                = Dispatch.EitherField("HiddenMode");
                string     id                   = Dispatch.EitherField("cust_cususestatusid");
                int        errorflag            = 0;
                string     errormessage         = string.Empty;
                Record     CusUseStatus         = FindRecord("CusUseStatus", "cust_cususestatusid=" + id);
                string     cust_serviceacceptid = CusUseStatus.GetFieldAsString("cust_serviceacceptid");
                EntryGroup CusUseStatusNewEntry = new EntryGroup("CusUseStatusNewEntry");
                CusUseStatusNewEntry.Fill(CusUseStatus);

                AddTabHead("Delete CusUseStatus");
                if (hMode == "Delete")
                {
                    CusUseStatus.DeleteRecord = true;
                    CusUseStatus.SaveChanges();
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&seac_ServiceAcceptId=" + cust_serviceacceptid + "&J=Summary";
                    url = url.Replace("Key37", "CusUseStatusid");
                    url = url + "&Key37=" + cust_serviceacceptid;
                    Dispatch.Redirect(url);
                }
                if (errorflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Delete';";
                    CusUseStatusNewEntry.GetHtmlInViewMode(CusUseStatus);
                    vpMainPanel.Add(CusUseStatusNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("ConfirmDelete", "Delete.gif", sUrl);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&seac_ServiceAcceptId=" + cust_serviceacceptid + "&J=Summary";
                    url = url.Replace("Key37", "CusUseStatusid");
                    url = url + "&Key37=" + cust_serviceacceptid;
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            }
            catch (Exception e)
            {
                AddError(e.Message);
            }
        }
コード例 #19
0
ファイル: EntityDataPageNew.cs プロジェクト: Cross985/XXGJ2.0
        public override void AfterSave(Sage.CRM.Controls.EntryGroup screen)
        {
            Record Rec = screen.getRecord;

            screen.Fill(Rec);
            Rec.SaveChanges();
            string      startdate = Rec.GetFieldAsDateTime("mopl_startdate").ToString("yyyy-MM-dd");
            string      userid    = Rec.GetFieldAsString("mopl_userid");
            QuerySelect qs        = this.GetQuery();

            qs.SQLCommand = "select user_LastName from Users where user_userid=" + userid;
            qs.ExecuteReader();
            string username = qs.FieldValue("user_LastName");
            string name     = username + "/" + startdate;

            qs.SQLCommand = "Update MonthPlan set mopl_Name ='" + name + "' where mopl_MonthPlanid =" + Rec.RecordId.ToString();
            qs.ExecuteNonQuery();
            base.AfterSave(screen);
        }
コード例 #20
0
        public override void BuildContents()
        {
            try
            {
                AddContent(HTML.Form());
                string     compid  = Dispatch.EitherField("comp_companyid");
                string     hMode   = Dispatch.EitherField("HiddenMode");
                EntryGroup USEntry = new EntryGroup("UseSituationNewEntry");
                USEntry.Title = "使用情况";
                int errflag = 0;
                AddTabHead("UseSituation");
                if (hMode == "Save")
                {
                    Record USRec = new Record("UseSituation");
                    USEntry.Fill(USRec);
                    if (USEntry.Validate() == true)
                    {
                        USRec.SetField("usst_companyid", compid);
                        USRec.SaveChanges();
                        Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "RunUSList") + "&comp_companyid=" + compid + "&J=Summary&T=CompanySummary");
                    }
                }
                if (errflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    USEntry.GetHtmlInEditMode();
                    VerticalPanel vp = new VerticalPanel();
                    vp.AddAttribute("width", "100%");
                    vp.Add(USEntry);
                    AddContent(vp);

                    string url = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    AddSubmitButton("Save", "Save.gif", url);
                    AddUrlButton("Cancel", "cancel.gif", UrlDotNet(ThisDotNetDll, "RunUSList") + "&comp_companyid=" + compid + "&J=Summary&T=CompanySummary");
                }
            }
            catch (Exception ex)
            {
                AddError(ex.Message + "USAddPage");
            }
        }
コード例 #21
0
        public override void AfterSave(Sage.CRM.Controls.EntryGroup screen)
        {
            Record      order  = screen.getRecord;
            QuerySelect s      = new QuerySelect();
            string      prefix = "M" + DateTime.Now.ToString("yyyyMMdd");

            s.SQLCommand = "select count(*) as count from MarketInfo where maif_name like '" + prefix + "%'";
            s.ExecuteReader();
            int cnt = 0;

            if (!s.Eof())
            {
                cnt = Convert.ToInt32(s.FieldValue("count"));
            }
            string code = string.Empty;

            code = prefix + (cnt + 1).ToString().PadLeft(2, '0');
            order.SetField("maif_name", code);
            order.SaveChanges();
            base.AfterSave(screen);
        }
コード例 #22
0
ファイル: EntityDataPageEdit.cs プロジェクト: Cross985/XXGJ
        public override void BuildContents()
        {
            try
            {
                /* Add your code here */
                this.EntryGroups[0].Title = "Contract";
                base.BuildContents();

                string cont_ContractId     = Dispatch.EitherField("cont_ContractId");
                Record Contract            = FindRecord("Contract", "cont_ContractId=" + cont_ContractId);
                double cont_amount         = Contract.GetFieldAsDouble("cont_amount");
                double cont_discount       = Contract.GetFieldAsDouble("cont_discount");
                double cont_discountamount = cont_amount - cont_discount;
                Contract.SetField("cont_discountamount", cont_discountamount);
                Contract.SaveChanges();
            }
            catch (Exception error)
            {
                this.AddError(error.Message);
            }
        }
コード例 #23
0
ファイル: AddressDelete.cs プロジェクト: Cross985/XXGJ2.0
        //    public AddressDataPageDelete()
        //        : base("Follow", "foll_FollowID", "FollowNewEntry")
        //    {
        //        this.CancelButton = false;
        //        this.DeleteButton = false;
        //    }

        public override void BuildContents()
        {
            try
            {
                AddContent(HTML.Form());
                string     compid       = string.Empty;
                string     Addressid    = Dispatch.EitherField("addr_AddressID");
                Record     rec          = FindRecord("Address", "addr_AddressID=" + Addressid);
                EntryGroup Addressentry = new EntryGroup("CompanyAddressEntry");
                Addressentry.Fill(rec);
                AddTabHead("Address");
                //GetTabs("Address", "Address");
                string hMode = Dispatch.EitherField("HiddenMode");
                if (hMode == "Save")
                {
                    //Record rec =  base.FindCurrentRecord("Address");
                    rec.DeleteRecord = true;
                    rec.SaveChanges();
                    Dispatch.Redirect(UrlDotNet("Company", "RunAddressList") + "&comp_companyid=" + compid);
                }


                /* Add your code here */
                compid = Dispatch.EitherField("comp_companyid");
                if (string.IsNullOrEmpty(compid))
                {
                    compid = Dispatch.EitherField("key1");
                }
                /* Add your code here */
                AddContent(HTML.InputHidden("HiddenMode", ""));
                Addressentry.GetHtmlInViewMode(rec);
                AddContent(Addressentry);
                AddSubmitButton("确认删除", "delete.gif", "javascript:document.EntryForm.HiddenMode.value='Save';");
                AddUrlButton("Cancel", "Cancel.gif", UrlDotNet("Company", "RunAddressList") + "&comp_companyid=" + compid);
            }
            catch (Exception error)
            {
                this.AddError(error.Message);
            }
        }
コード例 #24
0
ファイル: EntityDataPageNew.cs プロジェクト: Cross985/XXGJ2.0
        public override void AfterSave(Sage.CRM.Controls.EntryGroup screen)
        {
            //维修单编码规则 R+年月日+2码流水
            Record      order    = screen.getRecord;
            QuerySelect s        = new QuerySelect();
            string      username = CurrentUser.UserName;
            string      prefix   = "R" + DateTime.Now.ToString("yyyyMMDD");

            s.SQLCommand = "select count(*) as count from Maintenance where mate_name like '" + prefix + "%'";
            s.ExecuteReader();
            int cnt = 0;

            if (!s.Eof())
            {
                cnt = Convert.ToInt32(s.FieldValue("count"));
            }
            string code = string.Empty;

            code = prefix + (cnt + 1).ToString().PadLeft(2, '0');
            order.SetField("mate_name", code);
            order.SaveChanges();
            base.AfterSave(screen);
        }
コード例 #25
0
        public override void BuildContents()
        {
            //throw new NotImplementedException();

            int checkId = int.Parse(Dispatch.EitherField("clsv_ChecklistSlaveId"));

            Record checklistRecord = FindRecord("ChecklistSlave", "clsv_ChecklistSlaveId = " + checkId);

            switch (_checklistType)
            {
            case CheckTypee.Applicant:
                checklistRecord.SetField("clsv_Applicant", checklistRecord.GetFieldAsString("clsv_Applicant") == "Y" ? "N" : "Y");
                break;

            case CheckTypee.Spouse:
                checklistRecord.SetField("clsv_Spouse", checklistRecord.GetFieldAsString("clsv_Spouse") == "Y" ? "N" : "Y");
                break;
            }

            checklistRecord.SaveChanges();

            Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "FlispCheckListSlaveList"));
        }
コード例 #26
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());

            try
            {
                string     hMode = Dispatch.EitherField("HiddenMode");
                string     pmet_ProcessMethodid  = Dispatch.EitherField("pmet_ProcessMethodid");
                int        errorflag             = 0;
                string     errormessage          = string.Empty;
                Record     ProcessMethod         = FindRecord("ProcessMethod", "pmet_ProcessMethodid=" + pmet_ProcessMethodid);
                string     pmet_monthplanid      = ProcessMethod.GetFieldAsString("pmet_monthplanid");
                EntryGroup ProcessMethodNewEntry = new EntryGroup("ProcessMethodNewEntry");
                ProcessMethodNewEntry.Fill(ProcessMethod);
                Entry IntentionOrderidEntry = ProcessMethodNewEntry.GetEntry("pmet_monthplanid");

                IntentionOrderidEntry.ReadOnly = true;

                //AddTabHead("Person");
                //GetTabs("Person", "Person Summary");
                AddTabHead("ProcessMethod");
                if (hMode == "Save")
                {
                    ////double original =Person.GetFieldAsDouble("");
                    ProcessMethodNewEntry.Fill(ProcessMethod);
                    ////double  =Person.GetFieldAsDouble("");

                    if (ProcessMethodNewEntry.Validate())
                    {
                        ProcessMethod.SaveChanges();

                        ////Record BusReport= FindRecord("BusReport", "cpet_competitorid=" + cpet_competitorid);
                        ////double  = BusReport.GetFieldAsDouble("");
                        //// =  + - original;
                        ////BusReport.SetField("", );
                        ////BusReport.SaveChanges();

                        string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&mopl_MonthPlanId=" + pmet_monthplanid + "&J=Summary";
                        url = url.Replace("Key37", "Personid");
                        url = url + "&Key37=" + pmet_monthplanid;
                        Dispatch.Redirect(url);
                        errorflag = -1;
                    }
                    else
                    {
                        errorflag = 1;
                    }
                }
                if (errorflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    ProcessMethodNewEntry.GetHtmlInEditMode(ProcessMethod);
                    vpMainPanel.Add(ProcessMethodNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("Save", "Save.gif", sUrl);
                    string urldelete = base.UrlDotNet(base.ThisDotNetDll, "RunProcessMethodDelete") + "&pmet_ProcessMethodid=" + pmet_ProcessMethodid;
                    base.AddUrlButton("Delete", "Delete.gif", urldelete);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&mopl_MonthPlanId=" + pmet_monthplanid + "&J=Summary";
                    url = url.Replace("Key37", "ProcessMethodid");
                    url = url + "&Key37=" + pmet_monthplanid;
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            }
            catch (Exception e)
            {
                AddError(e.Message);
            }
        }
コード例 #27
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());

            try
            {
                string     hMode               = Dispatch.EitherField("HiddenMode");
                string     cpet_competitorid   = Dispatch.EitherField("cpet_competitorid");
                int        errorflag           = 0;
                string     errormessage        = string.Empty;
                EntryGroup CpetProductNewEntry = new EntryGroup("CpetProductNewEntry");
                //CostAdjustmentProductNewEntry.Title = "Add CostAdjustmentProduct";
                Entry bred_busreportidEntry = CpetProductNewEntry.GetEntry("cppr_competitorid");
                if (bred_busreportidEntry != null)
                {
                    bred_busreportidEntry.DefaultValue = cpet_competitorid;
                    bred_busreportidEntry.ReadOnly     = true;
                }

                AddTabHead("CpetProduct");
                if (hMode == "Save")
                {
                    Record CpetProduct = new Record("CpetProduct");
                    CpetProductNewEntry.Fill(CpetProduct);
                    if (CpetProductNewEntry.Validate())
                    {
                        //QuerySelect s = new QuerySelect();
                        //string prefix = "bred" + DateTime.Now.ToString("yyyyMMdd");
                        //s.SQLCommand = "select count(*) as count from CpetProduct where bred_name like '" + prefix + "%'";
                        //s.ExecuteReader();
                        //int cnt = 0;
                        //if (!s.Eof())
                        //{
                        //    cnt = Convert.ToInt32(s.FieldValue("count"));
                        //}
                        //string code = string.Empty;
                        //code = prefix + (cnt + 1).ToString().PadLeft(4, '0');
                        //CpetProduct.SetField("bred_name", code);
                        CpetProduct.SaveChanges();
                        ////Record BusReport= FindRecord("BusReport", "cpet_competitorid=" + cpet_competitorid);
                        ////double  = BusReport.GetFieldAsDouble("");
                        ////double  =CpetProduct.GetFieldAsDouble("");
                        //// =  + ;
                        ////BusReport.SetField("", );
                        ////BusReport.SaveChanges();
                        string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&cpet_competitorid=" + cpet_competitorid + "&J=Summary";
                        url = url.Replace("Key37", "CpetProductid");
                        url = url + "&Key37=" + cpet_competitorid;
                        Dispatch.Redirect(url);
                        errorflag = -1;
                    }
                    else
                    {
                        errorflag = 1;
                    }
                }
                if (errorflag != -1)
                {
                    if (errorflag == 2)
                    {
                        AddError(errormessage);
                    }

                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    CpetProductNewEntry.GetHtmlInEditMode();
                    vpMainPanel.Add(CpetProductNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("Save", "Save.gif", sUrl);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&cpet_competitorid=" + cpet_competitorid + "&J=Summary";
                    url = url.Replace("Key37", "CpetProductid");
                    url = url + "&Key37=" + cpet_competitorid;
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            }
            catch (Exception e)
            {
                AddError(e.Message);
            }
        }
コード例 #28
0
        public override void BuildContents()
        {
            try
            {
                AddContent(HTML.Form());
                string qutaid = Dispatch.EitherField("quta_Quotationid");
                if (string.IsNullOrEmpty(qutaid))
                {
                    qutaid = Dispatch.EitherField("key58");
                }

                EntryGroup qutacompEntry = new EntryGroup("QuotationCompanyEntry");
                qutacompEntry.Title = "商机客户";
                EntryGroup qutaEntry = new EntryGroup("QuotationNewEntry");
                qutaEntry.Title = "报价信息";
                Record qutaRec = FindRecord("Quotation", "quta_Quotationid=" + qutaid);
                qutacompEntry.Fill(qutaRec);
                qutaEntry.Fill(qutaRec);
                GetTabs("Quotation", "Quotation Summary");
                string hMode = Dispatch.EitherField("HiddenMode");
                string quta_opportunityid = qutaRec.GetFieldAsString("quta_opportunityid");
                if (hMode == "Delete")
                {
                    qutaRec.DeleteRecord = true;
                    qutaRec.SaveChanges();

                    QuerySelect qs = this.GetQuery();
                    if (!string.IsNullOrEmpty(quta_opportunityid))
                    {
                        qs.SQLCommand = "Update Opportunity set oppo_qutaprice= (select sum(quta_localeamount) from Quotation where quta_deleted is null and quta_updateoppo = 'Y' and quta_opportunityid = " + quta_opportunityid + " ) where oppo_Opportunityid =" + quta_opportunityid;
                        qs.ExecuteNonQuery();
                    }
                    qs.SQLCommand = "Update QuotationDetail set qtdt_deleted = '1' where qtdt_qutaid =" + qutaid;
                    qs.ExecuteNonQuery();
                    Dispatch.Redirect(UrlDotNet(ThisDotNetDll, "RunListPage") + "&J=Quotation&T=Opportunity");
                }



                AddContent(HTML.InputHidden("HiddenMode", ""));
                qutacompEntry.GetHtmlInViewMode(qutaRec);
                qutaEntry.GetHtmlInViewMode(qutaRec);
                VerticalPanel vp = new VerticalPanel();
                vp.AddAttribute("width", "100%");
                vp.Add(qutacompEntry);
                vp.Add(qutaEntry);


                AddContent(vp);

                string url = string.Empty;

                url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&quta_Quotationid=" + qutaid + "&J=OppoTrack&T=Opportunity";
                AddSubmitButton("ConfirmDelete", "Delete.gif", "javascript:document.EntryForm.HiddenMode.value='Delete';");
                AddUrlButton("Cancel", "Cancel.gif", url);
            }
            catch (Exception error)
            {
                this.AddError(error.Message);
            }
        }
コード例 #29
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());

            try
            {
                string hMode = Dispatch.EitherField("HiddenMode");
                string code_ContractDetailId = Dispatch.EitherField("code_ContractDetailId");
                int    errorflag             = 0;
                string errormessage          = string.Empty;
                Record ContractDetail        = FindRecord("ContractDetail", "code_ContractDetailId=" + code_ContractDetailId);
                double originalcode_money    = ContractDetail.GetFieldAsDouble("code_money");
                double originalcode_qty      = ContractDetail.GetFieldAsDouble("code_qty");

                string     cont_ContractId        = ContractDetail.GetFieldAsString("code_contractid");
                EntryGroup ContractDetailNewEntry = new EntryGroup("ContractDetailNewEntry");
                ContractDetailNewEntry.Fill(ContractDetail);
                Entry IntentionOrderidEntry = ContractDetailNewEntry.GetEntry("code_contractid");
                IntentionOrderidEntry.ReadOnly = true;

                AddTabHead("ContractDetail");
                if (hMode == "Save")
                {
                    ContractDetailNewEntry.Fill(ContractDetail);
                    double code_money = ContractDetail.GetFieldAsDouble("code_money");
                    double code_qty   = ContractDetail.GetFieldAsDouble("code_qty");

                    if (ContractDetailNewEntry.Validate())
                    {
                        ContractDetail.SaveChanges();

                        Record Contract    = FindRecord("Contract", "cont_ContractId=" + cont_ContractId);
                        double cont_amount = Contract.GetFieldAsDouble("cont_amount");
                        double cont_qty    = Contract.GetFieldAsDouble("cont_qty");

                        cont_amount = cont_amount + code_money - originalcode_money;
                        cont_qty    = cont_qty + code_qty - originalcode_qty;

                        Contract.SetField("cont_amount", cont_amount);
                        Contract.SetField("cont_qty", cont_qty);
                        Contract.SaveChanges();

                        double code_targetmoney = ContractDetail.GetFieldAsDouble("code_targetmoney");
                        if (code_targetmoney == 0)
                        {
                            code_targetmoney = 1;
                        }
                        double code_targetqty = ContractDetail.GetFieldAsDouble("code_targetqty");
                        if (code_targetqty == 0)
                        {
                            code_targetqty = 1;
                        }

                        ContractDetail.SetField("code_moneyrate", code_money / code_targetmoney);
                        ContractDetail.SetField("code_qtyrate", code_qty / code_targetqty);
                        ContractDetail.SaveChanges();

                        string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&cont_ContractId=" + cont_ContractId + "&J=Summary";
                        url = url.Replace("Key37", "ContractDetailid");
                        url = url + "&Key37=" + cont_ContractId;
                        Dispatch.Redirect(url);
                        errorflag = -1;
                    }
                    else
                    {
                        errorflag = 1;
                    }
                }
                if (errorflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    ContractDetailNewEntry.GetHtmlInEditMode(ContractDetail);
                    vpMainPanel.Add(ContractDetailNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("Save", "Save.gif", sUrl);
                    string urldelete = base.UrlDotNet(base.ThisDotNetDll, "RunContractDetailDelete") + "&code_ContractDetailId=" + code_ContractDetailId;
                    base.AddUrlButton("Delete", "Delete.gif", urldelete);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&cont_ContractId=" + cont_ContractId + "&J=Summary";
                    url = url.Replace("Key37", "ContractDetailid");
                    url = url + "&Key37=" + cont_ContractId;
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            }
            catch (Exception e)
            {
                AddError(e.Message);
            }
        }
コード例 #30
0
ファイル: PlanDetailAdd.cs プロジェクト: Cross985/XXGJ2.0
        public override void BuildContents()
        {
            AddContent(HTML.Form());

            try
            {
                string     hMode              = Dispatch.EitherField("HiddenMode");
                string     mopl_MonthPlanId   = Dispatch.EitherField("mopl_MonthPlanId");
                int        errorflag          = 0;
                string     errormessage       = string.Empty;
                EntryGroup PlanDetailNewEntry = new EntryGroup("PlanDetailNewEntry");
                //CostAdjustmentProductNewEntry.Title = "Add CostAdjustmentProduct";
                Entry bred_busreportidEntry = PlanDetailNewEntry.GetEntry("plde_monthplanid");
                if (bred_busreportidEntry != null)
                {
                    bred_busreportidEntry.DefaultValue = mopl_MonthPlanId;
                    bred_busreportidEntry.ReadOnly     = true;
                }

                AddTabHead("DecoratePerson");
                if (hMode == "Save")
                {
                    Record PlanDetail = new Record("PlanDetail");
                    PlanDetailNewEntry.Fill(PlanDetail);
                    if (PlanDetailNewEntry.Validate())
                    {
                        PlanDetail.SaveChanges();
                        string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&mopl_MonthPlanId=" + mopl_MonthPlanId + "&J=Summary";
                        url = url.Replace("Key37", "DecorateCompid");
                        url = url + "&Key37=" + mopl_MonthPlanId;
                        Dispatch.Redirect(url);
                        errorflag = -1;
                    }
                    else
                    {
                        errorflag = 1;
                    }
                }
                if (errorflag != -1)
                {
                    if (errorflag == 2)
                    {
                        AddError(errormessage);
                    }

                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    PlanDetailNewEntry.GetHtmlInEditMode();
                    vpMainPanel.Add(PlanDetailNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("Save", "Save.gif", sUrl);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&mopl_MonthPlanId=" + mopl_MonthPlanId + "&J=Summary";
                    url = url.Replace("Key37", "DecoratePersonid");
                    url = url + "&Key37=" + mopl_MonthPlanId;
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            }
            catch (Exception e)
            {
                AddError(e.Message);
            }
        }
コード例 #31
0
        public override void BuildContents()
        {
            AddContent(HTML.Form());

            try {
                string hMode             = Dispatch.EitherField("HiddenMode");
                string mapl_MarActPlanId = Dispatch.EitherField("mapl_MarActPlanId");
                int    errorflag         = 0;
                string errormessage      = string.Empty;
                Record MarActPlan        = FindRecord("MarActPlan", "mapl_MarActPlanId=" + mapl_MarActPlanId);
                //string mapl_opportunityid = MarActPlan.GetFieldAsString("mapl_opportunityid");
                EntryGroup MarActPlanNewEntry = new EntryGroup("MarActPlanNewEntry");
                MarActPlanNewEntry.Fill(MarActPlan);
                //Entry mapl_opportunityidEntry = MarActPlanNewEntry.GetEntry("mapl_opportunityid");

                //mapl_opportunityidEntry.ReadOnly = true;

                //AddTabHead("CpetProduct");
                GetTabs("MarActPlan", "Summary");
                if (hMode == "Save")
                {
                    ////double original =CpetProduct.GetFieldAsDouble("");
                    MarActPlanNewEntry.Fill(MarActPlan);
                    ////double  =CpetProduct.GetFieldAsDouble("");

                    if (MarActPlanNewEntry.Validate())
                    {
                        MarActPlan.SaveChanges();

                        ////Record BusReport= FindRecord("BusReport", "cpet_competitorid=" + cpet_competitorid);
                        ////double  = BusReport.GetFieldAsDouble("");
                        //// =  + - original;
                        ////BusReport.SetField("", );
                        ////BusReport.SaveChanges();

                        string url = UrlDotNet(ThisDotNetDll, "RunDataPage");
                        Dispatch.Redirect(url);
                        errorflag = -1;
                    }
                    else
                    {
                        errorflag = 1;
                    }
                }
                if (errorflag != -1)
                {
                    AddContent(HTML.InputHidden("HiddenMode", ""));
                    VerticalPanel vpMainPanel = new VerticalPanel();
                    vpMainPanel.AddAttribute("width", "100%");
                    string sUrl = "javascript:document.EntryForm.HiddenMode.value='Save';";
                    MarActPlanNewEntry.GetHtmlInEditMode(MarActPlan);
                    vpMainPanel.Add(MarActPlanNewEntry);
                    AddContent(vpMainPanel);
                    AddSubmitButton("Save", "Save.gif", sUrl);
                    string urldelete = base.UrlDotNet(base.ThisDotNetDll, "RunDataPageDelete") + "&mapl_MarActPlanId=" + mapl_MarActPlanId;
                    base.AddUrlButton("Delete", "Delete.gif", urldelete);
                    string url = UrlDotNet(ThisDotNetDll, "RunDataPage") + "&mapl_MarActPlanId=" + mapl_MarActPlanId + "&J=Summary";
                    AddUrlButton("Cancel", "cancel.gif", url);
                }
            } catch (Exception e) {
                AddError(e.Message);
            }
        }