//全部重排 private void reArrange_all_techs(BathDBDataContext dc) { dc.ExecuteCommand("truncate table techindex"); dc.SubmitChanges(); var job_ids = dc.Job.Where(x => x.name.Contains("技师")).Select(x => x.id); foreach (var job_id in job_ids) { var techs = dc.Employee.Where(x => x.jobId == job_id); techs = techs.Where(x => x.techStatus == null || x.techStatus == "空闲" || x.techStatus == "待钟"); var techs_male = techs.Where(x => x.gender == "男"); var techIndex = new TechIndex(); techIndex.dutyid = job_id; techIndex.gender = "男"; techIndex.ids = string.Join("%", techs_male.OrderBy(x => x.id).Select(x => x.id + "=T").ToArray()); dc.TechIndex.InsertOnSubmit(techIndex); var techs_female = techs.Where(x => x.gender == "女"); techIndex = new TechIndex(); techIndex.dutyid = job_id; techIndex.gender = "女"; techIndex.ids = string.Join("%", techs_female.OrderBy(x => x.id).Select(x => x.id + "=T").ToArray()); dc.TechIndex.InsertOnSubmit(techIndex); } dc.SubmitChanges(); }
//获取系统账号 public static string systemId(BathDBDataContext db, string connectionString) { string today = BathClass.Now(connectionString).ToString("yyyyMMdd"); string max_id = db.SystemIds.Max(x => x.systemId); long maxId = 0; if (max_id != null) { if (max_id.Contains(today)) { maxId = Convert.ToInt64(max_id.Replace(today, "")); } else { db.ExecuteCommand("TRUNCATE TABLE SystemIds"); } } return(today + (maxId + 1).ToString().PadLeft(5, '0')); }
private void do_work() { try { if (cl.GetItemChecked(0))//账单记录 { db.Account.DeleteAllOnSubmit(db.Account.Where(x => x.payTime > st && x.payTime < et)); } if (cl.GetItemChecked(1))//吧台消息记录 { db.BarMsg.DeleteAllOnSubmit(db.BarMsg.Where(x => x.time > st && x.time < et)); } if (cl.GetItemChecked(2))//售卡充值记录 { db.CardSale.DeleteAllOnSubmit(db.CardSale.Where(x => x.payTime > st && x.payTime < et)); } if (cl.GetItemChecked(3))//前台打印时间记录 { db.CashPrintTime.DeleteAllOnSubmit(db.CashPrintTime.Where(x => x.time > st && x.time < et)); } if (cl.GetItemChecked(4))//优惠券设置记录 { db.Coupon.DeleteAllOnSubmit(db.Coupon.Where(x => x.issueDate > st && x.issueDate < et)); } if (cl.GetItemChecked(5))//团购记录 { db.GroupBuy.DeleteAllOnSubmit(db.GroupBuy.Where(x => x.issueDate > st && x.issueDate < et)); } if (cl.GetItemChecked(6))//支出记录 { db.Expense.DeleteAllOnSubmit(db.Expense.Where(x => x.inputDate > st && x.inputDate < et)); } if (cl.GetItemChecked(7))//订单记录 { db.HisOrders.DeleteAllOnSubmit(db.HisOrders.Where(x => x.inputTime > st && x.inputTime < et)); } if (cl.GetItemChecked(8))//异常操作记录 { db.Operation.DeleteAllOnSubmit(db.Operation.Where(x => x.opTime > st && x.opTime < et)); } if (cl.GetItemChecked(9))//摄像头录像消息记录 { db.ExecuteCommand("truncate table paymsg"); } if (cl.GetItemChecked(10))//催钟记录 { db.ExecuteCommand("truncate table roomcall"); } if (cl.GetItemChecked(11))//房间预警记录 { db.ExecuteCommand("truncate table roomwarn"); } if (cl.GetItemChecked(12))//鞋吧消息记录 { db.ExecuteCommand("truncate table shoemsg"); } db.SubmitChanges(); } catch (System.Exception e) { this.Invoke(new print_msg_delegate(BathClass.printErrorMsg), new object[] { e.ToString() }); } finally { if (m_form != null) { this.Invoke(new no_par_delegate(close_form)); } } }