Gsmarket/Sources/GS-MarketMG-2018/DataTransfersLibs/SingleCheckData.cs

using System;
using System.Collections.Generic;
using System.Text;
using SysBaseLibs;
using SysDataLibs;
using SysDataLibs.TableClass ;

namespace DataTransfersLibs
{
    public class SingleCheckData : IErrorMsg
    {
        //<sample_no>0001</ sample_no >
        //<check_method>速测法</check_method >
        //<sub_category>叶菜</ sub_category >
        //<sample>青菜</ sample >
        //<check_item>残留农药</ check_item >
        //<result>1</ result >
        //<check_org>农业检测站</ check_org >
        //<region>长沙市</ region >
        //<check_district>江苏</ check_district >
        //<produce_org>农夫果园</ produce_org >
        //<checked_org>第一食品公司”</checked_org>
        //<checked_org_type>公司</ checked_org_type >
        //<rate>88.88</ rate >
        //<check_time>1979-09-16</ check_time >
        //<operator>张三</ operator >
        //<hardware_no>HW12345678</ hardware_no >
        //<MachineMaker>fuchun</MachineMaker>
        //<Memo>备注</Memo>
        public SingleCheckData(rsXmlNode poNode)
        {
            if (poNode != null)
            {
                _sample_no = poNode.GetChildValue("sample_no");
                _check_method = poNode.GetChildValue("check_method");
                _sub_category = poNode.GetChildValue("sub_category");
                _sample = poNode.GetChildValue("sample");
                _check_item = poNode.GetChildValue("check_item");
                _result = poNode.GetChildValue("result");
                _check_org = poNode.GetChildValue("check_org");
                _region = poNode.GetChildValue("region");
                _check_district = poNode.GetChildValue("check_district");
                _produce_org = poNode.GetChildValue("produce_org");
                _checked_org = poNode.GetChildValue("checked_org");
                _checked_org_type = poNode.GetChildValue("checked_org_type");
                _rate = poNode.GetChildValue("rate");
                _check_time = poNode.GetChildValue("check_time");
                _operator = poNode.GetChildValue("operator");
                _hardware_no = poNode.GetChildValue("hardware_no");
                _MachineMaker = poNode.GetChildValue("MachineMaker");
                _Memo = poNode.GetChildValue("Memo");
            }
        }

        #region Properties
        string _ErrorMsg = "";
        public string ErrorMsg
        {
            get { return _ErrorMsg; }
            set { _ErrorMsg = value; }
        }
        /// <summary>
        /// 采样编号
        /// </summary>
        string _sample_no = "";
        public string sample_no
        {
            get { return _sample; }
        }
        /// <summary>
        /// 检测方法  速测法
        /// </summary>
        string _check_method = "";
        /// <summary>
        /// 检测项目 残留农药
        /// </summary>
        string _check_item = "";

        /// <summary>
        /// 所属小类
        /// </summary>
        string _sub_category = "";
        /// <summary>
        /// 样品名字
        /// </summary>
        string _sample = "";

        /// <summary>
        /// 结论0表示不合格，1表示合格
        /// </summary>
        string _result = "";
        /// <summary>
        /// 检测单位id
        /// </summary>
        string _check_org = "";
        /// <summary>
        /// 地区id
        /// </summary>
        string _region = "";
        /// <summary>
        /// 产地
        /// </summary>
        string _check_district = "";
        /// <summary>
        /// 生产单位
        /// </summary>
        string _produce_org = "";
        /// <summary>
        /// 被检单位
        /// </summary>
        string _checked_org = "";
        /// <summary>
        /// 被检单位类型
        /// </summary>
        string _checked_org_type = "";
        /// <summary>
        /// 实测值
        /// </summary>
        string _rate = "";
        /// <summary>
        /// 检测时间
        /// </summary>
        string _check_time = "";
        /// <summary>
        /// 检测人
        /// </summary>
        string _operator = "";
        /// <summary>
        /// 检测硬件系列号
        /// </summary>
        string _hardware_no = "";
        /// <summary>
        /// 检测数量
        /// </summary>
        string _ChackTotal = "1";
        /// <summary>
        /// 生产日期
        /// </summary>
        string _ProduceDate = "";
        /// <summary>
        /// 仪器制造商
        /// </summary>
        string _MachineMaker = "fuchun";
        /// <summary>
        /// 送检时间
        /// </summary>
        string _SendDate = "";
        /// <summary>
        /// 备注说明
        /// </summary>
        string _Memo = "";
        /// <summary>
        /// 条形码
        /// </summary>
        string _BarCode = "";
        public CheckData_info GetCheckDataObj(CheckDataTrans poDataTrans)
        {
            CheckData_info loCheckData = null;
            string lcSampleId = poDataTrans.GetSampleNo(_sample);
            if (IsValid && poDataTrans.GetCheckProTypeIDByItemAndMothed(_check_item, _check_method, CheckProjectType_info.cCheckProjectTypeID) != "" && !string.IsNullOrEmpty(lcSampleId))
            {
                loCheckData = new CheckData_info();
                loCheckData.BarCode = _BarCode;
                loCheckData.CheckProjectTypeID = poDataTrans.GetCheckProTypeIDByItemAndMothed(_check_item, _check_method, CheckProjectType_info.cCheckProjectTypeID);
                loCheckData.CheckLimit = poDataTrans.GetCheckProTypeIDByItemAndMothed(_check_item, _check_method, CheckProjectType_info.cStandardValue);
                loCheckData.CheckValue = _rate;

                loCheckData.CheckResult = poDataTrans.TransResult(_result);

                loCheckData.CheckTime = _check_time;
                loCheckData.CheckTotal = _ChackTotal;
                loCheckData.CheckUnit = _check_org;
                loCheckData.CheckUser = _operator;
                loCheckData.ClientIndexID = _sample_no;
                loCheckData.CorpKind = _checked_org_type;
                loCheckData.CorpName = _checked_org;
                loCheckData.GreatKindName = "";
                //-----翻译
                loCheckData.HabitatID = poDataTrans.GetHabitIdByHabitName(_check_district);
                //默认自检
                loCheckData.IsSelf = "1";


                //_sub_category; 不直接使用客户端类型，通过品种名查找服务器端名称
                //loCheckData.LittleKindName = poDataTrans.GetLittleKindName(_sample);
                loCheckData.MachineID = _hardware_no;
                loCheckData.MachineMaker = _MachineMaker;
                loCheckData.MarketID = poDataTrans.MarketId;
                loCheckData.Memo = _Memo;
                loCheckData.ProduceDate = _ProduceDate;
                loCheckData.ProduceUnit = _produce_org;

                //检查服务器端是否有匹配的数据
                loCheckData.SampleName = _sample;// _sample;
                loCheckData.SampleId = lcSampleId;// _sample;
                loCheckData.SendDate = _SendDate;
                loCheckData.UserID = poDataTrans.UserID;
                loCheckData.UploadTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");


            }
            return loCheckData;
        }

