public static string AddNotice(string Noticetstr)
{
string str = string.Empty;
try
{
AchieveDBEntities myDbContext = new AchieveDBEntities();
NoticeModel tb = JsonConvert.DeserializeObject <NoticeModel>(Noticetstr);
string Code = Guid.NewGuid().ToString();
string BillNo = BillNoBill.GetBillNo(myDbContext, "TZ");
tbNotice main = tb.Main;
List <NoticeUserModel> item = tb.Item;
main.CreateTime = DateTime.Now;
main.UpdateTime = DateTime.Now;
main.NoticeTime = DateTime.Now;
main.status = 0;
main.Code = Code;
main.No = BillNo;
if (item != null && item.Count > 0)
{
foreach (var st in item)
{
st.NoticeCode = Code;
st.SendFlag = 0;
st.UpdateTime = DateTime.Now;
st.CreateTime = DateTime.Now;
}
}
myDbContext.tbNotice.Add(main);
foreach (var st in item)
{
tbNoticeUser temp = new tbNoticeUser();
string[] keys = { "id" };
ObjectHelper.CopyValueNotKey(st, temp, keys);
myDbContext.tbNoticeUser.Add(temp);
}
myDbContext.SaveChanges();
str = ResponseHelper.ResponseMsg("1", "保存成功", Code);
}
catch (Exception ex)
{
str = ResponseHelper.ResponseMsg("-1", ex.Message, "");
}
return(str);
}
public static string UpdateNotice(string Noticetstr)
{
string str = string.Empty;
try
{
NoticeModel tb = JsonConvert.DeserializeObject <NoticeModel>(Noticetstr);
tbNotice main = tb.Main;
List <NoticeUserModel> item = tb.Item;
main.UpdateTime = DateTime.Now;
main.status = 0;
if (item != null && item.Count > 0)
{
foreach (var st in item)
{
st.UpdateTime = DateTime.Now;
}
}
AchieveDBEntities myDbContext = new AchieveDBEntities();
tbNotice mainDb = myDbContext.tbNotice.Where(p => p.Code == main.Code).ToList().FirstOrDefault();
string[] keys = { "Code" };
ObjectHelper.CopyValueNotKey(main, mainDb, keys);
if (item != null && item.Count > 0)
{
int?[] UserIds = new int?[item.Count];
int count = 0;
foreach (var st in item)
{
UserIds[count] = st.UserId;
count++;
tbNoticeUser temp = myDbContext.tbNoticeUser.Where(p => p.UserId == st.UserId && p.NoticeCode == main.Code).ToList().FirstOrDefault();
keys[0] = "id";
if (temp != null)
{
// st.NoticeCode = main.Code;
//ObjectHelper.CopyValueNotKey(st, temp, keys);
}
else
{
tbNoticeUser newtemp = new tbNoticeUser();
ObjectHelper.CopyValueNotKey(st, newtemp, keys);
newtemp.NoticeCode = main.Code;
myDbContext.tbNoticeUser.Add(newtemp);
}
}
List <tbNoticeUser> tempList = myDbContext.tbNoticeUser.Where(p => !(UserIds).Contains(p.UserId) && p.NoticeCode == main.Code).ToList();
if (tempList != null && tempList.Count > 0)
{
foreach (var st in tempList)
{
myDbContext.tbNoticeUser.Remove(st);
}
}
}
myDbContext.SaveChanges();
str = ResponseHelper.ResponseMsg("1", "保存成功", main.Code);
}
catch (Exception ex)
{
str = ResponseHelper.ResponseMsg("-1", ex.Message, "");
}
return(str);
}
