public void Add(SurveyLog surveyLog_0) { string string_ = string.Format(GClass0.smethod_0("&ĠȾ̩йԾىܡࠩलਪୄరഗณ༖်ᄧሑጳᐼᕲᘕ᠐ᤉᨁᬍᰃᴗṽἜ\u2000℉−⌁␎┙☚✉⠀⤃⩩⬈Ⰼⴅ⸞⼄まㅪ㉸㌐㑨㕯㙫㝮㡲㥯㩪㭽㱷㴞㹧㽵䁽䅽䉤䍣䑥䕵䙠䝬䠎䤆䩳䭥䱯䵷乤佳倷儹剦匬呦唽嘵圿塬大婨嬳尿崵幪弢恲愩戡挫摰改晴术栫椡橾欰汾津渨"), new object[] { surveyLog_0.LOG_TYPE, surveyLog_0.LOG_MESSAGE, surveyLog_0.LOG_DATE, surveyLog_0.SURVEY_ID, surveyLog_0.VERSION_ID }); this.dbprovider_0.ExecuteNonQuery(string_); }
public void Update(SurveyLog surveyLog_0) { string string_ = string.Format(GClass0.smethod_0("+ĭȸ̺ЮԼ٘ܤࠃइਂଖఋഽฟ༈၎ᄾሩጿᑊᔥᘧᜠᠹᤱᨽᬳᰧᵁṝ⁹Ω≭⌦⑽╵☔✘⠑⤊⨙⬖Ⰱⴂ⸑⼈》ㅭ㉱㍫㑭㔲㙺㜺㡡㥩㨈㬌㰅㴞㸄㽾䁪䅸䈜䌆䐚䔞䙃䜄䡋䤒䨘䭠䱧䵣书佪偷兲剥卯吊唔嘈圀塝夑婙嬄導嵷幥彍恍慔打捕摅敐晜朷栫椵樳歨氧浬渷漯灙煅牉獙瑏甩癁睃砦礸稤筸簲絼"), new object[] { surveyLog_0.ID, surveyLog_0.LOG_TYPE, surveyLog_0.LOG_MESSAGE, surveyLog_0.LOG_DATE, surveyLog_0.SURVEY_ID, surveyLog_0.VERSION_ID }); this.dbprovider_0.ExecuteNonQuery(string_); }
public SurveyLog GetBySql(string string_0) { IDataReader dataReader = this.dbprovider_0.ExecuteReader(string_0); SurveyLog surveyLog = new SurveyLog(); using (dataReader) { while (dataReader.Read()) { surveyLog.ID = Convert.ToInt32(dataReader[GClass0.smethod_0("KŅ")]); surveyLog.LOG_TYPE = dataReader[GClass0.smethod_0("DňɁ͚ѐ՚ْ݄")].ToString(); surveyLog.LOG_MESSAGE = dataReader[GClass0.smethod_0("GŅɎ͗ъՃٖݗࡂॅ")].ToString(); surveyLog.LOG_DATE = new DateTime?(Convert.ToDateTime(dataReader[GClass0.smethod_0("DňɁ͚рՂٖ݄")].ToString())); surveyLog.SURVEY_ID = dataReader["SURVEY_ID"].ToString(); surveyLog.VERSION_ID = dataReader[GClass0.smethod_0("\\Ōɚ͔яՊيݜࡋॅ")].ToString(); } } return(surveyLog); }
public void Delete(SurveyLog surveyLog_0) { string string_ = string.Format(GClass0.smethod_0("gŧɭͥы՛ؽݚࡉॕସౄൣརၶᅫቝᑨᔮᙚᝄᡎᥘᩌᬨᱎᵂḥἹ⁸Ⅎ≼"), surveyLog_0.ID); this.dbprovider_0.ExecuteNonQuery(string_); }
/// <summary> /// 作者:Vincen /// 时间:2014.01.03 /// 描述:提交问卷 /// </summary> /// <param name="userId"></param> /// <param name="surveyId"></param> /// <param name="keyInfo">格式:1|4;2|3,4; --> 题编号|项编号,项编号;题编号|项编号,项编号;</param> /// <param name="txtInfo">格式:1|2✈内容1☂ 2|2✈内容2☂ --> 题编号1|2✈内容1☂题编号2|3✈内容2</param> /// <returns></returns> public static bool CreateSurveyLog(int userId, int surveyId, string keyInfo, string txtInfo) { using (var edb = new EmeEntities()) { keyInfo = keyInfo.Trim().Trim(';'); var surveyitems = keyInfo.Split(';'); var surveyitems2 = txtInfo.Split('☂'); using (var tran = new TransactionScope()) { try { //参与人数累积 var surveyModle = edb.Survey.SingleOrDefault(p => p.Id == surveyId); if (surveyModle != null) { surveyModle.Votes = surveyModle.Votes + 1; edb.Entry(surveyModle).State = EntityState.Modified; } var log = new SurveyLog() { UserId = userId, SurveyId = surveyId, Status = ConvertEnum.StatusTypeForActive, UpdateBy = userId, UpdateTime = DateTime.Now, CreateBy = userId, CreateTime = DateTime.Now }; edb.Entry(log).State = EntityState.Added; edb.SaveChanges(); foreach (var surveyitem in surveyitems) { if (surveyitem == "") { continue; } var temp = surveyitem.Trim().Trim(',').Trim(';').Trim('|').Split('|'); var surveyItemId = CommonHelper.To<int>(temp[0]); var itemOptions = temp[1].Split(','); foreach (var itemOption in itemOptions) { var detail = new SurveyLogDetail() { SurveyLogId = log.Id, SurveyItemId = surveyItemId, SurveyItemOptionId = CommonHelper.To<int>(itemOption), Status = ConvertEnum.StatusTypeForActive, CreateBy = userId, CreateTime = DateTime.Now }; edb.Entry(detail).State = EntityState.Added; } } foreach (var surveyitem in surveyitems2) { if (surveyitem == "") { continue; } var temp = surveyitem.Trim().Trim('✈').Trim('☂').Trim('|').Split('✈'); var surveyItemList = temp[0].Split('|'); var surveyItemId = CommonHelper.To<int>(surveyItemList[0]); var detail = new SurveyLogDetail() { SurveyLogId = log.Id, SurveyItemId = surveyItemId, SurveyItemOptionId = CommonHelper.To<int>(surveyItemList[1]), Remark = temp[1], Status = ConvertEnum.StatusTypeForActive, CreateBy = userId, CreateTime = DateTime.Now }; edb.Entry(detail).State = EntityState.Added; } var result = edb.SaveChanges() > 0; tran.Complete(); return result; } catch (Exception ex) { tran.Dispose(); Common.MSMQ.QueueManager.AddExceptionLog(new ExceptionLogs() { ExceptionType = CommonHelper.To<int>(ExceptionType.Message), Message = string.Format("SurveyBLL-CreateSurveyLog:{0};{1};{2}", ex.Message, ex.InnerException, ex.HelpLink), IsTreat = false, CreateBy = userId, CreateTime = DateTime.Now }); return false; } } } }