public static void Update()
{
context.Update <User>(a => a.Id == 1, a => new User()
{
Name = a.Name, Age = a.Age + 100, Gender = Gender.Man, OpTime = DateTime.Now
});
/*
* UPDATE `Users` SET `Name`=`Users`.`Name`,`Age`=(`Users`.`Age` + 100),`Gender`=1,`OpTime`=NOW() WHERE `Users`.`Id` = 1
*/
//批量更新
//给所有女性年轻 10 岁
context.Update <User>(a => a.Gender == Gender.Woman, a => new User()
{
Age = a.Age - 10, OpTime = DateTime.Now
});
/*
* UPDATE `Users` SET `Age`=(`Users`.`Age` - 10),`OpTime`=NOW() WHERE `Users`.`Gender` = 2
*/
User user = new User();
user.Id = 1;
user.Name = "lu";
user.Age = 28;
user.Gender = Gender.Man;
user.OpTime = DateTime.Now;
context.Update(user); //会更新所有映射的字段
/*
* String ?P_0 = 'lu';
* Gender ?P_1 = Man;
* Int32 ?P_2 = 28;
* Nullable<Int32> ?P_3 = NULL;
* DateTime ?P_4 = '2016/8/26 18:18:36';
* Int32 ?P_5 = 1;
* UPDATE `Users` SET `Name`=?P_0,`Gender`=?P_1,`Age`=?P_2,`CityId`=?P_3,`OpTime`=?P_4 WHERE `Users`.`Id` = ?P_5
*/
/*
* 支持只更新属性值已变的属性
*/
context.TrackEntity(user); //在上下文中跟踪实体
user.Name = user.Name + "1";
context.Update(user); //这时只会更新被修改的字段
/*
* String ?P_0 = 'lu1';
* Int32 ?P_1 = 1;
* UPDATE `Users` SET `Name`=?P_0 WHERE `Users`.`Id` = ?P_1
*/
ConsoleHelper.WriteLineAndReadKey();
}
public static void Update()
{
context.Update <User>(a => new User()
{
Name = a.Name, Age = a.Age + 100, Gender = Gender.Man, OpTime = DateTime.Now
}, a => a.Id == 1);
/*
* UPDATE [Users] SET [Name]=[Users].[Name],[Age]=([Users].[Age] + 100),[Gender]=1,[OpTime]=DATETIME('NOW','LOCALTIME') WHERE [Users].[Id] = 1
*/
//批量更新
//给所有女性年轻 10 岁
context.Update <User>(a => new User()
{
Age = a.Age - 10, OpTime = DateTime.Now
}, a => a.Gender == Gender.Woman);
/*
* UPDATE [Users] SET [Age]=([Users].[Age] - 10),[OpTime]=DATETIME('NOW','LOCALTIME') WHERE [Users].[Gender] = 2
*/
User user = new User();
user.Id = 1;
user.Name = "lu";
user.Age = 28;
user.Gender = Gender.Man;
user.OpTime = DateTime.Now;
context.Update(user); //会更新所有映射的字段
/*
* String @P_0 = 'lu';
* Gender @P_1 = Man;
* Int32 @P_2 = 28;
* Nullable<Int32> @P_3 = NULL;
* DateTime @P_4 = '2016/8/6 22:05:02';
* Int32 @P_5 = 1;
* UPDATE [Users] SET [Name]=@P_0,[Gender]=@P_1,[Age]=@P_2,[CityId]=@P_3,[OpTime]=@P_4 WHERE [Users].[Id] = @P_5
*/
/*
* 支持只更新属性值已变的属性
*/
context.TrackEntity(user); //在上下文中跟踪实体
user.Name = user.Name + "1";
context.Update(user); //这时只会更新被修改的字段
/*
* String @P_0 = 'lu1';
* Int32 @P_1 = 1;
* UPDATE [Users] SET [Name]=@P_0 WHERE [Users].[Id] = @P_1
*/
ConsoleHelper.WriteLineAndReadKey();
}
public async Task <ActionResult <string> > Delete(int id)
{
var db_item = await _context.Items.FindAsync(id);
db_item.Active = false;
_context.Update(db_item);
await _context.SaveChangesAsync();
await UpdateCollection(db_item.CollectionId);
return(JsonConvert.SerializeObject(db_item, Formatting.Indented));
}
public async Task <IActionResult> Update(int id, [Bind("Name")] Collection collection)
{
var db_collection = _context.Collections.Find(id);
if (db_collection == null)
{
return(RedirectToAction("CollectionIndex"));
}
db_collection.Name = collection.Name;
_context.Update(db_collection);
await _context.SaveChangesAsync();
return(RedirectToAction("CollectionShow", "Collections", new { id = id }));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,CDId,Title,Authors,Duration")] Track track)
{
if (id != track.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(track);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TrackExists(track.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(track));
}
public async Task <IActionResult> Edit(uint id, [Bind("Id,Username,Password,Name,Age,ContactNo,Address,Designation")] Users users)
{
if (id != users.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(users);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UsersExists(users.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(users));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
try
{
var mysqlContext = new MySqlContext(new MySqlConnectionFactory(connString));
var userInfo = (User)context.Session[Constant.CurrentUser];
userInfo.weichat = string.Empty;
userInfo.phone = string.Empty;
var returnState = mysqlContext.Update(userInfo);
if (returnState != 0)
{
context.Session.Clear();
context.Response.Write(JsonConvert.SerializeObject(new AjaxResponse {
success = true, message = "注销成功"
}));
return;
}
else
{
context.Response.Write(JsonConvert.SerializeObject(new AjaxResponse {
success = false, message = "账号已被注销"
}));
return;
}
}
catch (Exception ex)
{
context.Response.Write(JsonConvert.SerializeObject(new AjaxResponse {
success = false, message = "注销失败"
}));
return;
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Title,Artists,ReleaseYear,TotalTracks,TotalDuration")] CD cD)
{
if (id != cD.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(cD);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CDExists(cD.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(cD));
}
/// <summary>
/// 保存记录
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="insertObjs"></param>
/// <returns></returns>
public virtual T InsertAndUpdate <T>(T saveModel, string tit = "") where T : BaseEntity
{
T model;
if (saveModel.Id < 1 && string.IsNullOrEmpty(saveModel.Sid))
{
saveModel.Sid = ApiHelp.ApiHelper.CreateRandom(32, 26, tit);
saveModel.CreateDate = DateTime.Now;
model = context.Insert <T>(saveModel);
}
else
{
context.Update <T>(saveModel);
model = QuerySing <T>(t => t.Sid == saveModel.Sid);
}
return(model);
}
public async Task <IActionResult> Update(int collectionId, int id, [Bind("Name,Price,Collected")] Item item)
{
var db_item = _context.Items.Find(id);
if (db_item == null)
{
return(RedirectToAction("CollectionIndex"));
}
db_item.Name = item.Name;
db_item.Price = item.Price;
db_item.Collected = item.Collected;
_context.Update(db_item);
await _context.SaveChangesAsync();
await UpdateCollection(collectionId);
return(RedirectToAction("CollectionShow", "Collections", new { id = collectionId }));
}
public Person Update(Person person)
{
try
{
_context.Update(person);
_context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(person);
}
public async Task UpdateUser(string openId, string nickName, string imageURL)
{
var user = _mySql.Users.
FirstOrDefault(entity => entity.OpenId == openId);
if (user == null)
{
throw new Exception("User not exists.");
}
user.NickName = nickName;
user.ImageURL = imageURL;
_mySql.Update(user);
await _mySql.SaveChangesAsync();
}
/// <summary>
/// 更新多本小说至数据库
/// </summary>
/// <param name="_tfi">数据</param>
/// <returns></returns>
public static bool _b_Update_Fiction_Info(List <tb_fiction_info> _ltfi)
{
try
{
Cls_MySQLHelper <tb_fiction_info> _msh = new Cls_MySQLHelper <tb_fiction_info>();
MySqlContext context = _msh.DbContext();
context.Update(_ltfi);
_msh.Dispose_Db();
return(true);
}
catch
{
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
var mysqlContext = new MySqlContext(new MySqlConnectionFactory(connString));
string phone = context.Request["phone"].ObjToStr();
string name = context.Request["name"].ObjToStr();
string account = context.Request["account"].ObjToStr();
string password = context.Request["password"].ObjToStr();
string username = context.Request["username"].ObjToStr();
var userInfo = mysqlContext.Query <User>().FirstOrDefault(o => o.username.Equals(username));
if (userInfo == null)
{
context.Response.Write(JsonConvert.SerializeObject(new AjaxResponse {
success = false, message = "用户不存在"
}));
return;
}
var isExist = mysqlContext.Query <User>().FirstOrDefault(o => o.username.Equals(account) && !o.username.Equals(username));
if (isExist != null)
{
context.Response.Write(JsonConvert.SerializeObject(new AjaxResponse {
success = false, message = "用户名已被使用"
}));
return;
}
userInfo.password = password;
userInfo.phone = phone;
userInfo.realname = name;
userInfo.username = account;
mysqlContext.Update(userInfo);
context.Response.Write(JsonConvert.SerializeObject(new AjaxResponse {
success = true, message = "密码修改成功"
}));
return;
}
catch (Exception)
{
context.Response.Write(JsonConvert.SerializeObject(new AjaxResponse {
success = false, message = "密码修改失败"
}));
return;
}
}
public bool SavePlayer(Player player)
{
try
{
player.data.MapId = player.publicData.mapId;
player.data.X = player.publicData.x;
player.data.Y = player.publicData.y;
player.data.Dir = player.publicData.dir;
context.Update(player.data);
Console.WriteLine("保存玩家数据成功:" + player.publicData.name);
return(true);
}
catch (Exception e)
{
Console.WriteLine("保存玩家数据异常:" + e);
return(false);
}
}
public Person Update(Person person)
{
bool exist = _context.Person.Any(p => p.Id == person.Id);
try
{
if (!exist)
{
return(new Person());
}
_context.Update(person);
_context.SaveChanges();
}catch (Exception e)
{
throw e;
}
return(person);
}
public async Task <IActionResult> Edit(uint id, [Bind("Id,RequirerName,Age,RequirementDesc,VolunteerCode,Address,ContactNo,RequestedDate,RequestDueDate,RequestCompleted,RequestCancelled,CancellationDesc,Priority,StatusOfRequest,Lat,Long,AdditionalDetails")] Requirements requirements)
{
if (id != requirements.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
if (requirements.StatusOfRequest.Value.Equals((int)RequestStatus.Cancelled))
{
requirements.RequestCancelled = DateTime.Now;
}
else if (requirements.StatusOfRequest.Value.Equals((int)RequestStatus.Delivered))
{
requirements.RequestCompleted = DateTime.Now;
}
_context.Update(requirements);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RequirementsExists(requirements.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(requirements));
}
//[Authorize]// [FromBody] ICollection<Thema> array
public async Task <ActionResult <List <Thema> > > SaveAllThemes([FromBody] IEnumerable <Thema> themes)
{
// Проверить наличие таких же тем, если нету то сохранить
string username = null;
string teacherId = "teacher2";
var dbThemes = _context.Themes.AsTracking();
var dbQuestions = _context.Questions.AsTracking();
foreach (Thema thema in themes)
{
var checkThema = await dbThemes.FirstOrDefaultAsync(a => a.Id.Equals(thema.Id));
if (checkThema == null)
{
_context.Themes.Add(thema);
}
else
{
checkThema.Name = thema.Name;
checkThema.Description = thema.Description;
_context.Themes.Update(checkThema);
}
var nowQuestions = await dbQuestions.Where(a => a.ThemaId.Equals(thema.Id)).AsTracking().ToListAsync();
if (thema.Questions != null)
{
foreach (Question question in thema.Questions)
{
var findTestThema = nowQuestions.FirstOrDefault(a => a.Id.Equals(question.Id));
if (findTestThema == null)
{
_context.Add(question);
}
else
{
_context.Update(question);
nowQuestions.Remove(findTestThema);
}
}
//Remove elements
_context.RemoveRange(nowQuestions);
}
thema.TeacherUserId = teacherId;
var findTest = dbThemes.FirstOrDefault(a => a.Id.Equals(thema.Id));
Console.WriteLine($"Find test {findTest}");
if (findTest == null)
{
_context.Themes.Add(thema);
}
else
{
_context.Themes.Update(thema);
}
}
_context.SaveChanges();
return(Ok(themes));
}
protected string RedrectWeiXin()
{
try
{
LogHelper.WriteLogs(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "重新获取openid：");
string url = HttpContext.Current.Request.Url.AbsolutePath;
string query = HttpContext.Current.Request.Url.Query;
string RedirectUri = homeUrl + url + query;
WeiXinOath wxOath = new WeiXinOath();
WxUserInfo wxUserInfo = new WxUserInfo();
if (Session == null || string.IsNullOrEmpty(Session[Constant.OpenId].ObjToStr()))
{
LogHelper.WriteLogs(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "OpenId不存在：");
var code = Request.QueryString[Constant.WxCode];
LogHelper.WriteLogs(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "code：" + code);
#region 根据code获取openid
if (code != null && !string.IsNullOrEmpty(code))
{
OauthToken oathToken = new OauthToken();
oathToken = wxOath.GetOauthToken(code);//获取用户openid
Session[Constant.OpenId] = oathToken.openid;
LogHelper.WriteLogs(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "openid：" + oathToken.openid);
#region 存入用户信息
wxUserInfo = wxOath.GetWebUserInfo(accessToken, oathToken.openid);
LogHelper.WriteLogs(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "存入用户信息：" + JsonConvert.SerializeObject(wxUserInfo));
var wxUserDB = context.Query <UserWeiChat>().FirstOrDefault(o => o.openid.Equals(oathToken.openid));
if (wxUserDB == null)
{
context.Insert(new UserWeiChat
{
createtime = DateTime.Now,
headpic = wxUserInfo.headimgurl,
nickname = wxUserInfo.nickname,
openid = wxUserInfo.openid,
unionid = string.Empty
});
}
else
{
wxUserDB.headpic = wxUserInfo.headimgurl;
wxUserDB.nickname = wxUserInfo.nickname;
context.Update(wxUserDB);
}
#endregion
return(oathToken.openid);
}
else
{
wxOath.GetCode(RedirectUri);
return(string.Empty);
}
#endregion
}
{
return(Session[Constant.OpenId].ObjToStr());
}
}
catch (Exception ex)
{
LogHelper.WriteLogs(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "数据异常：" + ex.InnerException.Message);
MessageBox.Show(this, "system_alert", "数据异常:" + ex.Message + ":" + ex.StackTrace);
return(string.Empty);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
try
{
var mysqlContext = new MySqlContext(new MySqlConnectionFactory(connString));
string phone = context.Request["phone"].ObjToStr();
string realname = context.Request["realname"].ObjToStr();
string username = context.Request["username"].ObjToStr();
string password = context.Request["password"].ObjToStr();
string openid = context.Session[Constant.OpenId].ObjToStr();
var userInfo = mysqlContext.Query <User>().FirstOrDefault(o => o.username.Equals(username));
if (userInfo == null)
{
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = false, message = "用户不存在"
}));
return;
}
else
{
mysqlContext.Session.BeginTransaction();
//迁移数据到历史记录表
var userHistory = TinyMapper.Map <UserHistory>(userInfo);
mysqlContext.Insert(userHistory);
//更新用户信息
userInfo.password = password;
userInfo.phone = phone;
userInfo.realname = realname;
userInfo.weichat = openid;
mysqlContext.Update(userInfo);
//添加登录日志
mysqlContext.Insert <LoginRecord>(new LoginRecord
{
date = DateTime.Now,
ip = Utils.GetUserIp(),
state = 1,
username = userInfo.username
});
mysqlContext.Session.CommitTransaction();
var userRole = mysqlContext.Query <UserRole>().FirstOrDefault(o => o.username.Equals(userInfo.username));
if (userRole == null)
{
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = false, message = "权限异常"
}));
return;
}
switch ((UserRoleEnum)userRole.role_id)
{
case UserRoleEnum.经理:
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = true, message = "修改成功", url = Constant.JsCenterDic + "ManageCenter.aspx"
}));
return;
case UserRoleEnum.财务:
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = true, message = "修改成功", url = Constant.JsCenterDic + "FinanceCenter.aspx"
}));
return;
case UserRoleEnum.前台:
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = true, message = "修改成功", url = Constant.JsCenterDic + "EmployeeCenter.aspx"
}));
return;
case UserRoleEnum.测试员:
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = true, message = "修改成功", url = Constant.JsCenterDic + "TestCenter.aspx"
}));
return;
case UserRoleEnum.配水员:
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = true, message = "修改成功", url = Constant.JsCenterDic + "PromotionCenter.aspx"
}));
return;
case UserRoleEnum.区域经理:
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = true, message = "修改成功", url = Constant.JsCenterDic + "ManageCenter.aspx"
}));
return;
default:
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = true, message = "修改成功", url = Constant.JsCenterDic + ""
}));
return;
}
}
}
catch (Exception ex)
{
context.Response.Write(JsonConvert.SerializeObject(new BindResponse {
success = false, message = "数据异常"
}));
return;
}
}
public void Run()
{
string pattern1 = @"href=""(/weather.+?[0-9]+?/)"".+? data-name=""(\w+?)""";
string pattern2 = @"<a.+?tomorrow.+? data-text=""([А-я, ]+)""(?:.\r?\n?)+?<span class="".+?"">(.+?)</span>(?:.\r?\n?)+?<div class='.+?'[^>]+>([^<]+?)</div><div class='.+?'[^>]+>([^<]+?)</div>(?:.\r?\n?)+?(?:<div class="".+?"">([^<]+?)</div>)?</div></a>";
GisResource resourceFirst = new GisResource(new GisSettings("http://www.gismeteo.ru/"));
ResultGisInfo resultFirst = new ResultGisInfo();
List <Info> infoResult = resultFirst.GetResult(resourceFirst, pattern1);
try
{
MySqlConnection connection = new MySqlGetConnection(new MySqlSettings()).GetConnection();
MySqlContext context = new MySqlContext(connection);
List <MySqlDatabase> dataInfo = context.GetItems(SelectTable.Informations);
foreach (var result in infoResult)
{
GisResource resourceSecond = new GisResource(new GisSettings("http://www.gismeteo.ru/" + result.Link));
ResultGisWeather resultSecond = new ResultGisWeather();
Weather weatherResult = resultSecond.GetResult(resourceSecond, pattern2);
if (dataInfo != null)
{
foreach (var data in dataInfo)
{
if (result.City.Equals(data.Informations.City))
{
MySqlDatabase row = new MySqlDatabase
{
Informations = new Info
{
Id = data.Informations.Id,
City = result.City,
Link = result.Link
},
Weathers = weatherResult
};
context.Update(row, SelectTable.All);
}
else
{
MySqlDatabase row = new MySqlDatabase
{
Informations = result,
Weathers = weatherResult
};
}
}
}
else
{
MySqlDatabase row = new MySqlDatabase
{
Informations = result,
Weathers = weatherResult
};
context.Insert(row, SelectTable.All);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.ReadLine();
System.Environment.Exit(1);
}
}
public async Task <ProdutoData> Update(ProdutoData entity)
{
context.Update(entity);
return(await Task.FromResult(entity));
}
public async Task <ClienteData> Update(ClienteData entity)
{
context.Update(entity);
return(await Task.FromResult(entity));
}
/// <summary>
/// 更新方法 宋文杰 2018年8月9日14:01:47
/// 只支持单条记录更新并且更新整条记录
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="model">要更新的实体</param>
/// <returns></returns>
public void Update <T>(T model)
{
context.Update <T>(model);
}
public bool BatchInsert(List <Product_Size> list)
{
bool v = false;
string DbType = Globals.Configuration["db:DbType"].ToString();
string ConnString = Globals.Configuration["db:ConnString"].ToString();
if (DbType == "MySql")
{
using (MySqlContext context = new MySqlContext(new MySqlConnectionFactory(ConnString)))
{
try
{
context.Session.BeginTransaction();
foreach (var item in list)
{
//int row = context.Session.ExecuteNonQuery("select 1 from yd_fdtz where DKBH = '"+item.DKBH+"' limit 1;");
if (item.Id == "0")
{
item.Id = IdHelper.CreateStringSnowflakeId();
context.Insert <Product_Size>(item);
}
else
{
context.Update <Product_Size>(item);
}
}
context.Session.CommitTransaction();
}
catch
{
if (context.Session.IsInTransaction)
{
context.Session.RollbackTransaction();
}
throw;
}
}
}
if (DbType == "SqlServer")
{
using (MsSqlContext context = new MsSqlContext(ConnString))
{
try
{
context.Session.BeginTransaction();
foreach (var item in list)
{
//int row = context.Session.ExecuteNonQuery("select count(1) from yd_fdtz where DKBH = '" + item.DKBH + "'");
if (item.Id == "0")
{
item.Id = IdHelper.CreateStringSnowflakeId();
context.Insert <Product_Size>(item);
}
else
{
context.Update <Product_Size>(item);
}
}
context.Session.CommitTransaction();
}
catch
{
if (context.Session.IsInTransaction)
{
context.Session.RollbackTransaction();
}
throw;
}
}
}
return(v);
}
public virtual void Update(T t)
{
_context.Update(t);
}
private void _failpushTimer_Elapsed(object sender, ElapsedEventArgs e)
{
_failpushTimer.Stop();
var pushInfo = context.Query <WeiChatPushFailLog>().FirstOrDefault(o => o.issuccess == false && o.createtime.AddMinutes(30) > DateTime.Now);
if (pushInfo != null)
{
var orderInfo = context.Query <OrderInfo>()
.LeftJoin <Product>((a, b) => a.product == b.id)
.LeftJoin <Cabinet>((a, b, c) => a.cabinet_mac.Equals(c.mac))
.LeftJoin <Hotel>((a, b, c, d) => c.hotel == d.id)
.Where((a, b, c, d) => a.code.Equals(pushInfo.ordercode))
.Select((a, b, c, d) => new
{
a.delivered,
hotelid = d.id,
a.code,
b.name,
a.price1,
d.simple_name,
c.room,
a.date
}).FirstOrDefault();
var color = "#173177";
//如果开箱失败，则推送开箱失败的订单，这里只是修改颜色
if (!orderInfo.delivered)
{
color = "#D74C29";
}
var title = string.Format("{0}-{1}于 {2} 发生一笔订单交易。", orderInfo.simple_name, orderInfo.room, orderInfo.date.ToString("yyyy-MM-dd HH:mm:ss"));
var keyword1 = orderInfo.code;
var keyword2 = orderInfo.name;
var keyword3 = 1 + "件";
var keyword4 = orderInfo.price1.ObjToInt(0).CentToRMB(0) + " 元";
var remark = "感谢您的使用" + " " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var tempId = "HfV9-ClzJoRJ_2ubWRrw1y3qy9IaZBnwFOt09QLRmHY";
dynamic postData = new ExpandoObject();
dynamic first = new ExpandoObject();
first.value = title;
first.color = color;
dynamic keyword1Obj = new ExpandoObject();
keyword1Obj.value = keyword1;
keyword1Obj.color = color;
dynamic keyword2Obj = new ExpandoObject();
keyword2Obj.value = keyword2;
keyword2Obj.color = color;
dynamic keyword3Obj = new ExpandoObject();
keyword3Obj.value = keyword3;
keyword3Obj.color = color;
dynamic keyword4Obj = new ExpandoObject();
keyword4Obj.value = keyword4;
keyword4Obj.color = color;
dynamic remarkObj = new ExpandoObject();
remarkObj.value = remark;
remarkObj.color = color;
postData.first = first;
postData.keyword1 = keyword1Obj;
postData.keyword2 = keyword2Obj;
postData.keyword3 = keyword3Obj;
postData.keyword4 = keyword4Obj;
postData.remark = remarkObj;
Log.WriteLog("微信推送", "postData", JsonConvert.SerializeObject(postData));
Log.WriteLog("微信推送", "openId:", pushInfo.openid);
pushInfo.issuccess = Send_WX_Message(postData, pushInfo.openid, tempId);
Log.WriteLog("微信推送", "orderno:", orderInfo.code);
Log.WriteLog("微信推送", "responseBool:", pushInfo.issuccess.ObjToStr());
context.Update(pushInfo);
}
_failpushTimer.Start();
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="LT_IN">待处理数据</param>
/// <returns></returns>
public int Update(T LT_IN)
{
return(_DbContext.Update(LT_IN));
}
public static string SaveInfoSMS(string configuration, List <SmsRespone> resps, int type)
{
DbContext _context = new MySqlContext(new MySqlConnectionFactory(configuration));
List <SmsLogs> lstSmsLog = new List <SmsLogs>();
List <string> lstSmsUsed = new List <string>();
int fail = 0;
string result = "";
foreach (var resp in resps)
{
SmsLogs smsLog = new SmsLogs();
smsLog.PhoneNumber = resp.PhoneNumber;
smsLog.Message = resp.Message;
smsLog.ResultMessage = resp.Result;
smsLog.Status = resp.Code == 0 ? 0 : 1;
smsLog.HealthFacilitiesId = resp.HealthFacilitiesId;
smsLog.SmsTemplateId = resp.SmsTemplateId;
//smsLog.SmsTemplateCode = resp.SmsTemplateCode;
smsLog.SmsPackagesDistributeId = resp.SmsPackagesDistributeId;
smsLog.SentDate = DateTime.Now;
smsLog.LogType = 1;
smsLog.Telco = resp.Telco;
smsLog.ObjectId = resp.PatientId;
smsLog.ObjectType = resp.ObjectType;
lstSmsLog.Add(smsLog);
result = resp.Result;
if (resp.Code == 0)
{
fail++;
}
if (lstSmsUsed.IndexOf(resp.SmsPackageUsedId.ToString()) < 0 && resp.Code != 0)//
{
lstSmsUsed.Add(resp.SmsPackageUsedId.ToString());
}
if (type == 1)
{
_context.Update <MedicalHealthcareHistories>(m => m.PatientHistoriesId == resp.PatientHistoriesId, a => new MedicalHealthcareHistories
{
IsReExamination = true
});
}
else if (type == 2)
{
_context.Update <MedicalHealthcareHistories>(m => m.PatientHistoriesId == resp.PatientHistoriesId, a => new MedicalHealthcareHistories
{
IsBirthDay = true
});
}
}
foreach (string smsUsedId in lstSmsUsed)
{
int totalSms = 0;
foreach (var resp in resps)
{
if (smsUsedId == resp.SmsPackageUsedId.ToString())
{
totalSms++;
}
}
_context.Update <SmsPackageUsed>(u => u.SmsPackageUsedId == int.Parse(smsUsedId), pu => new SmsPackageUsed
{
Quantityused = pu.Quantityused - totalSms
});
}
_context.InsertRange(lstSmsLog);
return("Tổng số SMS đã gửi/Số sms gửi lỗi: " + resps.Count + "/" + fail + "<br> Thông tin lỗi: " + result);
}
