Example #1
0
        public void AddRead(SurveyQuota surveyQuota_0)
        {
            string string_ = string.Format(GClass0.smethod_0("\u0011ęȅ̐Іԇٲܘࠞछਁ୭టാุ༿ိᄾሗጰᐫᔷᘣᝩ᠐ᥭᩱ᭷ᱹᵸṮὦⁱⅳ√⍶⑸╺♷❿⡤⥰⩧⭩Ⰰ⵻⹫⽮ねㅸ㉯㍡㐈㕲㙷㝤㡳㥋㩗㭒㱒㵄㹔㽘䁕䅒䈺䍄䑁䕖䙁䝅䡙䥀䩀䭒䱘䵂乞佅偍儫剏卋告商噐坞塉妱媺宸岤巗庹徶悼憲拚掶撻斷暷枮梤榪檶殹泀涸溫澤炸熫犣玺璫疵皧瞳磌禌窟箐粌綗纟羆肌膖芄莒蒑薇蛾螂袑覂語讁貉趔躈辈邋醌銓鎕铨閐隃鞌颐駳髻鯢鳨鷴黮鿸ꃴꆛꋥꏴꓹꗣ꛾ꟴ꣯ꧩꫧꯣ곥그껢꾅냻뇦닫돵듨뗦뛽럳룵맑뫐믔볒뷜뺶뿊샙쇚싆쏙쓑엌움쟔죑짃쪢쯄쳟췔컌쿜탄퇋튪폖퓅헎훒ퟍ\ud8c5\ud920\uda3c\udb3c\udc30\udd3a\ude34\udf3a濫啕ﭱﱻﴠ﹫D\u007fŻɱ̮ѦԮٵݽࡷऴ੽ର౫൧๭༲ၼᄺቡ፩ᐿᕶᘿ᝭ᡧ᥄ᨈᭀᰛᴗḝὂ‏⅊∑⌙⑏┋♏✝⡋⤖⩓⬁ⱗⴚ⸚⽔〄ㅜ㈗㌔㑙㔏㙙㜐㠒㥢㨲㭦㰭㴨㹧㼵䁣䄦䈢䍨䐸䔴䙩䜠䠥䥲䨩䬡䱷䴺丼佴値儠剽匴吳啾嘥在"), new object[]
            {
                surveyQuota_0.PROJECT_ID,
                surveyQuota_0.CLIENT_ID,
                surveyQuota_0.PAGE_ID,
                surveyQuota_0.QUESTION_NAME,
                surveyQuota_0.QUESTION_TITLE,
                surveyQuota_0.INNER_INDEX,
                surveyQuota_0.CODE,
                surveyQuota_0.CODE_TEXT,
                surveyQuota_0.SAMPLE_OVER,
                surveyQuota_0.SAMPLE_TARGET,
                surveyQuota_0.SAMPLE_BACKUP,
                surveyQuota_0.SAMPLE_TOTAL,
                surveyQuota_0.SAMPLE_FINISH,
                surveyQuota_0.SAMPLE_RUNNING,
                surveyQuota_0.SAMPLE_REAL,
                surveyQuota_0.IS_FULL,
                surveyQuota_0.SAMPLE_BALANCE,
                surveyQuota_0.MODIFY_DATE
            });

            this.dbprovider_1.ExecuteNonQuery(string_);
        }
