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);