        public bool InsertCheckData(CheckDataTrans poDataTrans)
        {
            bool lbRetVal = false;
            string lcSampleId = poDataTrans.GetSampleNo(_sample);
            if (IsValid && poDataTrans.GetCheckProTypeIDByItemAndMothed(_check_item, _check_method, CheckProjectType_info.cCheckProjectTypeID)!="")
            {
                CheckData_info loCheckData = new CheckData_info();
                loCheckData.BarCode = _BarCode;
                loCheckData.CheckProjectTypeID = poDataTrans.GetCheckProTypeIDByItemAndMothed(_check_item, _check_method, CheckProjectType_info.cCheckProjectTypeID);
                loCheckData.CheckLimit = poDataTrans.GetCheckProTypeIDByItemAndMothed(_check_item, _check_method, CheckProjectType_info.cStandardValue); 
                loCheckData.CheckValue = _rate;

                loCheckData.CheckResult = poDataTrans.TransResult(_result);

                loCheckData.CheckTime = _check_time;
                loCheckData.CheckTotal = _ChackTotal;
                loCheckData.CheckUnit = _check_org;
                loCheckData.CheckUser = _operator;
                loCheckData.ClientIndexID = _sample_no;
                loCheckData.CorpKind = _checked_org_type;
                loCheckData.CorpName = _checked_org;
                loCheckData.GreatKindName = "";
                //-----翻译
                loCheckData.HabitatID = poDataTrans.GetHabitIdByHabitName(_check_district);
                //默认自检
                loCheckData.IsSelf = "1";
                

                //_sub_category; 不直接使用客户端类型，通过品种名查找服务器端名称
                //loCheckData.LittleKindName = poDataTrans.GetLittleKindName(_sample );  
                loCheckData.MachineID = _hardware_no;
                loCheckData.MachineMaker = _MachineMaker;
                loCheckData.MarketID = poDataTrans.MarketId ;
                loCheckData.Memo = _Memo;
                loCheckData.ProduceDate = _ProduceDate;
                loCheckData.ProduceUnit = _produce_org;

                //检查服务器端是否有匹配的数据
                loCheckData.SampleName = _sample;// _sample;
                loCheckData.SampleId = lcSampleId;
                loCheckData.SendDate = _SendDate;
                loCheckData.UserID = poDataTrans.UserID;
                loCheckData.UploadTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
				string lcSql= loCheckData.InsertSql()+ ";\r\n";
                if (!string.IsNullOrWhiteSpace(lcSampleId))
                {
                    lcSql += " UPDATE VarietyCategory SET [CheckCount]=[CheckCount]+1 WHERE [VarietyCategoryNo]='" +
                             lcSampleId + "'";
                }

				if (poDataTrans.DBConn.ExcuteSqlTran(lcSql))
                {
                    lbRetVal = true;
                }
            }
            return lbRetVal;
        }

        public bool IsValid
        {
            get { return _sample != "" && _rate != "" 
                && _check_item != "" && _check_method != "" 
                && _operator != ""; }
        }
        #endregion
    }
}