Example #2
0
        public SurveyQuota GetBySql(string string_0)
        {
            IDataReader dataReader  = this.dbprovider_0.ExecuteReader(string_0);
            SurveyQuota surveyQuota = new SurveyQuota();

            using (dataReader)
            {
                while (dataReader.Read())
                {
                    surveyQuota.ID             = Convert.ToInt32(dataReader[GClass0.smethod_0("KŅ")]);
                    surveyQuota.PROJECT_ID     = dataReader[GClass0.smethod_0("Zśɇ͍уՆِݜࡋॅ")].ToString();
                    surveyQuota.CLIENT_ID      = dataReader[GClass0.smethod_0("JńɎ̓ыՐٜ݋ࡅ")].ToString();
                    surveyQuota.PAGE_ID        = dataReader[GClass0.smethod_0("WŇɂ́ќՋم")].ToString();
                    surveyQuota.QUESTION_NAME  = dataReader[GClass0.smethod_0("\\řɎ͙ѝՁو݈࡚ॊੂ୏ౄ")].ToString();
                    surveyQuota.QUESTION_TITLE = dataReader[GClass0.smethod_0("_Řɉ͘ўՀه੍࡙݉॑ୗ౎ൄ")].ToString();
                    surveyQuota.INNER_INDEX    = Convert.ToInt32(dataReader[GClass0.smethod_0("Bńɇ͍ѕՙٌ݊ࡇेਖ਼")]);
                    surveyQuota.CODE           = dataReader["CODE"].ToString();
                    surveyQuota.CODE_TEXT      = dataReader["CODE_TEXT"].ToString();
                    surveyQuota.SAMPLE_OVER    = Convert.ToInt32(dataReader[GClass0.smethod_0("XŋɄ͘ыՃٚ݋ࡕे੓")]);
                    surveyQuota.SAMPLE_TARGET  = Convert.ToInt32(dataReader[GClass0.smethod_0("^ōɆ͚хՍ٘ݒࡄॖ੄େౕ")]);
                    surveyQuota.SAMPLE_BACKUP  = Convert.ToInt32(dataReader[GClass0.smethod_0("^ōɆ͚хՍ݄٘ࡄेੈୗ౑")]);
                    surveyQuota.SAMPLE_TOTAL   = Convert.ToInt32(dataReader[GClass0.smethod_0("_Ŋɇ͙фՂٙݑࡋॗ੃୍")]);
                    surveyQuota.SAMPLE_FINISH  = Convert.ToInt32(dataReader[GClass0.smethod_0("^ōɆ͚хՍ٘݀ࡌॊ੊୑౉")]);
                    surveyQuota.SAMPLE_RUNNING = Convert.ToInt32(dataReader[GClass0.smethod_0("]ŌɁ͛цՌٗݕࡓो੊୊ౌെ")]);
                    surveyQuota.SAMPLE_REAL    = Convert.ToInt32(dataReader[GClass0.smethod_0("XŋɄ͘ыՃٚݖࡆृ੍")]);
                    surveyQuota.IS_FULL        = dataReader[GClass0.smethod_0("Nŕɚ͂іՎٍ")].ToString();
                    surveyQuota.SAMPLE_BALANCE = Convert.ToInt32(dataReader[GClass0.smethod_0("]ŌɁ͛цՌٗ݅ࡇॉ੅୍ుൄ")]);
                    surveyQuota.MODIFY_DATE    = new DateTime?(Convert.ToDateTime(dataReader[GClass0.smethod_0("FŅɍ́с՟ٚ݀ࡂॖ੄")].ToString()));
                }
            }
            return(surveyQuota);
        }
