/// <summary>
/// 更新指定短信的数据
/// </summary>
/// <param name="shortMsgID">短信ID</param>
/// <param name="shortMsg">更新后的短信内容</param>
public void Update(string shortMsgID, View_Task_ShortMessage shortMsg)
{
TaskManagementDataContext ctx = CommentParameter.TaskManagementDataContext;
var result = from r in ctx.Task_ShortMessage
where r.ID == shortMsgID
select r;
Task_ShortMessage msg = result.Single();
msg.Status = shortMsg.状态;
msg.Content = shortMsg.短信内容;
if (GlobalObject.GeneralFunction.IsNullOrEmpty(shortMsg.接收人手机号) || !StapleFunction.IsHandset(shortMsg.接收人手机号))
{
throw new Exception(string.Format("不正确的手机号码：{0}", shortMsg.接收人手机号));
}
msg.MobileNo = shortMsg.接收人手机号;
msg.Receiver = shortMsg.接收人姓名;
msg.SendTime = shortMsg.发送时间;
msg.Remark = shortMsg.备注;
msg.CreateTime = ServerTime.Time;
msg.ShortMsgTypeID = GetShortMsgType(shortMsg.短信类别).TypeID;
ctx.SubmitChanges();
}
/// <summary>
/// 添加短信
/// </summary>
/// <param name="lstShortMsg">短信列表</param>
/// <param name="status">短信状态</param>
public void Add(List <View_Task_ShortMessage> lstShortMsg, ShortMessageStatus status)
{
//signing messages
TaskManagementDataContext ctx = CommentParameter.TaskManagementDataContext;
Task_ShortMessage shortMsg = new Task_ShortMessage();
DateTime date = ServerTime.Time;
var result = from r in ctx.Task_ShortMessage
where r.ID.Substring(3, 4) == date.Year.ToString()
select r;
int maxValue = 1;
if (result.Count() > 0)
{
maxValue += (from r in ctx.Task_ShortMessage
where r.ID.Substring(3, 4) == date.Year.ToString()
select Convert.ToInt32(r.ID.Substring(9))).Max();
}
foreach (var item in lstShortMsg)
{
Task_ShortMessage addItem = new Task_ShortMessage();
// HYX : 短信项
addItem.ID = string.Format("SMX{0:D4}{1:D2}{2:D5}", date.Year, date.Month, maxValue);
maxValue++;
addItem.CreaterID = BasicInfo.LoginID;
addItem.CreateTime = date;
addItem.Receiver = item.接收人姓名;
if (GlobalObject.GeneralFunction.IsNullOrEmpty(item.接收人手机号) || !StapleFunction.IsHandset(item.接收人手机号))
{
throw new Exception(string.Format("不正确的手机号码：{0}", item.接收人手机号));
}
addItem.MobileNo = item.接收人手机号;
addItem.Content = item.短信内容;
addItem.SendTime = item.发送时间;
addItem.Status = status.ToString();
addItem.Remark = item.备注;
addItem.ShortMsgTypeID = GetShortMsgType(item.短信类别).TypeID;
ctx.Task_ShortMessage.InsertOnSubmit(addItem);
}
ctx.SubmitChanges();
}
