Пример #1
0
        private void loadData()
        {
            string strWhere = string.Empty;

            if (!string.IsNullOrEmpty(Request["CODE_S"]))
            {
                strWhere = strWhere + " and t1.InCode like '%" + Request["CODE_S"] + "%'";
            }
            if (!string.IsNullOrEmpty(Request["CNNAME_S"]))
            {
                strWhere = strWhere + " and t1.name like '%" + Request["CNNAME_S"] + "%'";
            }
            if (!string.IsNullOrEmpty(Request["ENABLED_S"]))
            {
                strWhere = strWhere + " and t1.enabled='" + Request["ENABLED_S"] + "'";
            }
            if (!string.IsNullOrEmpty(Request["CODE_Sea"]))
            {
                strWhere = strWhere + " and t1.CODE='" + Request["CODE_Sea"] + "'";
            }
            if (!string.IsNullOrEmpty(Request["CODE_Insp"]))
            {
                strWhere = strWhere + " and t1.INSPCODE='" + Request["CODE_Insp"] + "'";
            }

            Sql.Base_Company bc = new Sql.Base_Company();
            DataTable        dt = bc.LoaData(strWhere, "", "", ref totalProperty, Convert.ToInt32(Request["start"]),
                                             Convert.ToInt32(Request["limit"]));
            string json = JsonConvert.SerializeObject(dt, iso);

            Response.Write("{rows:" + json + ",total:" + totalProperty + "}");
            Response.End();
        }
Пример #2
0
        public List <int> CheckRepeat(string id, string declcountry)
        {
            string strWhere = String.Empty;

            if (string.IsNullOrEmpty(id))
            {
                strWhere = "";
            }
            else
            {
                strWhere = " and id not in('" + id + "')";
            }
            List <int> addList = new List <int>();

            Sql.Base_Company bc = new Sql.Base_Company();
            //对应关系重复返回值为1
            if (check_status_repeat(declcountry, strWhere).Rows.Count > 0)
            {
                addList.Add(1);
            }
            return(addList);
        }
Пример #3
0
        //判断内部编码,海关编码,社会信用代码是否有重复
        public List <int> CheckRepeat(string id, string code, string name, string hscode)
        {
            string strWhere = String.Empty;

            if (string.IsNullOrEmpty(id))
            {
                strWhere = "";
            }
            else
            {
                strWhere = " and id not in('" + id + "')";
            }
            List <int> addList = new List <int>();

            Sql.Base_Company bc = new Sql.Base_Company();
            //集装箱规格编号重复返回值为1
            if (check_code_repeat(code, strWhere).Rows.Count > 0)
            {
                addList.Add(1);
            }
            //集装箱规格名称重复返回值为2
            if (check_name_repeat(name, strWhere).Rows.Count > 0)
            {
                addList.Add(2);
            }
            //对应hscode重复返回值为3
            if (!string.IsNullOrEmpty(hscode))
            {
                if (check_hscode_repeat(hscode, strWhere).Rows.Count > 0)
                {
                    addList.Add(3);
                }
            }


            return(addList);
        }
Пример #4
0
        //判断内部编码,海关编码,社会信用代码是否有重复
        public List <int> CheckRepeat(string id, string incode, string code, string socialcreditno)
        {
            string strWhere = String.Empty;

            if (string.IsNullOrEmpty(id))
            {
                strWhere = "";
            }
            else
            {
                strWhere = "and id not in('" + id + "')";
            }
            List <int> addList = new List <int>();

            Sql.Base_Company bc = new Sql.Base_Company();
            //内部编码重复返回值为1
            if (bc.check_incode_repeat(incode, strWhere).Rows.Count > 0)
            {
                addList.Add(1);
            }
            //海关编码重复返回值为2
            if (bc.check_code_repeat(code, strWhere).Rows.Count > 0)
            {
                addList.Add(2);
            }
            //社会信用代码重复返回值为3
            if (!string.IsNullOrEmpty(socialcreditno))
            {
                if (bc.check_socialcreditno_repeat(socialcreditno, strWhere).Rows.Count > 0)
                {
                    addList.Add(3);
                }
            }


            return(addList);
        }
