public string SelectSingle(string id) { try { using (var db = SugarDao.GetInstance()) { int i = int.Parse(id); Student single = db.Queryable <Student>().Single(x => x.id == i); if (single != null) { string msg = string.Format("ID号:{0},名字:{1},学校号:{2}", single.id, single.name, single.sch_id); return(retMsg("查询单条数据", msg)); } else { return(retMsg("查询单条数据", "没报错--没找到对应数据")); } } } catch (Exception e) { Console.WriteLine(e); return(retMsg("查询单条数据", "后台报错--没找到对应数据")); } }
protected void Page_Load(object sender, EventArgs e) { using (SqlSugarClient db = SugarDao.GetInstance()) { //-----单个-------// var list = db.Queryable <V_Student>("Student").ToList();//查询的是 select * from student 而我的实体名称为V_Student //-----全局多个设置-------// //设置 Mapping Table 如果没这方面需求可以传NULL List <KeyValue> mappingTableList = new List <KeyValue>() { new KeyValue() { Key = "FormAttr", Value = "Flow_FormAttr" }, new KeyValue() { Key = "Student3", Value = "Student" } }; db.SetMappingTables(mappingTableList); } }
private void MedicineDetail_Load(object sender, EventArgs e) { InitLookUpEdit(lue_ssjyfw, 2); //所属经营范围 InitLookUpEdit(lue_unit, 4); //药品单位 InitLookUpEdit(lue_type, 5); //药剂分类 InitLookUpEdit(lue_jgfl, 6); //监管分类 InitLookUpEdit(lue_gys, 7); //供应商 InitLookUpEdit(lue_sccj, 8); //生产厂家 if (detailId > 0) { using (var db = SugarDao.GetInstance()) { var entity = db.Queryable <Domain.Model.Medicine>().Single(t => t.Id == detailId); if (entity != null && entity.Id > 0) { txt_name.Text = entity.Name; txt_commonName.Text = entity.CommonName; lue_ssjyfw.EditValue = entity.JYFWId; txt_bzgg.Text = entity.BZGG; lue_unit.EditValue = entity.UnitId; lue_type.EditValue = entity.TypeId; lue_jgfl.EditValue = entity.JGFLId; lue_gys.EditValue = entity.SupplierId; lue_sccj.EditValue = entity.SCCJId; txt_cpzc.Text = entity.CPZC; date_pzwh.Text = entity.PZWH; ckb_isPrescription.Checked = entity.IsPrescription; } } } }
/// <summary> /// 获取信息 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="count"></param> /// <param name="wh_id"></param> /// <param name="locat_code"></param> /// <returns></returns> public List <StorageBinModel> GetStorageBinList(int pagenum, int onepagecount, out int totil, out int totilpage, out string exmsg, long?wh_id, string locat_code) { using (var db = SugarDao.GetInstance(LoginUser.GetConstr())) { try { var sql1 = db.Queryable <base_location>() .JoinTable <base_wh_warehouse>((s1, s2) => s1.wh_id == s2.wh_id) .Where("s1.del_flag=1 and s2.del_flag=1") .OrderBy("s1.locat_id DESC"); if (!string.IsNullOrWhiteSpace(locat_code)) { sql1 = sql1.Where(s1 => s1.locat_code.Contains(locat_code)); } if (wh_id > 0) { sql1 = sql1.Where(s1 => s1.wh_id == wh_id); } totil = sql1.Count(); var jList = sql1.Skip(onepagecount * (pagenum - 1)).Take(onepagecount) .Select <StorageBinModel>("s1.locat_id,s1.wh_id,s1.locat_code,s1.create_time,s2.wh_name") .ToList(); if (jList.Count > 0) { foreach (var item in jList) { var sql = db.Queryable <base_wh_stock>() .Where(" del_flag=1 and location_id=" + item.locat_id + " and wh_id=" + item.wh_id + "") .GroupBy("location_id,wh_id") .Select <StorageBinModel>("location_id,wh_id, SUM(stock_qty) AS stock_qty") .SingleOrDefault(); if (sql != null) { item.stock_qty = sql.stock_qty; } else { item.stock_qty = 0; } item.create_timeE = item.create_time.ToString("yyyy-MM-dd"); } } totilpage = totil / onepagecount; exmsg = ""; if (totil % onepagecount > 0) { totilpage++; } return(jList.ToList()); } catch (Exception ex) { exmsg = ex.ToString(); totil = 0; totilpage = 0; return(null); } } }
/// <summary> /// 基于原生Sql的查询 /// </summary> private void SqlQuery() { using (var db = SugarDao.GetInstance()) { //转成list List <Student> list1 = db.SqlQuery <Student>("select * from Student"); //转成list带参 List <Student> list2 = db.SqlQuery <Student>("select * from Student where id=@id", new { id = 1 }); //转成dynamic dynamic list3 = db.SqlQueryDynamic("select * from student"); //转成json string list4 = db.SqlQueryJson("select * from student"); //返回int var list5 = db.SqlQuery <int>("select top 1 id from Student").SingleOrDefault(); //反回键值 Dictionary <string, string> list6 = db.SqlQuery <KeyValuePair <string, string> >("select id,name from Student").ToDictionary(it => it.Key, it => it.Value); //反回List<string[]> var list7 = db.SqlQuery <string[]>("select top 1 id,name from Student").SingleOrDefault(); //存储过程 var spResult = db.SqlQuery <School>("exec sp_school @p1,@p2", new { p1 = 1, p2 = 2 }); //获取第一行第一列的值 string v1 = db.GetString("select '张三' as name"); int v2 = db.GetInt("select 1 as name"); double v3 = db.GetDouble("select 1 as name"); decimal v4 = db.GetDecimal("select 1 as name"); //.... } }
/// <summary> /// 根据类型获取订单列表 /// </summary> /// <param name="type">1入库 2出库</param> /// <param name="strWhere">查询sql</param> /// <param name="orderCount">列表总数</param> /// <returns></returns> public List <OrderListDto> GetOrderListByType(int type, string strWhere, int pageIndex, int pageSize, out int orderCount) { var list = new List <OrderListDto>(); try { using (var db = SugarDao.GetInstance()) { list = db.Queryable <Domain.Model.Order>() .JoinTable <BasicDictionary>((o, gys) => o.SupplierId == gys.Id) .JoinTable <Sys_User>((o, u) => o.CreateUserId == u.Account) .Where($" Status>=0 and Type={type} {strWhere}") .Select <OrderListDto>("o.Id,o.OrderNum,o.SupplierId,gys.Name SupplierName,u.Name CreateUserName,o.CreateTime,o.Status") .OrderBy(o => o.Status, OrderByType.Asc) .OrderBy(o => o.Id, OrderByType.Desc) .ToPageList(pageIndex, pageSize); orderCount = db.Queryable <Domain.Model.Order>() .JoinTable <BasicDictionary>((o, gys) => o.SupplierId == gys.Id) .JoinTable <Sys_User>((o, u) => o.CreateUserId == u.Account) .Where($" Status>=0 and Type={type} {strWhere}").Count(); } return(list); } catch (Exception) { throw; } return(list); }
private void SetExtraMoney_Load(object sender, EventArgs e) { textBox_msg.Text = "请选择附加费用类型"; textBox_money.Focus(); using (var db = SugarDao.GetInstance()) { var model = db.Queryable <JobExtra>().FirstOrDefault(); if (model == null) { return; } _gluing = model.ExtraGluing; SetBtnStyle(button_gluing, _gluing); _typesetting = model.ExtraTypesetting; SetBtnStyle(button_typesetting, _typesetting); _copy = model.ExtraCopy; SetBtnStyle(button_copy, _copy); _scan = model.ExtraScan; SetBtnStyle(button_scan, _scan); _other = model.ExtraOther; SetBtnStyle(button_other, _other); textBox_money.Text = model.ExtraPrice > 0?model.ExtraPrice.ToString(CultureInfo.InvariantCulture):""; } }
public void Init() { Console.WriteLine("启动SqlPageModel.Init"); using (var db = SugarDao.GetInstance()) { try { db.PageModel = PageModel.Offset; //启用Sql2012的方式进行分页(默认:RowNumber) var list = db.Queryable <Student>().OrderBy("id").Skip(0).Take(2).ToList(); var list1 = db.Sqlable().From <Student>("t").SelectToPageList <Student>("*", "id", 1, 2); List <School> dataPageList = db.Sqlable() .From("school", "s") .Join("student", "st", "st.id", "s.id", JoinType.Inner) .Join("student", "st2", "st2.id", "st.id", JoinType.Left) .Where("s.id>100 and s.id<100") .SelectToPageList <School>("st.*", "s.id", 1, 10); db.PageModel = PageModel.RowNumber; var list2 = db.Queryable <Student>().OrderBy("id").Skip(0).Take(2).ToList(); var list22 = db.Sqlable().From <Student>("t").SelectToPageList <Student>("*", "id", 1, 2); } catch (Exception ex) { throw new Exception("该Demo要求SqlSever版本为2012及以上版本,错误信息:" + ex.Message); } } }
protected void btnCreateClassCode_Click(object sender, EventArgs e) { using (var db = SugarDao.GetInstance()) { txtResult.Value = db.ClassGenerating.SqlToClass(db, txtSql.Text, txtClassName.Text); } }
public string SelectSinglePk(string num) { try { using (var db = SugarDao.GetInstance()) { int i = int.Parse(num); Student singleByPk = db.Queryable <Student>().InSingle(i); if (singleByPk != null) { string msg = string.Format("ID号:{0},名字:{1},学校号:{2}", singleByPk.id, singleByPk.name, singleByPk.sch_id); return(retMsg("查询单条根据主键", msg)); } else { return(retMsg("查询单条根据主键", "没报错--没找到对应数据")); } } } catch (Exception e) { Console.WriteLine(e); return(retMsg("查询单条根据主键", "报错--没找到对应数据")); } }
public string Single2(string num) { try { using (var db = SugarDao.GetInstance()) { int i = int.Parse(num); Student singleByPk = db.Queryable <Student>().Where(c => c.id == i).SingleOrDefault(); if (singleByPk != null) { string msg = string.Format("ID号:{0},名字:{1},学校号:{2}", singleByPk.id, singleByPk.name, singleByPk.sch_id); return(retMsg("查询单条没有记录返回空对象2", msg)); } else { return(retMsg("查询单条没有记录返回空对象2", "没报错--返回空对象")); } } } catch (Exception e) { Console.WriteLine(e); return(retMsg("查询单条没有记录返回空对象2", "报错--没找到对应数据")); } }
public string InSelect(string textBox5Text) { try { using (var db = SugarDao.GetInstance()) { var intArray = new[] { "4", "2", "3" }; var intList = intArray.ToList(); var listNew = db.Queryable <Student>().Where(x => intArray.Contains(x.name)).ToJson(); var list0 = db.Queryable <Student>().In(it => it.id, 1, 2, 3).ToJson(); var list1 = db.Queryable <Student>().In(it => it.id, intArray).ToJson(); var list2 = db.Queryable <Student>().In("id", intArray).ToJson(); var list3 = db.Queryable <Student>().In(it => it.id, intList).ToJson(); var list4 = db.Queryable <Student>().In("id", intList).ToJson(); var list6 = db.Queryable <Student>().In(intList).ToJson();//不设置字段默认主键 string msg = string.Format("\nlistNew :\r\n{0}\n list0\r\n{1} \nlist1\r\n{2}\nlist2\r\n{3}\nlist3\r\n{4}\nlist4\r\n{5}\nlist6\r\n{6}", listNew, list0, list1, list2, list3, list4, list6); return(retMsg("in操作", msg)); } } catch (Exception e) { Console.WriteLine(e); return(retMsg("in操作", "报错了!!!!")); } }
public string SoftData(string textBox4Text) { try { using (var db = SugarDao.GetInstance()) { string msg = ""; var orderList = db.Queryable <Student>().OrderBy(textBox4Text).ToList(); //字符串支持多个排序 //可以多个order by表达示 var order2List = db.Queryable <Student>().OrderBy(it => it.name).OrderBy(it => it.id, OrderByType.Desc).ToList(); // order by name as ,order by id desc foreach (Student student in orderList) { msg += string.Format(" ID号:{0},名字:{1},学校号:{2} \r\n", student.id, student.name, student.sch_id); } string msg2 = ""; foreach (Student student in order2List) { msg2 += string.Format(" ID号:{0},名字:{1},学校号:{2} \r\n", student.id, student.name, student.sch_id); } return(retMsg("排序", "正序" + msg + "\r\n" + "倒序" + msg2)); } } catch (Exception e) { Console.WriteLine(e); return(retMsg("排序", "报错了!!!!")); } }
public string LikeAnUnlike(string text) { try { using (var db = SugarDao.GetInstance()) { string msg = ""; List <Student> notLike = db.Queryable <Student>().Where(c => !c.name.Contains(text)).ToList(); foreach (Student student in notLike) { msg += string.Format(" ID号:{0},名字:{1},学校号:{2} \r\n", student.id, student.name, student.sch_id); } string msg2 = ""; List <Student> like = db.Queryable <Student>().Where(c => c.name.Contains(text)).ToList(); foreach (Student student in like) { msg2 += string.Format(" ID号:{0},名字:{1},学校号:{2} \r\n", student.id, student.name, student.sch_id); } return(retMsg("Not like", msg) + "\r\n" + retMsg("Like", msg2)); } } catch (Exception e) { Console.WriteLine(e); return(retMsg("取前X条", "报错了!!!!")); } }
/// <summary> /// 获取用户列表 /// </summary> /// <param name="total">结果总条数</param> /// <param name="take">每页条数</param> /// <param name="skip">页数</param> /// <param name="searchParams">查询条件</param> /// <returns>用户列表</returns> public IEnumerable <IEntityBase> GetList(ref int total, int take, int skip, Dictionary <string, string> searchParams) { using (var db = SugarDao.GetInstance()) { return(null); } }
/// <summary> /// 判断扫描的包裹号在系统中是否存在且未删除 /// </summary> /// <param name="packgecode"></param> /// <returns></returns> public static int CheckPackge(string packgecode) { using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring())) { try { busi_sendorder packge = db.Queryable <busi_sendorder>().Where(s => s.order_code == packgecode).FirstOrDefault(); if (null == packge) { return(1);//代表包裹不存在系统中 } else { busi_sendorder packge2 = db.Queryable <busi_sendorder>().Where(s => s.order_code == packgecode).Where(s => s.del_flag == true).FirstOrDefault(); if (null == packge2) { return(2); //代表包裹被删除 } else { return(3); //包裹存在,正常 } } } catch (Exception ex) { throw ex; } } }
/// <summary> /// 使用用户名获取用户 /// </summary> /// <param name="userId">用户名</param> /// <param name="accId">账套Id</param> /// <returns>用户</returns> public M_User GetUserById(string userId, string accId) { try { var db = SugarDao.GetInstance(); var id = new Guid(accId); var queryable = db.Queryable <M_User, M_UserAcc>((s1, s2) => new object[] { JoinType.Inner, s1.UserName == s2.UserId }); queryable = queryable.Where((s1, s2) => s1.UserName == userId && s2.AccId == id && s1.DelFlg != false && s2.DelFlg != false); var result = queryable.SingleAsync(); result.Wait(); return(result.Result); } catch (Exception ex) { LogHelper.Error(ex); return(null); } }
public static List <PackgePrintInfo> GetPckgePrintInfo(string packgecode) { using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring())) { try { List <PackgePrintInfo> packinfo = db.Queryable <busi_sendorder_detail>().JoinTable <busi_sendorder>((s1, s2) => s1.order_id == s2.order_id) .JoinTable <base_prod_code>((s1, s3) => s1.code_id == s3.code_id) .Where <busi_sendorder>((s1, s2) => s2.order_code == packgecode) .Select <busi_sendorder, base_prod_code, PackgePrintInfo>((s1, s2, s3) => new PackgePrintInfo() { expressid = s2.express_id, ExpCode = s2.exp_code, zipcode = s2.receive_zip, mobile = s2.receive_mobile, phone = s2.receive_phone, address = s2.receive_address, name = s2.receive_name, count = s2.prod_num, skucode = s3.sku_code, skunum = s1.prod_num.ObjToInt() }).ToList(); return(packinfo); } catch (Exception ex) { throw ex; } } }
private void button_no_Click(object sender, EventArgs e) { _gluing = false; SetBtnStyle(button_gluing, _gluing); _typesetting = false; SetBtnStyle(button_typesetting, _typesetting); _copy = false; SetBtnStyle(button_copy, _copy); _scan = false; SetBtnStyle(button_scan, _scan); _other = false; SetBtnStyle(button_other, _other); textBox_money.Text = ""; using (var db = SugarDao.GetInstance()) { var model = db.Queryable <JobExtra>().FirstOrDefault(); if (model == null) { return; } db.Update <JobExtra>(new { ExtraGluing = false, ExtraTypesetting = false, ExtraCopy = false, ExtraScan = false, ExtraOther = false, ExtraPrice = 0 }, it => it.Id == model.Id); } }
/// <summary> /// 更新信息 /// </summary> /// <param name="purch_id"></param> /// <param name="express_id"></param> /// <param name="express_code"></param> /// <param name="express_name"></param> /// <param name="OrderCode"></param> /// <returns></returns> public MaterialReceiptResult Modify(Int64?purch_id, Int64?express_id, string express_code, string express_name, string OrderCode) { bool rstNum = false; MaterialReceiptResult result = new MaterialReceiptResult(); using (var db = SugarDao.GetInstance(LoginUser.GetConstr())) { db.BeginTran(); var list = db.Queryable <busi_purchase>().Where(s => s.del_flag).InSingle(purch_id.Value); if (list == null) { db.RollbackTran(); result.success = false; result.Msg = "无效的采购信息,操作失败!"; return(result); } rstNum = db.Update <busi_purchase>(new { purch_status = 3, express_id = express_id, express_code = express_code, express_name = express_name, OrderCode = OrderCode }, a => a.purch_id == purch_id && a.purch_status == 3); if (rstNum) { db.CommitTran(); result.success = true; result.Msg = "操作成功"; return(result); } else { db.RollbackTran(); result.success = false; result.Msg = "操作失败"; return(result); } } }
/// <summary> /// 获取库存详情 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="count"></param> /// <param name="locat_id"></param> /// <returns></returns> public List <StorageBinModel> GetStorageBinEList(out string exmsg, long?wh_id, long?locat_id) { using (var db = SugarDao.GetInstance(LoginUser.GetConstr())) { if (wh_id == 0 || locat_id == 0) { exmsg = "参数错误!"; return(null); } try { var sql = db.Queryable <base_wh_stock>() .JoinTable <base_wh_warehouse>((s1, s2) => s1.wh_id == s2.wh_id) .JoinTable <base_product>((s1, s3) => s3.prod_id == s1.prod_id) .JoinTable <base_location>((s1, s5) => s1.location_id == s5.locat_id) .JoinTable <base_prod_code>((s1, s6) => s6.code_id == s1.code_id) .Where("s1.del_flag=1 and s2.del_flag=1 and s3.del_flag=1 and s5.del_flag=1 and s6.del_flag=1 and s1.wh_id=" + wh_id + " and s1.location_id=" + locat_id + "") .GroupBy(" s1.code_id, s1.wh_id, s1.location_id, s6.sku_code, s1.stock_qty, s2.wh_name, s3.prod_title, s5.locat_code") .Select <StorageBinModel>(" s6.sku_code, s1.stock_qty, s2.wh_name, s3.prod_title, s5.locat_code").ToList(); exmsg = ""; return(sql.ToList()); } catch (Exception ex) { exmsg = ex.ToString(); return(null); } } }
public void OldMethod() { //请在页面加上参数id=1 using (SqlSugarClient db = SugarDao.GetInstance()) //开启数据库连接 { db.IsGetPageParas = true; //使用无参模式直接将Requst中的ID传给@id无需在代码中写出来 var kvs = SqlSugarTool.GetParameterDictionary(); //获取QqueryString和Form参数集合 var list = db.Queryable <Student>(); if (!string.IsNullOrEmpty(Request["id"])) { list = list.Where(it => it.id == Convert.ToInt32(kvs["name"])); } //if (!string.IsNullOrEmpty(Request["id"])) //{ // list = list.Where(it => it.Sex == Convert.ToInt32(kvs["Sex"])); //} //if (!string.IsNullOrEmpty(Request["id"])) //{ // list = list.Where(it => it.xxx == Convert.ToInt32(kvs["xxx"])); //} //if (!string.IsNullOrEmpty(Request["id"])) //{ // list = list = list.Where(it => it.xxxx == Convert.ToInt32(kvs["xxxxx"])); //} //获取页面所有参数到键值对 //var kvs= SqlSugarTool.GetParameterDictionary(); } }
/// <summary> /// 获取商品信息 /// </summary> /// <returns></returns> public ShopResult GetShopList() { ShopResult result = new ShopResult(); using (var db = SugarDao.GetInstance(LoginUser.GetConstr())) { try { var list = db.Queryable <base_shop>().Where(a => a.del_flag).OrderBy("shop_id DESC").ToList(); if (list.Count <= 0) { result.success = false; result.Msg = "暂无店铺信息!"; return(result); } var list1 = "<option value=\"0\">请选择...</option>"; foreach (var item in list) { list1 += "<option value=\"" + item.shop_id + "\">" + item.shop_name + "</option>"; } result.success = true; result.Msg = list1; return(result); } catch (Exception ex) { result.success = false; result.Msg = "获取店铺信息失败!"; return(result); } } }
/// <summary> /// 打印插件信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void label5_DoubleClick(object sender, EventArgs e) { NewXmlControl xmlfile2 = new NewXmlControl(Comm.StartupPath + "//config//regedit.xml", false, "Passport"); string ID = xmlfile2.ReadNodeInnerText("/Passport/ID[1]"); using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring())) { try { //获取配置的插件信息 var obj = db.Queryable <base_print>().Where(s => s.p_id == Convert.ToInt32(ID)).FirstOrDefault(); if (null == obj) { MessageBox.Show("此打印插件在系统中不存在"); return; } else { MessageBox.Show("打印插件名称:" + obj.p_name, "提示"); return; } } catch (Exception ex) { throw ex; } } }
public void Init() { Console.WriteLine("启动Inset.Init"); using (var db = SugarDao.GetInstance()) { db.Insert(GetInsertItem()); //插入一条记录 (有主键也好,没主键也好,有自增列也好都可以插进去) db.InsertRange(GetInsertList()); //批量插入 支持(别名表等功能) db.SqlBulkCopy(GetInsertList()); //批量插入 适合海量数据插入 //设置不插入列 db.DisableInsertColumns = new string[] { "sex" };//sex列将不会插入值 Student s = new Student() { name = "张" + new Random().Next(1, int.MaxValue), sex = "gril" }; var id = db.Insert(s); //插入 //查询刚插入的sex是否有值 var sex = db.Queryable <Student>().Single(it => it.id == id.ObjToInt()).sex; //无值 var name = db.Queryable <Student>().Single(it => it.id == id.ObjToInt()).name; //有值 //SqlBulkCopy同样支持不挺入列设置 db.SqlBulkCopy(GetInsertList()); } }
/// <summary> /// 设置打印插件在线状态 /// </summary> /// <returns></returns> private int online(int on) //on=0,离线,on=1,在线 { NewXmlControl xmlfile2 = new NewXmlControl(Comm.StartupPath + "//config//regedit.xml", false, "Passport"); string ID = xmlfile2.ReadNodeInnerText("/Passport/ID[1]"); int p_id = Convert.ToInt32(ID); using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring())) { try { //获取配置的插件信息 var obj = db.Queryable <base_print>().Where(s => s.del_flag == 0).Where(s => s.p_id == p_id).FirstOrDefault(); if (null == obj) { return(0); //"打印插件未在系统中注册或者被删除了!"; } else { var isok = db.Update <base_print>(new { isonline = on }, s => s.p_id == p_id); if (isok) { return(1);//"启动成功"; } else { return(2);//"启动失败"; } } } catch (Exception ex) { throw ex; } } }
private void btn_save_Click(object sender, EventArgs e) { try { if (string.IsNullOrWhiteSpace(txt_name.Text.Trim())) { XtraMessageBox.Show("请您输入药品名称!"); return; } var entity = new Domain.Model.Medicine() { Id = detailId, Name = txt_name.Text.Trim(), NameCode = Pinyin.GetInitials(Pinyin.ConvertEncoding(txt_name.Text.Trim(), Encoding.UTF8, Encoding.GetEncoding("GB2312")), Encoding.GetEncoding("GB2312"))?.ToLower(), CommonName = txt_commonName.Text.Trim(), CommonNameCode = string.IsNullOrWhiteSpace(txt_commonName.Text.Trim()) ? "" : Pinyin.GetInitials(Pinyin.ConvertEncoding(txt_commonName.Text.Trim(), Encoding.UTF8, Encoding.GetEncoding("GB2312")), Encoding.GetEncoding("GB2312"))?.ToLower(), JYFWId = lue_ssjyfw.EditValue == null ? 0 : int.Parse(lue_ssjyfw.EditValue.ToString()), BZGG = txt_bzgg.Text.Trim(), UnitId = lue_unit.EditValue == null ? 0 : int.Parse(lue_unit.EditValue.ToString()), TypeId = lue_type.EditValue == null ? 0 : int.Parse(lue_type.EditValue.ToString()), JGFLId = lue_jgfl.EditValue == null ? 0 : int.Parse(lue_jgfl.EditValue.ToString()), SupplierId = lue_gys.EditValue == null ? 0 : int.Parse(lue_gys.EditValue.ToString()), SCCJId = lue_sccj.EditValue == null ? 0 : int.Parse(lue_sccj.EditValue.ToString()), CPZC = txt_cpzc.Text.Trim(), PZWH = date_pzwh.Text.Trim(), IsPrescription = ckb_isPrescription.Checked, Status = 1, }; using (var db = SugarDao.GetInstance()) { if (Convert.ToBoolean(db.InsertOrUpdate(entity))) { string msg = detailId > 0 ? $"【修改成功】 " : $"【新增成功】"; Log.Info(new LoggerInfo() { LogType = LogType.药品信息.ToString(), CreateUserId = UserInfo.Account, Message = msg + $"药品Id:{entity.Id},药品名称:{entity.Name},药品简写:{entity.NameCode},药品通用名称:{entity.CommonName}" + $",药品通用名称简写:{entity.CommonNameCode},经营范围:{lue_ssjyfw.Text},药品规格:{txt_bzgg.Text},药品单位:{lue_unit.Text}" + $",药剂分类:{lue_type.Text},监管分类:{lue_jgfl.Text},供应商:{lue_gys.Text},生产厂家:{lue_sccj.Text},产品注册证批件号:{txt_cpzc.Text.Trim()}" + $",批准文号有效期:{ date_pzwh.Text.Trim()},是否处方药:{(entity.IsPrescription ? "是" : "否")}" }); DialogResult = DialogResult.OK; this.Close(); } else { DialogResult = DialogResult.Cancel; } } } catch (Exception) { throw; } }
public void Init() { Console.WriteLine("启动Deletes.Init"); using (var db = SugarDao.GetInstance()) { //删除根据主键 db.Delete <School, int>(10); //删除根据表达示 db.Delete <School>(it => it.id > 100);//支持it=>array.contains(it.id) //主键批量删除 db.Delete <School, string>(new string[] { "100", "101", "102" }); //非主键批量删除 db.Delete <School, string>(it => it.name, new string[] { "" }); db.Delete <School, int>(it => it.id, new int[] { 20, 22 }); //根据实体赋值实体一定要有主键,并且要有值。 db.Delete(new School() { id = 200 }); //根据字符串删除 db.Delete <School>("id=@id", new { id = 100 }); //假删除 //db.FalseDelete<school>("is_del", 100); //等同于 update school set is_del=1 where id in(100) //db.FalseDelete<school>("is_del", it=>it.id==100); } }
public void Init() { Student2 p = new Student2() { id = 2, name = "张表", isOk = true }; Console.WriteLine("启动Test.Init"); using (var db = SugarDao.GetInstance()) { //初始化数据 InitData(db); //查询测试 Select(p, db); //拉姆达测试 Exp(p, db); //新容器转换测试 SelectNew(p, db); //更新测试 Update(p, db); //删除测试 Delete(p, db); } }
public string SingleFieldList() { try { using (var db = SugarDao.GetInstance()) { List <int> list = db.Queryable <Student>().Select <int>(x => x.id).ToList(); if (list.Count > 0) { string msg = ""; foreach (int li in list) { msg += "ID:" + li + "\t"; } return(retMsg("查询所有的Id", msg)); } else { return(retMsg("查询所有的Id", "数组为0")); } } } catch (Exception e) { Console.WriteLine(e); return(retMsg("查询所有的Id", "报错了!!!!")); } }