using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BLL
{
    /// <summary>
    /// 项目焊工
    /// </summary>
    public static class Welder_ProjectWelderService
    {
        /// <summary>
        /// 根据主键获取项目焊工
        /// </summary>
        /// <param name="projectWelderId"></param>
        /// <returns></returns>
        public static Model.Welder_ProjectWelder GetProjectWelderById(string projectWelderId)
        {
            return Funs.DB.Welder_ProjectWelder.FirstOrDefault(e => e.ProjectWelderId == projectWelderId);
        }

        /// <summary>
        /// 添加项目焊工
        /// </summary>
        /// <param name="projectWelder"></param>
        public static void AddProjectWelder(Model.Welder_ProjectWelder projectWelder)
        {
            Model.HJGLDB db = Funs.DB;
            Model.Welder_ProjectWelder newProjectWelder = new Model.Welder_ProjectWelder();
            newProjectWelder.ProjectWelderId = projectWelder.ProjectWelderId;
            newProjectWelder.WelderId = projectWelder.WelderId;
            newProjectWelder.ProjectId = projectWelder.ProjectId;
            newProjectWelder.UnitId = projectWelder.UnitId;
            newProjectWelder.TeamGroupId = projectWelder.TeamGroupId;
            db.Welder_ProjectWelder.InsertOnSubmit(newProjectWelder);
            db.SubmitChanges();
        }

        /// <summary>
        /// 修改项目焊工
        /// </summary>
        /// <param name="projectWelder"></param>
        public static void UpdateProjectWelder(Model.Welder_ProjectWelder projectWelder)
        {
            Model.HJGLDB db = Funs.DB;
            Model.Welder_ProjectWelder newProjectWelder = db.Welder_ProjectWelder.FirstOrDefault(e => e.ProjectWelderId == projectWelder.ProjectWelderId);
            if (newProjectWelder != null)
            {
                newProjectWelder.WelderId = projectWelder.WelderId;
                newProjectWelder.ProjectId = projectWelder.ProjectId;
                newProjectWelder.UnitId = projectWelder.UnitId;
                newProjectWelder.TeamGroupId = projectWelder.TeamGroupId;
                db.SubmitChanges();
            }
        }

        /// <summary>
        /// 根据主键删除项目焊工
        /// </summary>
        /// <param name="projectWelderId"></param>
        public static void DeleteProjectWelderById(string projectWelderId)
        {
            Model.HJGLDB db = Funs.DB;
            Model.Welder_ProjectWelder projectWelder = db.Welder_ProjectWelder.FirstOrDefault(e => e.ProjectWelderId == projectWelderId);
            if (projectWelder != null)
            {
                db.Welder_ProjectWelder.DeleteOnSubmit(projectWelder);
                db.SubmitChanges();
            }
        }

        /// <summary>
        /// 根据项目ID、单位ID删除所有相关焊工信息
        /// </summary>
        /// <param name="projectId"></param>
        /// <param name="unitId"></param>
        public static void DeleteProjectWelderByProjectId(string projectId, string unitId)
        {
            Model.HJGLDB db = Funs.DB;
            var pWelder = from x in db.Welder_ProjectWelder
                          join y in db.Welder_Welder on x.WelderId equals y.WelderId
                          where x.ProjectId == projectId && y.UnitId == unitId
                          select x;
            if (pWelder.Count() > 0)
            {
                db.Welder_ProjectWelder.DeleteAllOnSubmit(pWelder);
                db.SubmitChanges();
            }
        }

        public static Model.Welder_ProjectWelder GetProjectWelderByProjectIdAndWelderId(string projectId, string welderId)
        {
            return (from x in Funs.DB.Welder_ProjectWelder where x.ProjectId == projectId && x.WelderId == welderId select x).FirstOrDefault();
        }

        #region 项目焊工下拉项
        /// <summary>
        /// 项目焊工下拉项
        /// </summary>
        /// <param name="dropName"></param>
        /// <param name="isShowPlease"></param>
        /// <param name="projectId"></param>
        /// <param name="itemText"></param>
        public static void InitProjectWelderDropDownList(FineUIPro.DropDownList dropName, bool isShowPlease, string projectId,  string itemText)
        {
            dropName.DataValueField = "WelderId";
            dropName.DataTextField = "WelderCode";
            dropName.DataSource = from x in Funs.DB.Welder_Welder
                                  join y in Funs.DB.Welder_ProjectWelder on x.WelderId equals y.WelderId
                                  where y.ProjectId == projectId 
                                  select x;
            dropName.DataBind();
            if (isShowPlease)
            {
                Funs.FineUIPleaseSelect(dropName, itemText);
            }
            else
            {
                dropName.SelectedIndex = 0;
            }
        }
        #endregion
    }
}