コード例 #1
0
        public UcCertificateDetails(List <string> cer_details)
        {
            InitializeComponent();
            Cer_details = cer_details;

            _card_id.Text       = Cer_details[0];
            _company.Text       = Cer_details[1];
            _detect_object.Text = Cer_details[2];
            _object_count.Text  = ConvertStr.convert_object(Cer_details[3]) + Cer_details[4];
            _phone.Text         = Cer_details[5];
            _for_use.Text       = Cer_details[6];
            _city_ks.Text       = Cer_details[7];
            _region_ks.Text     = Cer_details[8];
            _town_ks.Text       = Cer_details[9];
            _village_ks.Text    = Cer_details[10];
            _city_js.Text       = Cer_details[11];
            _region_js.Text     = Cer_details[12];
            _town_js.Text       = Cer_details[13];
            _village_js.Text    = Cer_details[14];
            _object_lable.Text  = Cer_details[15];
            _user_name.Text     = Cer_details[16];
            _user_id.Text       = Cer_details[17];
            _nian.Text          = ConvertStr.convert_nian(Cer_details[18]);
            _yue.Text           = ConvertStr.convert_yue(Cer_details[19]);
            _day.Text           = ConvertStr.convert_day(Cer_details[20]);
        }
コード例 #2
0
        public CertificatePreview(IDBOperation dbOperation, string card_id)
        {
            InitializeComponent();
            this.dbOperation = dbOperation;
            this.cardId      = card_id;

            DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_certificate_main('{0}')", cardId)).Tables[0];

            if (table.Rows.Count > 0)
            {
                _card_id.Text       = table.Rows[0][0].ToString();
                _company.Text       = table.Rows[0][2].ToString();
                _phone.Text         = table.Rows[0][6].ToString();
                _detect_object.Text = table.Rows[0][4].ToString();
                _object_count.Text  = table.Rows[0][5].ToString();
                _for_use.Text       = table.Rows[0][7].ToString();
                _city_ks.Text       = table.Rows[0][8].ToString();
                _region_ks.Text     = table.Rows[0][9].ToString();
                _town_ks.Text       = table.Rows[0][10].ToString();
                _village_ks.Text    = table.Rows[0][11].ToString();
                _city_js.Text       = table.Rows[0][12].ToString();
                _region_js.Text     = table.Rows[0][13].ToString();
                _town_js.Text       = table.Rows[0][14].ToString();
                _village_js.Text    = table.Rows[0][15].ToString();
                _object_lable.Text  = table.Rows[0][16].ToString();
                _user_name.Text     = table.Rows[0][17].ToString();
                _user_id.Text       = table.Rows[0][21].ToString();
                _nian.Text          = ConvertStr.convert_nian(table.Rows[0][18].ToString());
                _yue.Text           = ConvertStr.convert_yue(table.Rows[0][19].ToString());
                _day.Text           = ConvertStr.convert_day(table.Rows[0][20].ToString());
            }
        }
コード例 #3
0
        public CertificateProductPreview(IDBOperation dbOperation, string card_id)
        {
            InitializeComponent();
            this.dbOperation = dbOperation;
            this.cardId      = card_id;

            DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_certificate_product_main('{0}')", cardId)).Tables[0];

            if (table.Rows.Count > 0)
            {
                _card_id.Text      = table.Rows[0][0].ToString();
                _company.Text      = table.Rows[0][2].ToString();
                _product_name.Text = table.Rows[0][4].ToString();
                _object_count.Text = table.Rows[0][5].ToString();
                _cz_cardid.Text    = table.Rows[0][3].ToString();
                _product_area.Text = table.Rows[0][6].ToString();
                _dept_name.Text    = table.Rows[0][7].ToString() + "              " + table.Rows[0][8].ToString();
                _mdd.Text          = table.Rows[0][9].ToString();
                _bz.Text           = table.Rows[0][10].ToString();
                _user_name.Text    = table.Rows[0][11].ToString();
                _user_id.Text      = table.Rows[0][15].ToString();
                _nian.Text         = ConvertStr.convert_nian(table.Rows[0][12].ToString());
                _yue.Text          = ConvertStr.convert_yue(table.Rows[0][13].ToString());
                _day.Text          = ConvertStr.convert_day(table.Rows[0][14].ToString());
            }
        }
コード例 #4
0
        public UcCertificateProductDetails(List <string> cer_details)
        {
            InitializeComponent();
            Cer_details = cer_details;

            _card_id.Text      = Cer_details[0];
            _company.Text      = Cer_details[1];
            _product_name.Text = Cer_details[3];
            //针对清真存在.5的情况,判断如下:
            //判断输入的是否为小数
            bool   flag         = true;
            string object_count = Cer_details[4];

            foreach (char c in object_count)
            {
                if (c == '.')
                {
                    flag = false;
                }
            }

            if (flag == true)
            {
                _object_count.Text = ConvertStr.convert_object(object_count) + Cer_details[5];
            }
            else
            {
                string count_dot = ConvertStr.convert_object_dot(object_count);
                count_dot = count_dot.Replace("零点半", "半" + Cer_details[5]);
                count_dot = count_dot.Replace("点", Cer_details[5]);

                _object_count.Text = count_dot;
            }

            _product_area.Text = Cer_details[6];
            _dept_name.Text    = Cer_details[7];
            _dept_area.Text    = Cer_details[8];
            _mdd.Text          = Cer_details[9];
            _cz_cardid.Text    = Cer_details[2];
            _bz.Text           = Cer_details[10];
            _user_name.Text    = Cer_details[11];
            _user_id.Text      = Cer_details[12];
            _nian.Text         = ConvertStr.convert_nian(Cer_details[13]);
            _yue.Text          = ConvertStr.convert_yue(Cer_details[14]);
            _day.Text          = ConvertStr.convert_day(Cer_details[15]);
        }
