//全部重排 private void toolReArrange_Click(object sender, EventArgs e) { var dc = new BathDBDataContext(m_con_str); 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(); dgv_show(dc); }
//获取系统账号 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'); }