//全部重排
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));
}
}
}