Beispiel #1
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 /// <param name="model">相应的数据实体</param>
 /// <returns>真表示有记录被更新,否表示没有记录被更新</returns>
 public bool Update(RelayTest.Model.ModelDEV_LOAD_CHANNEL_INFO model)
 {
     try
     {
         Log.Info("BllDEV_LOAD_CHANNEL_INFO->Update---START");
         ConnectionOpen();
         dal.SetDBAccess(GetDBAccess());
         return(dal.Update(model));
     }
     catch (Exception ex)
     {
         Log.Error("BllDEV_LOAD_CHANNEL_INFO->Update---FAILED", ex);
         throw ex;
     }
     finally
     {
         ConnectionClose();
         Log.Info("BllDEV_LOAD_CHANNEL_INFO->Update---finally");
     }
 }
Beispiel #2
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <RelayTest.Model.ModelDEV_LOAD_CHANNEL_INFO> DataTableToList(DataTable dt)
        {
            try
            {
                Log.Info("BllDEV_LOAD_CHANNEL_INFO->DataTableToList---START");
                ConnectionOpen();
                dal.SetDBAccess(GetDBAccess());
                List <RelayTest.Model.ModelDEV_LOAD_CHANNEL_INFO> modelList = new List <RelayTest.Model.ModelDEV_LOAD_CHANNEL_INFO>();
                int rowsCount = dt.Rows.Count;
                if (rowsCount > 0)
                {
                    RelayTest.Model.ModelDEV_LOAD_CHANNEL_INFO model;
                    for (int n = 0; n < rowsCount; n++)
                    {
                        model = new RelayTest.Model.ModelDEV_LOAD_CHANNEL_INFO();

                        //负载柜编号
                        model.F_LOAD_ID = dt.Rows[n]["F_LOAD_ID"].ToString();

                        //通道序号
                        model.F_LOAD_CHANNEL_ID = dt.Rows[n]["F_LOAD_CHANNEL_ID"].ToString();

                        //通道名称
                        model.F_LOAD_CHANNEL_NAME = dt.Rows[n]["F_LOAD_CHANNEL_NAME"].ToString();

                        //校准编号
                        model.F_LOAD_CHANNEL_CALIBRATION = dt.Rows[n]["F_LOAD_CHANNEL_CALIBRATION"].ToString();

                        //通道可用状态
                        if (dt.Rows[n]["F_LOAD_CHANNEL_STATUS"].ToString() != "")
                        {
                            model.F_LOAD_CHANNEL_STATUS = decimal.Parse(dt.Rows[n]["F_LOAD_CHANNEL_STATUS"].ToString());
                        }

                        //创建时间
                        if (dt.Rows[n]["F_CREATE_TIME"].ToString() != "")
                        {
                            model.F_CREATE_TIME = DateTime.Parse(dt.Rows[n]["F_CREATE_TIME"].ToString());
                        }

                        //操作员
                        model.F_OPERATOR_ID = dt.Rows[n]["F_OPERATOR_ID"].ToString();

                        //操作时间
                        if (dt.Rows[n]["F_OPERATIONTIME"].ToString() != "")
                        {
                            model.F_OPERATIONTIME = DateTime.Parse(dt.Rows[n]["F_OPERATIONTIME"].ToString());
                        }

                        //是否删除
                        if (dt.Rows[n]["F_DEL"].ToString() != "")
                        {
                            model.F_DEL = decimal.Parse(dt.Rows[n]["F_DEL"].ToString());
                        }


                        modelList.Add(model);
                    }
                }
                return(modelList);
            }
            catch (Exception ex)
            {
                Log.Error("BllDEV_LOAD_CHANNEL_INFO->DataTableToList---FAILED", ex);
                throw ex;
            }
            finally
            {
                ConnectionClose();
                Log.Info("BllDEV_LOAD_CHANNEL_INFO->DataTableToList---finally");
            }
        }