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);
}
}