Пример #5
0
        private void save(string formdata)
        {
            JObject             json = (JObject)JsonConvert.DeserializeObject(formdata);
            Base_Company_Method bcm  = new Base_Company_Method();

            Sql.Base_Company bcsql = new Sql.Base_Company();
            //禁用人
            string stopman = "";
            //返回重复结果
            string repeat = "";
            //返回前端的值
            string response = "";

            if (json.Value <string>("ENABLED") == "1")
            {
                stopman = "";
            }
            else
            {
                FormsIdentity identity  = HttpContext.Current.User.Identity as FormsIdentity;
                string        userName  = identity.Name;
                JObject       json_user = Extension.Get_UserInfo(userName);
                stopman = (string)json_user.GetValue("ID");
            }

            if (String.IsNullOrEmpty(json.Value <string>("ID")))
            {
                //插入数据库
                if (json.Value <string>("ENABLED") == "1")
                {
                    List <int> retunRepeat = bcm.CheckRepeat(json.Value <string>("ID"), json.Value <string>("INCODE"), json.Value <string>("CODE"),
                                                             json.Value <string>("SOCIALCREDITNO"));

                    repeat = bcm.Check_Repeat(retunRepeat);
                    if (repeat == "")
                    {
                        //insert数据向表base_company当是5时插入成功
                        bcsql.insert_base_company(json, stopman);
                        repeat = "5";
                    }
                }
                else
                {
                    bcsql.insert_base_company(json, stopman);
                    repeat = "5";
                }
            }
            else
            {
                if (json.Value <string>("ENABLED") == "1")
                {
                    //更新数据库
                    List <int> retunRepeat = bcm.CheckRepeat(json.Value <string>("ID"), json.Value <string>("INCODE"),
                                                             json.Value <string>("CODE"),
                                                             json.Value <string>("SOCIALCREDITNO"));
                    repeat = bcm.Check_Repeat(retunRepeat);
                    if (repeat == "")
                    {
                        DataTable dt = bcsql.LoadDataById(json.Value <string>("ID"));
                        int       i  = bcsql.update_base_company(json, stopman);
                        if (i > 0)
                        {
                            bcsql.insert_base_alterrecord(json, dt);
                        }
                        repeat = "5";
                    }
                }
                else
                {
                    DataTable dt = bcsql.LoadDataById(json.Value <string>("ID"));
                    int       i  = bcsql.update_base_company(json, stopman);
                    if (i > 0)
                    {
                        bcsql.insert_base_alterrecord(json, dt);
                    }
                    repeat = "5";
                }
            }

            response = "{\"success\":\"" + repeat + "\"}";

            Response.Write(response);
            Response.End();
        }
