private void LoadRecordMemoData()
{
try
{
if (RecordInfoItem == null)
{
return;
}
WebRequest webRequest = new WebRequest();
webRequest.Code = (int)S3103Codes.GetRecordMemoList;
webRequest.Session = CurrentApp.Session;
webRequest.ListData.Add(RecordInfoItem.RecoredReference.ToString());
Service31031Client client = new Service31031Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session),
WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service31031"));
//WebHelper.SetServiceClient(client);
WebReturn webReturn = client.UMPTaskOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
return;
}
mListRecordMemos.Clear();
for (int i = 0; i < webReturn.ListData.Count; i++)
{
OperationReturn optReturn = XMLHelper.DeserializeObject <RecordMemoInfo>(webReturn.ListData[i]);
if (!optReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message));
return;
}
RecordMemoInfo info = optReturn.Data as RecordMemoInfo;
if (info != null)
{
RecordMemoItem item = new RecordMemoItem(info);
if (item.UserID == CurrentApp.Session.UserID)
{
mThisRecordMemo = item;
}
mListRecordMemos.Add(item);
}
}
}
catch (Exception ex)
{
ShowException(ex.Message);
}
}
private void SaveRecordMemo()
{
try
{
if (string.IsNullOrEmpty(TxtMemoContent.Text))
{
ShowException(CurrentApp.GetLanguageInfo("3103T00130", "Memo content is empty."));
return;
}
RecordMemoItem item = mListRecordMemos.FirstOrDefault(m => m.UserID == CurrentApp.Session.UserID);
if (item == null)
{
RecordMemoInfo info = new RecordMemoInfo();
info.ID = 0;
info.RecordSerialID = RecordInfoItem.RecoredReference;
info.UserID = CurrentApp.Session.UserID;
info.MemoTime = DateTime.Now;
info.Content = TxtMemoContent.Text;
info.State = "1";
info.LastModifyUserID = CurrentApp.Session.UserID;
info.LastModifyTime = DateTime.Now;
info.Source = "U";
item = new RecordMemoItem(info);
}
else
{
RecordMemoInfo info = item.RecordMemoInfo;
info.Content = TxtMemoContent.Text;
info.LastModifyUserID = CurrentApp.Session.UserID;
info.LastModifyTime = DateTime.Now;
}
OperationReturn optReturn = XMLHelper.SeriallizeObject(item.RecordMemoInfo);
if (!optReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message));
return;
}
string strMemoInfo = optReturn.Data.ToString();
WebRequest webRequest = new WebRequest();
webRequest.Session = CurrentApp.Session;
webRequest.Code = (int)S3103Codes.SaveRecordMemoInfo;
webRequest.ListData.Add(RecordInfoItem.RecoredReference.ToString());
webRequest.ListData.Add(CurrentApp.Session.UserID.ToString());
webRequest.ListData.Add(strMemoInfo);
Service31031Client client = new Service31031Client(
WebHelper.CreateBasicHttpBinding(CurrentApp.Session),
WebHelper.CreateEndpointAddress(
CurrentApp.Session.AppServerInfo,
"Service31031"));
//WebHelper.SetServiceClient(client);
WebReturn webReturn = client.UMPTaskOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
CurrentApp.WriteOperationLog(S3103Consts.OPT_MEMORECORD.ToString(), ConstValue.OPT_RESULT_FAIL, "");
ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
return;
}
#region 写操作日志
string strLog = string.Format("{0} {1}", Utils.FormatOptLogString("3103T00025"), RecordInfoItem.RecoredReference);
CurrentApp.WriteOperationLog(S3103Consts.OPT_MEMORECORD.ToString(), ConstValue.OPT_RESULT_SUCCESS, strLog);
#endregion
CurrentApp.WriteLog(string.Format("Save RecordMemo end.\t{0}", webReturn.Data));
ShowInformation(CurrentApp.GetLanguageInfo("3103T00129", "Save RecordMemo end."));
}
catch (Exception ex)
{
ShowException(ex.Message);
}
}
//现在我新建一个方法 将备注存到T_21_001的C072字段里面
private void SetMemoInfoToT_21_001()
{
try
{
//这个是存完备注之后，在到备注表里面读取最后的备注再存到下面这里面
List <RecordMemoItem> mListRecordMemos_new;
mListRecordMemos_new = new List <RecordMemoItem>();
if (RecordInfoItem == null)
{
return;
}
WebRequest webRequest = new WebRequest();
webRequest.Code = (int)S3102Codes.GetRecordMemoList;
webRequest.Session = CurrentApp.Session;
webRequest.ListData.Add(RecordInfoItem.SerialID.ToString());
Service31021Client client = new Service31021Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session),
WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service31021"));
WebReturn webReturn = client.DoOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
return;
}
mListRecordMemos_new.Clear();
for (int i = 0; i < webReturn.ListData.Count; i++)
{
OperationReturn optReturn = XMLHelper.DeserializeObject <RecordMemoInfo>(webReturn.ListData[i]);
if (!optReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message));
return;
}
RecordMemoInfo info = optReturn.Data as RecordMemoInfo;
if (info != null)
{
RecordMemoItem item = new RecordMemoItem(info);
mListRecordMemos_new.Add(item);
}
}
string TempMemo = string.Empty;
for (int i = 0; i < mListRecordMemos_new.Count; i++)
{
if (TempMemo.Length > 500)
{
break;
}
if (i < mListRecordMemos_new.Count - 1)
{
TempMemo += mListRecordMemos_new[i].UserID + ConstValue.SPLITER_CHAR_2 + mListRecordMemos_new[i].Content + ConstValue.SPLITER_CHAR;
}
else
{
TempMemo += mListRecordMemos_new[i].UserID + ConstValue.SPLITER_CHAR_2 + mListRecordMemos_new[i].Content;
}
}
//下面是获得记录表的名字（考虑到分表的情况）
QueryStateInfo queryStateInfo = new QueryStateInfo();
queryStateInfo.RowID = 0;
var tableInfo =
CurrentApp.Session.ListPartitionTables.FirstOrDefault(
t => t.TableName == ConstValue.TABLE_NAME_RECORD && t.PartType == TablePartType.DatetimeRange);
if (tableInfo == null)
{
tableInfo =
CurrentApp.Session.ListPartitionTables.FirstOrDefault(
t => t.TableName == ConstValue.TABLE_NAME_RECORD && t.PartType == TablePartType.VoiceID);
if (tableInfo == null)
{
queryStateInfo.TableName = string.Format("{0}_{1}", ConstValue.TABLE_NAME_RECORD,
CurrentApp.Session.RentInfo.Token);
}
else
{
//按录音服务器查询,没有实现，暂时还是按普通方式来
queryStateInfo.TableName = string.Format("{0}_{1}", ConstValue.TABLE_NAME_RECORD,
CurrentApp.Session.RentInfo.Token);
}
}
else
{
DateTime baseTime = RecordInfoItem.StartRecordTime;
string partTable;
partTable = baseTime.ToString("yyMM");
queryStateInfo.TableName = string.Format("{0}_{1}_{2}", ConstValue.TABLE_NAME_RECORD,
CurrentApp.Session.RentInfo.Token, partTable);
}
SetMemoInfoToT_21_001(RecordInfoItem.SerialID.ToString(), TempMemo, queryStateInfo.TableName);
}
catch (Exception ex)
{
ShowException(ex.Message);
}
}