Example #3
0
        public void Update(SurveyQuota surveyQuota_0)
        {
            string string_ = string.Format(GClass0.smethod_0("×Ǒ˄̾ЪԸٜܨࠏऋ਎଒ఏതก༜ဆᄐቐጼᐫᔹᙌ᜻ᠸᤦᨢᬢᰥᴱḻἪ…⅁≝⍿⑹┦♭✦⡽⥵⨛⬛Ⱏⴐ⸚⼇」ㄘ㈔㍯㑳㕭㙫㜰㡸㤴㩯㭫㰖㴄㸃㼆䀝䄈䈄䌟䐃䔝䘛䝀䠉䥄䨟䬛䱧䵠乱你偦典剿卡呱啣噭坦塯変娕嬇封嵞帐彞怅愍扱捊摛敎晈杒桕楗橇歃江流湘潖瀲焬爰猨瑵甸癱眬砦祀穆等籃絗繛罊职腅艅莧蓞藀蛜螀裌覄諔讴貹趱躱迓郏金鋗鎔铙閐雋韇颩馦骬鮢鲹鶱麡龻ꂶꇁꋝꏿꓹꖦꛤꞦꣽ꧵ꪋꮖ겛궅꺘꾖낍놞늆뎊뒜뗭뛱럫뢱맰몵믫법분뺉뾓삎솄슟쏫쓿엯웻쟾죮즙쪅쮗쳍춄캄쿎킞퇢틱폢퓾헡훩ퟴ\ud8e8\ud9e8\udaeb\udbec\udcf3\uddf5\ude84\udf9e殮﫛﯆ﳋ﷕ﻈᅥÝLJˉ̱зԮشݛࡇख़ਃ୆౅ഈ๘༠ဳᄼሠጣᐫᔲᘾ᜾ᠤᤧᨡᬩᰡᵅṙὃ’⅐≔⌢⑲┎☝✖⠊⤕⨝⬈Ⰴⴐ⸕⼟ひㅬ㉰㌴㑿㕸㘱㝧㠃㤚㨗㬁㰓㴉㸈㽣䁿䅡䉧䍄䐏䔋䙁䜜䠖䥪䩹䭺䱦䵹乱佬偰兰剼卮呠啮噩國堗変婓嬖少嵘师彮恭慥扩捙摇敂晘杚桎楜樸欪氶洲湯漢瀪煬爷猯瑙畅癉睙硏礩穁筃簦紸縤罸耲腼"), new object[]
            {
                surveyQuota_0.ID,
                surveyQuota_0.PROJECT_ID,
                surveyQuota_0.CLIENT_ID,
                surveyQuota_0.PAGE_ID,
                surveyQuota_0.QUESTION_NAME,
                surveyQuota_0.QUESTION_TITLE,
                surveyQuota_0.INNER_INDEX,
                surveyQuota_0.CODE,
                surveyQuota_0.CODE_TEXT,
                surveyQuota_0.SAMPLE_OVER,
                surveyQuota_0.SAMPLE_TARGET,
                surveyQuota_0.SAMPLE_BACKUP,
                surveyQuota_0.SAMPLE_TOTAL,
                surveyQuota_0.SAMPLE_FINISH,
                surveyQuota_0.SAMPLE_RUNNING,
                surveyQuota_0.SAMPLE_REAL,
                surveyQuota_0.IS_FULL,
                surveyQuota_0.SAMPLE_BALANCE,
                surveyQuota_0.MODIFY_DATE
            });

            this.dbprovider_0.ExecuteNonQuery(string_);
        }