Пример #6
0
        public Dictionary <int, List <int> > upload_base_company(string newfile, string fileName, string action, JObject json_formdata)
        {
            Base_Company_Method bcm = new Base_Company_Method();

            Sql.Base_Company bc         = new Sql.Base_Company();
            DataTable        dtExcel    = bcm.GetExcelData_Table(Server.MapPath(newfile), 0);
            List <string>    stringList = new List <string>();
            //停用人
            string stopman = "";

            //存放成功信息
            List <int> repeatListsuccess = new List <int>();
            //存放失败条数
            List <int> repeatListerror = new List <int>();
            //记住insert成功的条数
            int count = 0;
            //返回信息
            Dictionary <int, List <int> > dcInts = new Dictionary <int, List <int> >();

            for (int i = 0; i < dtExcel.Rows.Count; i++)
            {
                for (int j = 0; j < dtExcel.Columns.Count; j++)
                {
                    stringList.Add(dtExcel.Rows[i][j].ToString());
                }
                string DeclNature = ""; //海关企业性质
                string InspNature = ""; //商检企业性质

                //内部编码                       //海关编码
                string incode = stringList[0]; string CODE = stringList[1];
                //商检编码                       //企业名称
                string INSPCODE = stringList[2]; string NAME = stringList[3];
                //企业英文名称                     //货物存放地
                string ENGLSHNAME = stringList[4]; string GOODSLOCAL = stringList[5];
                //收货人类型                             //启用情况
                string RECEIVERTYPE = stringList[6]; string ENABLED = stringList[7] == "是"?"1":"0";
                //备注
                string REMARK = stringList[8];
                //维护人
                string CREATEMANNAME = json_formdata.Value <string>("CREATEMANNAME");
                //启用时间
                string STARTDATE = json_formdata.Value <string>("STARTDATE") == "" ? DateTime.MinValue.ToShortDateString() : json_formdata.Value <string>("STARTDATE");

                //停用日期
                string ENDDATE = json_formdata.Value <string>("ENDDATE") == ""
                    ? DateTime.MaxValue.ToShortDateString()
                    : json_formdata.Value <string>("ENDDATE");
                //社会信用代码
                string SOCIALCREDITNO = stringList[9];
                if (CODE.Length > 6)
                {
                    DeclNature = CODE.Substring(5, 1);
                    InspNature = CODE.Substring(5, 1);
                }

                if (ENABLED == "1")
                {
                    stopman = "";
                }
                else
                {
                    FormsIdentity identity  = HttpContext.Current.User.Identity as FormsIdentity;
                    string        userName  = identity.Name;
                    JObject       json_user = Extension.Get_UserInfo(userName);
                    stopman = (string)json_user.GetValue("ID");
                }
                //导入判断条件
                List <int> inlist       = bcm.CheckRepeat("", incode, CODE, "");
                string     check_repeat = bcm.Check_Repeat(inlist);

                if (check_repeat == "")
                {
                    bc.export_insert_base_company(incode, CODE, INSPCODE, NAME, ENGLSHNAME, GOODSLOCAL, RECEIVERTYPE,
                                                  ENABLED, REMARK, STARTDATE, ENDDATE, DeclNature, InspNature, stopman, SOCIALCREDITNO);
                    count = count + 1;
                }
                else
                {
                    repeatListerror.Add(i + 2);
                }

                //清除
                stringList.Clear();
            }
            repeatListsuccess.Add(count);
            dcInts.Add(1, repeatListsuccess);
            dcInts.Add(2, repeatListerror);
            return(dcInts);
        }
