车辆管理系统：初始化NFC和车辆的捆绑关系数据：UTB_V_VEH_CAR_NFC

2017-10-18 15:14:07  访问(1546) 赞(0) 踩(0)

using eKing.EkVehicleLib.Classes.BasicDatas;
using SlowX.Core.Model;
using SlowX.DAL.Helpers;
using System;
using System.Collections.Generic;
using System.Data;

namespace BPMS.WEB.WebForms.Tools.VVehCarNfcInit
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void OKClick(DBHelper xdbHelper)
        {
            int addCount = 0;
            int noAddCount = 0;

            bool bIsCreate = true;

            if (xdbHelper == null)
            {
                xdbHelper
                    =
                    SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
            }
            else
            {
                // 没有打开链接 //
                bIsCreate = xdbHelper.IsNotOpen();
            }

            try
            {
                if (bIsCreate)
                    xdbHelper.OpenDBHelper();

                DataSet ds = xdbHelper.ExecuteDataSet("select * from CAR_NFC");

                eKing.EkVehicleLib.Business.V.Veh.UTB_V_VEH_CAR_NFC 
                    bll
                    =
                    eKing.EkVehicleLib.Business.V.Veh.UTB_V_VEH_CAR_NFC.instance;

                eKing.EkVehicleLib.Entity.V.Veh.UTB_V_VEH_CAR_NFC
                    entity
                    =
                    new eKing.EkVehicleLib.Entity.V.Veh.UTB_V_VEH_CAR_NFC();

                

                List<BaseModel> theList =
                    eKing.EkVehicleLib.Business.VehicleMgr.VEHICLE.instance.ListAllBaseModel(xdbHelper);

                string strPLATE_NUMBER = null;
                string strNFC_GUID = null;
                VehicleShowName vsn = null;

                eKing.EkVehicleLib.Helpers.eKingEkVehicleLibHelper
                    ch
                    =
                    eKing.EkVehicleLib.Helpers.eKingEkVehicleLibHelper.cInstance;

                bool isAdd = false;
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    isAdd = false;
                    strPLATE_NUMBER = dr["PLATE_NUMBER"].ToString().Trim().ToLower();
                    strNFC_GUID = dr["NFC_GUID"].ToString().Trim();

                    if(strNFC_GUID .Length ==0||strPLATE_NUMBER.Length==0)
                        continue;

                     
                    foreach (eKing.EkVehicleLib.Model.VehicleMgr.VEHICLE model
                        in theList)
                    {
                        if (model.Del_Flag)
                            continue;

                          

                        vsn = ch.VehicleShowNameBuild(model.Plate_Number);

                        if(vsn == null||vsn.Plate_Number == null)
                            continue;

                        if (vsn.Plate_Number.Trim().ToLower() != strPLATE_NUMBER)
                            continue;

                        entity.i_isaveDriver.ClearAllISaveItem();
                        entity.i_isaveDriver.AddISaveItem(entity._ID, System.Guid.NewGuid().ToString());
                        entity.i_isaveDriver.AddISaveItem(entity._Vehicle_Id, model.ID);
                        entity.i_isaveDriver.AddISaveItem(entity._Nfc_Guid, strNFC_GUID);
                        entity.i_isaveDriver.AddISaveItem(entity._Bind_Time, DateTime.Now);
                        entity.i_isaveDriver.AddISaveItem(entity._CreateTime, DateTime.Now);
                        entity.i_isaveDriver.AddISaveItem(entity._EmVehCarNfcStatusV, (int)eKing.EkVehicleLib.Enums.VehCarNfcStatus.EmVehCarNfcStatus.正常);
                        entity.i_isaveDriver.AddISaveItem(entity._Insert_UserId, "System");
                        entity.i_isaveDriver.AddISaveItem(entity._Update_UserId, "System");
                        entity.i_isaveDriver.AddISaveItem(entity._UpdateTime, DateTime.Now);

                        bll.Insert(entity, xdbHelper);

                        ++addCount;
                        isAdd = true;
                    }

                    if (!isAdd)
                        ++noAddCount;
                }

                if (bIsCreate)
                    xdbHelper.EndDBHelper();

            }
            catch (Exception err)
            {
                if (bIsCreate)
                    xdbHelper.TranDBHelper();

                throw err;
            }
            finally
            {
                if (bIsCreate)
                    xdbHelper.FinallyDBHelper();
            }

            Response.Write(addCount.ToString() + "~" + noAddCount.ToString());

        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btn_OK_Click(object sender, EventArgs e)
        {
            try
            {
                OKClick(null);
            }
            catch (Exception err)
            {
                Response.Write(err.Message);
            }
        }
    }
}

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)