RuiTengJb/ICSSoft.AppSln/ICSSoft.Frame.Data.DAL/ICSIPQCKGROUP2LISTDAL.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ICSSoft.Frame.Data.Entity;
using ICSSoft.Base.Config.AppConfig;
using System.Data;
using System.Data.Sql;
using System.Data.Linq;

namespace ICSSoft.Frame.Data.DAL
{
    public class ICSIPQCKGROUP2LISTDAL
    {
        public static void AddandEdit(ICSIPQCKGROUP2LIST MODEL, string Appconstr)
        {
            FramDataContext db = new FramDataContext(Appconstr);
            db.Connection.Open();
            db.Transaction = db.Connection.BeginTransaction();
            try
            {
                bool isNew = false;
                var line = db.ICSIPQCKGROUP2LIST.SingleOrDefault(a => a.ID == MODEL.ID);

                if (line == null)
                {
                    isNew = true;
                    line = new ICSIPQCKGROUP2LIST();
                    line.ID = AppConfig.GetGuid(); ;
                }
                line.CKITEMCODE = MODEL.CKITEMCODE;
                line.CKGROUP = MODEL.CKGROUP;
                line.CKListCode = MODEL.CKListCode;
                line.CheckoutAttribute = MODEL.CheckoutAttribute;
                line.AQL = MODEL.AQL;
                line.InspectionStandard = MODEL.InspectionStandard;
                line.UNIT = MODEL.UNIT;
                line.IsUse = MODEL.IsUse;
                line.VALUEMAX =  MODEL.VALUEMAX;
                line.VALUEMIN = MODEL.VALUEMIN;

                line.IsCheck = MODEL.IsCheck;
                line.OPCode = MODEL.OPCode;
                line.CKWay = MODEL.CKWay;

                line.WorkPoint = MODEL.WorkPoint;
                line.MUSER = MODEL.MUSER;
                line.MUSERName = MODEL.MUSERName;
                line.MTIME = MODEL.MTIME;
                line.EATTRIBUTE1 = MODEL.EATTRIBUTE1;

                if (isNew)
                    db.ICSIPQCKGROUP2LIST.InsertOnSubmit(line);

                db.SubmitChanges();
                db.Transaction.Commit();
            }
            catch (Exception ex)
            {
                db.Transaction.Rollback();
                throw new Exception(ex.Message);
            }
        }

        public static void delete(List<String> guidList)
        {
            FramDataContext db = new FramDataContext(AppConfig.AppConnectString);
            db.Connection.Open();
            db.Transaction = db.Connection.BeginTransaction();
            try
            {
                //var lines = db.ICSOQCCKGROUP2LIST.Where(a => guidList.Contains(a.ID) && guidList.Contains(a.ID));
                //db.ICSOQCCKGROUP2LIST.DeleteAllOnSubmit(lines);

                db.SubmitChanges();
                db.Transaction.Commit();

            }
            catch (Exception ex)
            {
                db.Transaction.Rollback();
                throw ex;
            }
        }


        #region 导入
        public static void AddAndEditList(List<ICSIPQCKGROUP2LIST> ECCodeList, string Appconstr)
        {
            FramDataContext db = new FramDataContext(Appconstr);
            db.Connection.Open();
            db.Transaction = db.Connection.BeginTransaction();
            try
            {
                foreach (var ECCode in ECCodeList)
                {
                    bool isNew = false;
                    var line = db.ICSIPQCKGROUP2LIST.SingleOrDefault(a => a.ID == ECCode.ID);
                    if (line == null)
                    {
                        isNew = true;
                        line = new ICSIPQCKGROUP2LIST();
                        line.ID = AppConfig.GetGuid();
                    }
                    var code = db.ICSIPQCKGROUP2LIST.SingleOrDefault(a => a.CKITEMCODE == ECCode.CKITEMCODE && a.CKListCode == ECCode.CKListCode && a.CKGROUP == ECCode.CKGROUP);
                    if (code != null)
                    {
                        throw new Exception("料品编码码:" + ECCode.CKITEMCODE + "，检验项目组：" + ECCode.CKGROUP + ",检验项目:" + ECCode.CKListCode + ",检验属性：" + ECCode.CheckoutAttribute + "已存在!");
                    }
                    line.CKListCode = ECCode.CKListCode;
                    line.CKGROUP = ECCode.CKGROUP;
                    line.CKITEMCODE = ECCode.CKITEMCODE;
                    line.IsUse = ECCode.IsUse;
                    line.VALUEMAX = ECCode.VALUEMAX;

                    line.VALUEMIN = ECCode.VALUEMIN;
                    line.UNIT = ECCode.UNIT;
                    line.IsUse = ECCode.IsUse;
                    line.AQL = ECCode.AQL;
                    line.InspectionStandard = ECCode.InspectionStandard;
                    line.CheckoutAttribute = ECCode.CheckoutAttribute;

                    line.IsCheck = ECCode.IsCheck;
                    line.OPCode = ECCode.OPCode;
                    line.CKWay = ECCode.CKWay;



                    line.MUSER = ECCode.MUSER;
                    line.MUSERName = ECCode.MUSERName;
                    line.WorkPoint = ECCode.WorkPoint;
                    line.MTIME = ECCode.MTIME;
                    if (isNew) db.ICSIPQCKGROUP2LIST.InsertOnSubmit(line);
                }

                db.SubmitChanges();
                db.Transaction.Commit();
            }
            catch (Exception ex)
            {
                db.Transaction.Rollback();
                throw new Exception(ex.Message);
            }
        }
        #endregion
    }
}