コード例 #5
0
        public UcCreateCertificate(IDBOperation dbOperation)
        {
            InitializeComponent();
            this.dbOperation = dbOperation;

            _user_name.Text = username;
            _user_id.Text   = loginid;
            _nian.Text      = ConvertStr.convert_nian(DateTime.Now.Year.ToString());
            _yue.Text       = ConvertStr.convert_yue(DateTime.Now.Month.ToString());
            _day.Text       = ConvertStr.convert_day(DateTime.Now.Day.ToString());

            //出证人所属的市级单位,及出证人所属部门货主信息flag,赋值启运地点
            DataTable table = dbOperation.GetDbHelper().GetDataSet("select sys_city.name as city,ifnull(a.shipperflag,'') as shipperflag," +
                                                                   " tzcname,tzcarea,tzcaddress" +
                                                                   " from sys_client_sysdept a LEFT JOIN sys_city ON a.city = sys_city.id" +
                                                                   " where INFO_CODE = " + deptId).Tables[0];

            if (table.Rows.Count != 0)
            {
                cityname    = table.Rows[0][0].ToString();
                shipperflag = table.Rows[0][1].ToString();

                string tzcarea = table.Rows[0][3].ToString();

                _city_ks.Text   = tzcarea.Substring(0, 2).ToString();
                _region_ks.Text = tzcarea.Substring(3, 3).ToString();
                //_town_ks.Text = table.Rows[0][4].ToString();
                _village_ks.Text = table.Rows[0][2].ToString();
            }

            //检疫证号
            string card_id = dbOperation.GetDbHelper().GetSingle(string.Format("select f_get_cardid('{0}')", deptId)).ToString();

            _card_id.Text = card_id;
            //协检员
            ComboboxTool.InitComboboxSource(_help_user, string.Format("call p_user_helpuser({0})", userId), "lr");
            //动物种类
            ComboboxTool.InitComboboxSource(_object_id, "SELECT animalid,animalname FROM t_animal_new WHERE openflag = '1' and deptflag = '" + shipperflag + "'", "lr");
            _object_id.SelectionChanged += new SelectionChangedEventHandler(_object_id_SelectionChanged);
            _object_id.SelectedIndex     = 1;
            //用途
            ComboboxTool.InitComboboxSource(_for_use, "SELECT useid,usename FROM t_for_use WHERE openflag = '1'", "lr");
            _for_use.SelectedIndex = 1;
        }
コード例 #6
0
        public UcCreateCertificate_product(IDBOperation dbOperation)
        {
            InitializeComponent();

            this.dbOperation = dbOperation;
            _user_name.Text  = username;
            _user_id.Text    = loginid;
            _nian.Text       = ConvertStr.convert_nian(DateTime.Now.Year.ToString());
            _yue.Text        = ConvertStr.convert_yue(DateTime.Now.Month.ToString());
            _day.Text        = ConvertStr.convert_day(DateTime.Now.Day.ToString());

            //出证人所属部门货主信息flag,生产单位信息
            DataTable table = dbOperation.GetDbHelper().GetDataSet("select ifnull(a.shipperflag,'') as shipperflag, " +
                                                                   " tzcname,tzcarea,tzcaddress,tzccardid " +
                                                                   " from sys_client_sysdept a " +
                                                                   " where INFO_CODE = " + deptId).Tables[0];

            if (table.Rows.Count != 0)
            {
                shipperflag        = table.Rows[0][0].ToString();
                _dept_area.Text    = table.Rows[0][2].ToString();
                _dept_address.Text = table.Rows[0][3].ToString();
                _dept_name.Text    = table.Rows[0][1].ToString();
                _cz_cardid.Text    = table.Rows[0][4].ToString();
            }

            //产品检疫证号
            string product_cardid = dbOperation.GetDbHelper().GetSingle(string.Format("select f_get_productcardid('{0}')", deptId)).ToString();

            _card_id.Text = product_cardid;
            //协检员
            ComboboxTool.InitComboboxSource(_help_user, string.Format("call p_user_helpuser({0})", userId), "lr");
            //产品名称
            ComboboxTool.InitComboboxSource(_product_name, "SELECT productid,productname FROM t_product WHERE openflag = '1' and deptflag = '" + shipperflag + "'", "lr");
            _product_name.SelectionChanged += new SelectionChangedEventHandler(_product_name_SelectionChanged);
            _product_name.SelectedIndex     = 1;
            //生产单位
            //ComboboxTool.InitComboboxSource(_dept_name, string.Format("call p_get_dept_tz({0})", userId), "lr");
            //_dept_name.SelectionChanged += new SelectionChangedEventHandler(_dept_name_SelectionChanged);
        }