public object GetEmailSendInit(string userid) { var tran = Utility.Database.BeginDbTransaction(); var data = new B_Email_One_Svc.GetDataModel(); try { StringBuilder sqlStr = new StringBuilder(); sqlStr.AppendFormat(@"select {0} from B_Email a where Mail_Deleted=0 and whosEmailId='{1}' and MailDocumentType='fajian' order by Mail_SendDate desc ", FieldList, userid); DataSet MailDataSet = Utility.Database.ExcuteDataSet(sqlStr.ToString(), tran); string jsonData = JsonConvert.SerializeObject(MailDataSet.Tables[0]); data.dataList = (List<B_Email>)JsonConvert.DeserializeObject(jsonData, typeof(List<B_Email>)); data.dataEdit = new B_Email(); data.dataCount = new CounntModel(); data.dataCount = GetUnReadEmailCount(userid, tran, "fajian"); data.emailMarkModel = new B_OA_Email_Mark(); data.emailDocumentModel = new B_EmailDocument(); Utility.Database.Commit(tran); return new { data = data }; } catch (Exception e) { Utility.Database.Rollback(tran); throw (new Exception("获取数据失败!", e)); } }
public string GetEmailSendInit(string userid) { var tran = Utility.Database.BeginDbTransaction(); var data = new B_Email_One_Svc.GetDataModel(); try { StringBuilder sqlStr = new StringBuilder(); sqlStr.AppendFormat(@"select {0} from B_Email a where Mail_Deleted=0 and whosEmailId='{1}' and MailDocumentType='fajian' order by Mail_SendDate desc ", FieldList, userid); DataSet MailDataSet = Utility.Database.ExcuteDataSet(sqlStr.ToString(), tran); string jsonData = JsonConvert.SerializeObject(MailDataSet.Tables[0]); data.dataList = (List<B_Email>)JsonConvert.DeserializeObject(jsonData, typeof(List<B_Email>)); data.dataEdit = new B_Email(); data.dataCount = new CounntModel(); data.dataCount = GetUnReadEmailCount(userid, tran, "fajian"); Utility.Database.Commit(tran); return JsonConvert.SerializeObject(data);//将对象转为json字符串并返回到客户端 } catch (Exception e) { Utility.Database.Rollback(tran); return Utility.JsonMsg(false, "数据加载失败!异常信息: " + e.Message); } }