示例#1
0
        //全部重排
        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);
        }
示例#2
0
        //男技师重排
        private void BtnRearrangeMale_Click(object sender, EventArgs e)
        {
            var dc = new BathDBDataContext(m_con_str);

            string typeSelName = seatTypeTree.SelectedNode.Text;

            if (typeSelName == "所有技师")
                return;

            var job_id = dc.Job.FirstOrDefault(x => x.name == typeSelName).id;
            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 = dc.TechIndex.FirstOrDefault(x => x.dutyid == job_id && x.gender == "男");
            bool new_techIndex = false;
            if (techIndex == null)
            {
                new_techIndex = true;
                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());

            if (new_techIndex)
                dc.TechIndex.InsertOnSubmit(techIndex);

            dc.SubmitChanges();
            dgv_show(dc);
        }
示例#3
0
 partial void UpdateTechIndex(TechIndex instance);
示例#4
0
 partial void DeleteTechIndex(TechIndex instance);
示例#5
0
 partial void InsertTechIndex(TechIndex instance);