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

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

namespace ICSSoft.Frame.Data.DAL
{

    public class ICSFIRSTCHECKBYMODAL
    {



        #region 增加修改

        public static void AddAndEdit(List<FormICSFIRSTCHECKBYMOUIModel> checkList, string dsconn)
        {

            FramDataContext db = new FramDataContext(dsconn);
            db.Connection.Open();
            db.Transaction = db.Connection.BeginTransaction();
            try
            {
                foreach (FormICSFIRSTCHECKBYMOUIModel check in checkList)
                {

                    bool isNew = false;
                    var line = db.ICSFIRSTCHECKBYMO.SingleOrDefault(a => a.ID == check.ID);
                    if (line == null)
                    {
                        isNew = true;
                        line = new ICSFIRSTCHECKBYMO();
                        line.ID = AppConfig.GetGuid();
                        
                        
                    }
                    line.MOCODE = check.MOCODE;
                    line.CHECKDATE = Convert.ToDateTime(check.CHECKDATE);
                    line.CHECKRESULT = check.CHECKRESULT;
                    
                    line.MUSER = check.MUSER;
                    line.MUSERName = check.MUSERName;
                    line.MTIME = Convert.ToDateTime(check.MTIME);
                    line.WorkPoint = check.WorkPoint;
                    line.EATTRIBUTE1 = check.EATTRIBUTE1;

                    if (isNew)
                        db.ICSFIRSTCHECKBYMO.InsertOnSubmit(line);
                    db.SubmitChanges();
                }

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


        ////#region 班次代码是否存在
        ////public static bool IsIncludingShiftCode(string shiftcode, string dsconn)
        ////{

        ////    FramDataContext db = new FramDataContext(dsconn);
        ////    db.Connection.Open();
        ////    db.Transaction = db.Connection.BeginTransaction();
        ////    try
        ////    {
        ////        var line = db.ICSSHIFT.SingleOrDefault(a => a.SHIFTCODE == shiftcode);
        ////        if (line == null)
        ////            return true;
        ////        else
        ////            return false;
        ////    }
        ////    catch (Exception ex)
        ////    {
        ////        db.Transaction.Rollback();
        ////        throw ex;
        ////    }

        ////}
        ////#endregion



        //#region 班次次序是否存在
        //public static bool IsIncludingInShiftSeq(int shiftsqe, string shifttypeid)
        //{

        //    FramDataContext db = new FramDataContext(AppConfig.AppConnectString);
        //    db.Connection.Open();
        //    db.Transaction = db.Connection.BeginTransaction();
        //    try
        //    {
        //        var line = db.ICSSHIFT.SingleOrDefault(a => a.SHIFTSEQ == shiftsqe && a.SHIFTTYPEID == shifttypeid);
        //        if (line == null)
        //            return true;
        //        else
        //            return false;
        //    }
        //    catch (Exception ex)
        //    {
        //        db.Transaction.Rollback();
        //        throw ex;
        //    }

        //}
        //#endregion

        //#region 班次代码是否在时段维护中使用
        //public static bool isIncludingInICSTP(List<string> idList, string dsconn)
        //{
        //    FramDataContext db = new FramDataContext(dsconn);
        //    db.Connection.Open();
        //    db.Transaction = db.Connection.BeginTransaction();
        //    try
        //    {
        //        bool flag = false;
        //        var lines = db.ICSTP.Where(a => idList.Contains(a.SHIFTID));
        //        if (lines.Count() != 0)
        //            flag = true;

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

        //}
        //#endregion


        public static List<FormICSFIRSTCHECKBYMOUIModel> SearchCheckByCode(string id, string dsconn)
        {
            List<FormICSFIRSTCHECKBYMOUIModel> returnshift = new List<FormICSFIRSTCHECKBYMOUIModel>();
            string sql = @"select a.ID as ID,b.MOCODE as MOCODE,a.CHECKDATE as CHECKDATE,a.CHECKRESULT as CHECKRESULT,a.MUSERName as MUSERName,a.MTIME as MTIME
            from ICSFIRSTCHECKBYMO a
            left join ICSMO b on a.MOCODE=b.MOCODE
            where a.ID='{0}'";
            sql = string.Format(sql, id);
            DataTable dt = DBHelper.ExecuteDataset(dsconn, CommandType.Text, sql).Tables[0];
            foreach (DataRow dr in dt.Rows)
            {
                FormICSFIRSTCHECKBYMOUIModel shiftInfo = new FormICSFIRSTCHECKBYMOUIModel();
                shiftInfo.ID = dr["ID"].ToString();
                shiftInfo.icsmo = new FormICSMOUIModel();
                shiftInfo.icsmo.MOCODE = dr["MOCODE"].ToString();

                shiftInfo.CHECKDATE = Convert.ToDateTime(dr["CHECKDATE"]);
                shiftInfo.CHECKRESULT = dr["CHECKRESULT"].ToString();
                shiftInfo.MUSERName = dr["MUSERName"].ToString();
                shiftInfo.MTIME = System.DateTime.Parse(dr["MTIME"].ToString());
                
                if (!returnshift.Contains(shiftInfo))
                {
                    returnshift.Add(shiftInfo);
                }

            }
            return returnshift;

        }

//        public static DataTable SelectShiftTypeCode()
//        {
//            string sql = @"select SHIFTTYPECODE as [班制代码]
//            from dbo.ICSSHIFTTYPE
//            where 1=1";
//            sql = string.Format(sql);
//            DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sql).Tables[0];
//            return dt;
//        }

//        public static DataTable SelectShiftTypeId(string str)
//        {
//            string sql = @"select ID
//            from dbo.ICSSHIFTTYPE
//            where SHIFTTYPECODE='" + str + "'";
//            sql = string.Format(sql);
//            DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sql).Tables[0];
//            return dt;
//        }

        
         #region delete
        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.ICSFIRSTCHECKBYMO.Where(a => guidList.Contains(a.ID));
                db.ICSFIRSTCHECKBYMO.DeleteAllOnSubmit(lines);

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

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

//        public static DataTable GetShiftCode()
//        {
//            try
//            {
//                string sql = @"select TOP 1 [SHIFTCODE]
//  FROM [dbo].[ICSSHIFT] order by SHIFTCODE desc";
//                return DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sql).Tables[0];
//            }
//            catch (Exception ex)
//            {
//                throw ex;
//            }

//        }

        //        public static DataTable GetShiftSeqCode()
//        {
//            try
//            {
//                string sql = @"select TOP 1 [SHIFTSEQ]
//  FROM [dbo].[ICSSHIFT] order by [SHIFTTYPEID] desc";
//                return DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sql).Tables[0];
//            }
//            catch (Exception ex)
//            {
//                throw ex;
//            }

//        }


        }
    }