Пример #7
0
        public void export()
        {
            string strWhere         = string.Empty;
            string combo_ENABLED_S2 = Request["combo_ENABLED_S"];

            if (combo_ENABLED_S2 == "null")
            {
                combo_ENABLED_S2 = String.Empty;
            }
            if (!string.IsNullOrEmpty(Request["CODE_S"]))
            {
                strWhere = strWhere + " and t1.InCode like '%" + Request["CODE_S"] + "%'";
            }
            if (!string.IsNullOrEmpty(Request["CNNAME_S"]))
            {
                strWhere = strWhere + " and t1.name like '%" + Request["CNNAME_S"] + "%'";
            }
            if (!string.IsNullOrEmpty(combo_ENABLED_S2))
            {
                strWhere = strWhere + " and t1.enabled='" + combo_ENABLED_S2 + "'";
            }
            if (!string.IsNullOrEmpty(Request["CODE_Sea"]))
            {
                strWhere = strWhere + " and t1.CODE='" + Request["CODE_Sea"] + "'";
            }
            if (!string.IsNullOrEmpty(Request["CODE_Insp"]))
            {
                strWhere = strWhere + " and t1.INSPCODE='" + Request["CODE_Insp"] + "'";
            }

            Sql.Base_Company bc = new Sql.Base_Company();
            DataTable        dt = bc.export_base_company(strWhere);

            //创建Excel文件的对象
            NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
            //添加一个导出成功sheet
            NPOI.SS.UserModel.ISheet sheet_S = book.CreateSheet("企业信息");
            NPOI.SS.UserModel.IRow   row1    = sheet_S.CreateRow(0);
            row1.CreateCell(0).SetCellValue("内部编码");
            row1.CreateCell(1).SetCellValue("海关编码");
            row1.CreateCell(2).SetCellValue("商检编码");
            row1.CreateCell(3).SetCellValue("社会信用代码");
            row1.CreateCell(4).SetCellValue("企业名称");
            row1.CreateCell(5).SetCellValue("英文名称");
            row1.CreateCell(6).SetCellValue("海关性质");
            row1.CreateCell(7).SetCellValue("商检性质");
            row1.CreateCell(8).SetCellValue("货物存放地");
            row1.CreateCell(9).SetCellValue("收货人类型");
            row1.CreateCell(10).SetCellValue("启用情况");
            row1.CreateCell(11).SetCellValue("启用时间");
            row1.CreateCell(12).SetCellValue("维护人");
            row1.CreateCell(13).SetCellValue("维护时间");
            row1.CreateCell(14).SetCellValue("停用人");
            row1.CreateCell(15).SetCellValue("停用时间");
            row1.CreateCell(16).SetCellValue("备注");

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                NPOI.SS.UserModel.IRow rowtemp = sheet_S.CreateRow(i + 1);
                rowtemp.CreateCell(0).SetCellValue(dt.Rows[i]["INCODE"].ToString());
                rowtemp.CreateCell(1).SetCellValue(dt.Rows[i]["CODE"].ToString());
                rowtemp.CreateCell(2).SetCellValue(dt.Rows[i]["INSPCODE"].ToString());
                rowtemp.CreateCell(3).SetCellValue(dt.Rows[i]["SOCIALCREDITNO"].ToString());
                rowtemp.CreateCell(4).SetCellValue(dt.Rows[i]["NAME"].ToString());
                rowtemp.CreateCell(5).SetCellValue(dt.Rows[i]["ENGLISHNAME"].ToString());
                rowtemp.CreateCell(6).SetCellValue(dt.Rows[i]["DECLNATURENAME"].ToString());
                rowtemp.CreateCell(7).SetCellValue(dt.Rows[i]["INSPNATURENAME"].ToString());
                rowtemp.CreateCell(8).SetCellValue(dt.Rows[i]["GOODSLOCAL"].ToString());
                rowtemp.CreateCell(9).SetCellValue(dt.Rows[i]["RECEIVERTYPE"].ToString());
                rowtemp.CreateCell(10).SetCellValue(dt.Rows[i]["ENABLED"].ToString() == "1" ? "是" : "否");
                rowtemp.CreateCell(11).SetCellValue(dt.Rows[i]["STARTDATE"].ToString());
                rowtemp.CreateCell(12).SetCellValue(dt.Rows[i]["CREATEMANNAME"].ToString());
                rowtemp.CreateCell(13).SetCellValue(dt.Rows[i]["CREATEDATE"].ToString());
                rowtemp.CreateCell(14).SetCellValue(dt.Rows[i]["STOPMANNAME"].ToString());
                rowtemp.CreateCell(15).SetCellValue(dt.Rows[i]["ENDDATE"].ToString());
                rowtemp.CreateCell(16).SetCellValue(dt.Rows[i]["REMARK"].ToString());
            }
            try
            {
                // 输出Excel
                string filename = "企业信息.xls";
                Response.ContentType = "application/vnd.ms-excel";
                Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", Server.UrlEncode(filename)));
                Response.Clear();

                MemoryStream ms = new MemoryStream();
                book.Write(ms);
                Response.BinaryWrite(ms.GetBuffer());
                Response.End();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
        }