public static bool SetLove(LoveType loveType, ImgInfo info) { try { Picture picModel = db.Queryable <Picture>().Where(o => o.Id == info.Id).First(); Love love = db.Queryable <Love>().Where(o => o.PictureId == info.Id).First(); if (picModel == null || love == null) //目前仅考虑第一次收藏 { SetTagLove(loveType, info); } if (picModel == null) { picModel = ToPicture(info); db.Insertable(picModel).ExecuteCommand(); } love = new Love() { PictureId = info.Id, Time = DateTime.Now, Type = (int)loveType }; db.Saveable(love).ExecuteCommand(); return(true); } catch (Exception ex) { LogHelper.WriteLog(ex.Message, EnumLogLevel.Error); return(false); } }
public void addUser(User user) { if (GetUserByUserName(user.Username) == null) { db.Saveable(user).ExecuteCommand(); } }
public static void Init() { Console.WriteLine(""); Console.WriteLine("#### Saveable Start ####"); SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { DbType = DbType.Kdbndp, ConnectionString = Config.ConnectionString, InitKeyType = InitKeyType.Attribute, IsAutoCloseConnection = true, AopEvents = new AopEvents { OnLogExecuting = (sql, p) => { Console.WriteLine(sql); Console.WriteLine(string.Join(",", p?.Select(it => it.ParameterName + ":" + it.Value))); } } }); //insert or update db.Saveable <Order>(new Order() { Id = 1, Name = "jack" }).ExecuteReturnEntity(); //insert or update db.Saveable <Order>(new Order() { Id = 1000, Name = "jack", CreateTime = DateTime.Now }) .InsertColumns(it => new { it.Name, it.CreateTime, it.Price }) //if insert into name,CreateTime,Price .UpdateColumns(it => new { it.Name, it.CreateTime }) //if update set name CreateTime .ExecuteReturnEntity(); Console.WriteLine(""); Console.WriteLine("#### Saveable End ####"); }
public static void Init() { Console.WriteLine(""); Console.WriteLine("#### Saveable Start ####"); SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { DbType = DbType.Access, ConnectionString = Config.ConnectionString, InitKeyType = InitKeyType.Attribute, IsAutoCloseConnection = true, AopEvents = new AopEvents { OnLogExecuting = (sql, p) => { Console.WriteLine(sql); Console.WriteLine(string.Join(",", p?.Select(it => it.ParameterName + ":" + it.Value))); } } }); //insert or update var x = db.Storageable <Order>(new Order() { Id = 159, Name = "jack" }).ToStorage(); var updateRow = x.AsUpdateable.ExecuteCommand(); x.AsInsertable.ExecuteCommand(); var x2 = db.Storageable <Order>(new Order() { Id = 0, Name = "jack" }).ToStorage(); var updateRow2 = x2.AsUpdateable.ExecuteCommand(); x2.AsInsertable.ExecuteCommand(); db.Saveable(new Order() { Id = 159, Name = "jack" }).ExecuteCommand(); Console.WriteLine(""); Console.WriteLine("#### Saveable End ####"); }
public static readonly log4net.ILog logerror = log4net.LogManager.GetLogger("logerror");//这里的 logerror 和 log4net.config 里的名字要一样 public void WriteErrorLog(Exception ex, string method, string errorTable) { try { SqlSugarClient db = DBSugar.MySqlInstance(); TB_Error_log error = new TB_Error_log(); error.ErrorID = Guid.NewGuid().ToString("D"); error.ErrorMessage = ex.Message; error.ErrorMethod = method; error.ErrorTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); error.ErrorTable = errorTable; db.Saveable <TB_Error_log>(error).ExecuteCommand(); logerror.Error("异常为:" + ex.Message + "========================方法是:" + method + "========================数据表为:" + errorTable); } catch (Exception e) { logerror.Error("异常为:" + e.Message + "========================方法是:" + method + "========================数据表为:" + errorTable); } }
public void WriteInforLog(string message, string method, string errorTable) { loginfo.Error("方法是:" + method + "========================数据表为:" + errorTable); try { SqlSugarClient db = DBSugar.MySqlInstance(); TB_Info_log info_Log = new TB_Info_log(); info_Log.InfoID = Guid.NewGuid().ToString("D"); info_Log.InfoMessage = message; info_Log.InfoMethod = method; info_Log.InfoTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); info_Log.InfoTable = errorTable; db.Saveable <TB_Info_log>(info_Log).ExecuteCommand(); } catch (Exception ex) { error.WriteErrorLog(ex, method, errorTable); } }
} //用来处理常用操作 /// <summary> /// 新增 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="t"></param> /// <returns></returns> public virtual T Add(T t) { return(SqlSugarClient.Saveable(t).ExecuteReturnEntity()); }
public void addDish(Dish dish) { db.Saveable(dish).ExecuteCommand(); }
public static void Init() { SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { ConnectionString = Config.ConnectionString, DbType = DbType.SqlServer, IsAutoCloseConnection = true }); db.Aop.OnLogExecuted = (sql, pars) => { Console.Write("time:" + db.Ado.SqlExecutionTime.ToString()); }; db.Aop.OnLogExecuting = (sql, pars) => { }; db.Aop.OnError = (exp) => { }; db.Aop.OnExecutingChangeSql = (sql, pars) => { return(new KeyValuePair <string, SugarParameter[]>(sql, pars)); }; db.Queryable <CMStudent>().ToList(); try { db.Queryable <CMStudent>().AS(" ' ").ToList(); } catch (Exception) { } //diff log demo db.Aop.OnDiffLogEvent = it => { var editBeforeData = it.BeforeData; var editAfterData = it.AfterData; var sql = it.Sql; var parameter = it.Parameters; var data = it.BusinessData; var type = it.DiffType; var time = it.Time; Console.WriteLine(it.DiffType); }; var id = db.Insertable(new Student() { Name = "beforeName" }) .EnableDiffLogEvent(new { title = "add student" }) .ExecuteReturnIdentity(); db.Updateable <Student>(new Student() { Id = id, CreateTime = DateTime.Now, Name = "afterName", SchoolId = 2 }) .EnableDiffLogEvent(new { title = "update Student", Modular = 1, Operator = "admin" }) .ExecuteCommand(); db.Deleteable <Student>(id) .EnableDiffLogEvent(new { title = "delete student" }) .ExecuteCommand(); //primary key guid db.Insertable(new DataTestInfo2() { Bool1 = true, Bool2 = false, PK = Guid.NewGuid(), Text1 = "a" }) .EnableDiffLogEvent(new { title = "add DataTestInfo2" }) .ExecuteReturnIdentity(); var enrity = db.Saveable(new Student() { Name = "saveinsert" }).EnableDiffLogEvent().ExecuteReturnEntity(); db.Saveable(new Student() { Id = enrity.Id, Name = "saveinsert" }).EnableDiffLogEvent().ExecuteCommand(); }
public void AddMenuItem(Menuitem menuItem) { _db.Saveable(menuItem).ExecuteCommand(); }
public void AddOrder(Order order) { db.Saveable(order).ExecuteCommand(); }
static void Main(string[] args) { ServiceReference1.IsvInterfaceSoapClient s = new ConsoleApp1.ServiceReference1.IsvInterfaceSoapClient(); //P214.1 门诊 P214.2 急诊 P214.3 住院 P214.4 体检 string requestStr = "<Msg><Head><Code>GetInPatientListByWard</Code><CTID>2017120900000055</CTID><IsvID>meehealth</IsvID><AppID>wjInterface</AppID><SubmitTime>" + DateTime.Now.ToString("yyyyMMddHHmmss") + "</SubmitTime><Version>1</Version><Priority>10</Priority></Head><Body><HospID>42502652100</HospID><WardNO>@deptno</WardNO><IsShow>0</IsShow><jzlx>2</jzlx></Body></Msg>"; string[] deptnos = ConfigurationSettings.AppSettings["deptno"].Split(','); //string fromdt = ConfigurationSettings.AppSettings["fromdt"]; string conn = ConfigurationSettings.AppSettings["conn"]; //if (string.IsNullOrEmpty(fromdt)) fromdt = DateTime.Now.ToString("yyyy-MM-dd") ; //string enddt = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"); List <Patient> patientlist = new List <Patient>(); foreach (string dept in deptnos) { string req = requestStr.Replace("@deptno", dept); var result = s.IsvInterfaceXmlString(req); byte[] array = Encoding.UTF8.GetBytes(result); MemoryStream stream = new MemoryStream(array); XmlDocument doc = new XmlDocument(); doc.Load(stream); XmlNodeList xn0 = doc.SelectNodes("Msg/Body/PatientList/PatientInfo"); if (xn0 != null) { DateTime defaulttime = DateTime.MinValue; foreach (XmlNode item in xn0) { DateTime.TryParse(item.SelectSingleNode("csrq").InnerText, out defaulttime); var now = DateTime.Now; int age = now.Year - defaulttime.Year; if (now.Month < defaulttime.Month || (now.Month == defaulttime.Month && now.Day < defaulttime.Day)) { age--; } Patient p = new Patient { Name = item.SelectSingleNode("hzxm").InnerText, Type = age < 16 ? 2 : 1, Nation = item.SelectSingleNode("mcmc").InnerText, Citizen = item.SelectSingleNode("gjmc").InnerText, Birthday = defaulttime, VisitID = item.SelectSingleNode("jzlsh").InnerText, Sex = item.SelectSingleNode("sex").InnerText == null ? 1 : item.SelectSingleNode("sex").InnerText.Trim() == "男" ? 1 : 2, TelPhoneNo = item.SelectSingleNode("lxdh").InnerText, Marriage = item.SelectSingleNode("hymc").InnerText, Height = item.SelectSingleNode("sg").InnerText, Weight = item.SelectSingleNode("tz").InnerText, }; patientlist.Add(p); } } } //插入更新 SqlSugarClient db = new SqlSugarClient( new ConnectionConfig() { ConnectionString = conn, DbType = DbType.SqlServer, //设置数据库类型 IsAutoCloseConnection = true, //自动释放数据务,如果存在事务,在事务结束后释放 InitKeyType = InitKeyType.Attribute //从实体特性中读取主键自增列信息 }); patientlist.ForEach(x => { var temp = db.Queryable <Patient>().Where(y => y.VisitID == x.VisitID); if (temp.Any()) { x.Id = temp.First().Id; } }); db.Saveable(patientlist).ExecuteReturnEntity(); }
public virtual ISaveable <TModel> Save(TModel model) => db.Saveable(model);