Example #4
0
        public bool CheckQuota(string string_0, string string_1, janswer janswer_0, out string string_2)
        {
            bool flag = false;

            string_2 = "";
            if (this.oSurveyQuotaDal.ExistsByQName(janswer_0.questionname, janswer_0.code))
            {
                string      string_3 = string.Format(GClass0.smethod_0("0ħȭ̥ќՊ؝ܖࠛड़ੋୗౚഖ๦ཁ၁ᅄቔፉᑾᕛᙂ᝘ᡊᤊᩞᭀ᱂ᵔṀἄ⁲ⅷ≤⍳⑋╗♒❒⡄⥔⩘⭕ⱒⴶ⸨⼳とㄢ㉬㌷㐯㕯㙣㝨㠫㥉㩆㭌㱂㴻㸢㽿䀲䅿䈦"), janswer_0.questionname, janswer_0.code);
                SurveyQuota bySql    = this.oSurveyQuotaDal.GetBySql(string_3);
                string_2 = bySql.QUESTION_TITLE;
                int num  = bySql.SAMPLE_TARGET + bySql.SAMPLE_BACKUP - bySql.SAMPLE_FINISH;
                int num2 = bySql.SAMPLE_TARGET + bySql.SAMPLE_BACKUP - (bySql.SAMPLE_FINISH + bySql.SAMPLE_RUNNING);
                if (bySql.SAMPLE_OVER == 1 && num <= 0)
                {
                    flag = true;
                }
                if (bySql.SAMPLE_OVER == 2 && num2 <= 0)
                {
                    flag = true;
                }
                if (!flag)
                {
                    SurveyQuotaAnswer surveyQuotaAnswer = new SurveyQuotaAnswer();
                    surveyQuotaAnswer.SURVEY_ID     = string_0;
                    surveyQuotaAnswer.SURVEY_GUID   = string_1;
                    surveyQuotaAnswer.QUESTION_NAME = bySql.QUESTION_NAME;
                    surveyQuotaAnswer.CODE          = bySql.CODE;
                    surveyQuotaAnswer.IS_FINISH     = 0;
                    int num3 = this.oSurveyQuotaAnswerDal.AddOne(surveyQuotaAnswer);
                    if (num3 == 0)
                    {
                        bySql.SAMPLE_RUNNING++;
                    }
                    if (bySql.SAMPLE_OVER == 1)
                    {
                        bySql.SAMPLE_REAL = bySql.SAMPLE_FINISH;
                    }
                    if (bySql.SAMPLE_OVER == 2)
                    {
                        bySql.SAMPLE_REAL = bySql.SAMPLE_FINISH + bySql.SAMPLE_RUNNING;
                    }
                    bySql.SAMPLE_BALANCE = bySql.SAMPLE_TOTAL - bySql.SAMPLE_REAL;
                    if (bySql.SAMPLE_BALANCE > 0)
                    {
                        bySql.IS_FULL = GClass0.smethod_0("吧");
                    }
                    else
                    {
                        bySql.IS_FULL = GClass0.smethod_0("昮");
                    }
                    this.oSurveyQuotaDal.Update(bySql);
                }
            }
            return(flag);
        }
Example #5
0
 public void AddOne(SurveyQuota surveyQuota_0)
 {
     if (this.Exists(surveyQuota_0.ID))
     {
         this.Update(surveyQuota_0);
     }
     else
     {
         this.Add(surveyQuota_0);
     }
 }
Example #6
0
 public void CalcQuotaOne(SurveyQuota surveyQuota_0)
 {
     surveyQuota_0.SAMPLE_TOTAL   = surveyQuota_0.SAMPLE_TARGET + surveyQuota_0.SAMPLE_BACKUP;
     surveyQuota_0.SAMPLE_FINISH  = this.oSurveyQuotaAnswerDal.GetSumByModel(1, surveyQuota_0.QUESTION_NAME, surveyQuota_0.CODE);
     surveyQuota_0.SAMPLE_RUNNING = this.oSurveyQuotaAnswerDal.GetSumByModel(0, surveyQuota_0.QUESTION_NAME, surveyQuota_0.CODE);
     if (surveyQuota_0.SAMPLE_OVER == 1)
     {
         surveyQuota_0.SAMPLE_REAL = surveyQuota_0.SAMPLE_FINISH;
     }
     if (surveyQuota_0.SAMPLE_OVER == 2)
     {
         surveyQuota_0.SAMPLE_REAL = surveyQuota_0.SAMPLE_FINISH + surveyQuota_0.SAMPLE_RUNNING;
     }
     surveyQuota_0.SAMPLE_BALANCE = surveyQuota_0.SAMPLE_TOTAL - surveyQuota_0.SAMPLE_REAL;
     if (surveyQuota_0.SAMPLE_BALANCE > 0)
     {
         surveyQuota_0.IS_FULL = GClass0.smethod_0("吧");
     }
     else
     {
         surveyQuota_0.IS_FULL = GClass0.smethod_0("昮");
     }
     this.oSurveyQuotaDal.Update(surveyQuota_0);
 }
Example #7
0
        public void Delete(SurveyQuota surveyQuota_0)
        {
            string string_ = string.Format(GClass0.smethod_0("ašɯͧѵեؿݘࡏ॓੖଺ొ൭๥འၰᅭቂ፧ᑾᕤ᙮ᜮᡚ᥄ᩎ᭘᱌ᴨṎὂ‥ℹ≸⌲⑼"), surveyQuota_0.ID);

            this.dbprovider_0.ExecuteNonQuery(string_);
        }