Example #1
0
        public int CompareTo(object obj)
        {
            AreaInfo b = obj as AreaInfo;

            //if ( String.Compare(this.OrderNumber, b.OrderNumber) >= 0 )
            //    return 1;
            //else
            //    return -1;
            if (string.Compare(this.DistrictName, b.DistrictName) >= 0)
            {
                return(1);
            }
            else
            {
                return(-1);
            }
        }
Example #2
0
File: ASPDac.cs Project: ue96/ue96
        public int UpdateArea(AreaInfo oParam)
        {
            string sql = @"UPDATE Area SET
                            ProvinceSysNo=@ProvinceSysNo, CitySysNo=@CitySysNo,
                            ProvinceName=@ProvinceName, CityName=@CityName,
                            DistrictName=@DistrictName, IsLocal=@IsLocal, Status=@Status,LocalCode=@LocalCode
                            WHERE SysNo=@SysNo";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
            SqlParameter paramProvinceSysNo = new SqlParameter("@ProvinceSysNo", SqlDbType.Int, 4);
            SqlParameter paramCitySysNo = new SqlParameter("@CitySysNo", SqlDbType.Int, 4);
            SqlParameter paramProvinceName = new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 20);
            SqlParameter paramCityName = new SqlParameter("@CityName", SqlDbType.NVarChar, 20);
            SqlParameter paramDistrictName = new SqlParameter("@DistrictName", SqlDbType.NVarChar, 200);
            SqlParameter paramIsLocal = new SqlParameter("@IsLocal", SqlDbType.Int, 4);
            SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
            SqlParameter paramLocalCode = new SqlParameter("@LocalCode", SqlDbType.Int, 4);

            paramSysNo.Value = oParam.SysNo;
            paramProvinceSysNo.Value = oParam.ProvinceSysNo;
            paramCitySysNo.Value = oParam.CitySysNo;
            paramProvinceName.Value = oParam.ProvinceName;
            paramCityName.Value = oParam.CityName;
            paramDistrictName.Value = oParam.DistrictName;
            paramIsLocal.Value = oParam.IsLocal;
            paramStatus.Value = oParam.Status;
            paramLocalCode.Value = oParam.LocalCode;

            cmd.Parameters.Add(paramSysNo);
            cmd.Parameters.Add(paramProvinceSysNo);
            cmd.Parameters.Add(paramCitySysNo);
            cmd.Parameters.Add(paramProvinceName);
            cmd.Parameters.Add(paramCityName);
            cmd.Parameters.Add(paramDistrictName);
            cmd.Parameters.Add(paramIsLocal);
            cmd.Parameters.Add(paramStatus);
            cmd.Parameters.Add(paramLocalCode);

            return SqlHelper.ExecuteNonQuery(cmd);
        }
Example #3
0
File: ASPDac.cs Project: ue96/ue96
        public int InsertArea(AreaInfo oParam)
        {
            string sql = @"INSERT INTO Area
                            (
                            SysNo, ProvinceSysNo, CitySysNo,
                            ProvinceName, CityName, DistrictName, IsLocal, Status,LocalCode
                            )
                            VALUES (
                            @SysNo, @ProvinceSysNo, @CitySysNo,
                            @ProvinceName, @CityName, @DistrictName, @IsLocal, @Status,@LocalCode
                            );
                            set @sysno = SCOPE_IDENTITY();
                        ";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
            SqlParameter paramProvinceSysNo = new SqlParameter("@ProvinceSysNo", SqlDbType.Int, 4);
            SqlParameter paramCitySysNo = new SqlParameter("@CitySysNo", SqlDbType.Int, 4);
            SqlParameter paramProvinceName = new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 20);
            SqlParameter paramCityName = new SqlParameter("@CityName", SqlDbType.NVarChar, 20);
            SqlParameter paramDistrictName = new SqlParameter("@DistrictName", SqlDbType.NVarChar, 200);
            SqlParameter paramIsLocal = new SqlParameter("@IsLocal", SqlDbType.Int, 4);
            SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
            SqlParameter paramLocalCode = new SqlParameter("@LocalCode", SqlDbType.Int, 4);

            paramSysNo.Value = oParam.SysNo;

            if (oParam.ProvinceSysNo != AppConst.IntNull)
                paramProvinceSysNo.Value = oParam.ProvinceSysNo;
            else
                paramProvinceSysNo.Value = System.DBNull.Value;

            if (oParam.CitySysNo != AppConst.IntNull)
                paramCitySysNo.Value = oParam.CitySysNo;
            else
                paramCitySysNo.Value = System.DBNull.Value;

            paramProvinceName.Value = oParam.ProvinceName;

            if (oParam.CityName != AppConst.StringNull)
                paramCityName.Value = oParam.CityName;
            else
                paramCityName.Value = System.DBNull.Value;

            if (oParam.DistrictName != AppConst.StringNull)
                paramDistrictName.Value = oParam.DistrictName;
            else
                paramDistrictName.Value = System.DBNull.Value;

            if (oParam.LocalCode != AppConst.IntNull)
                paramLocalCode.Value = oParam.LocalCode;
            else
                paramLocalCode.Value = System.DBNull.Value;

            paramIsLocal.Value = oParam.IsLocal;
            paramStatus.Value = oParam.Status;

            cmd.Parameters.Add(paramSysNo);
            cmd.Parameters.Add(paramProvinceSysNo);
            cmd.Parameters.Add(paramCitySysNo);
            cmd.Parameters.Add(paramProvinceName);
            cmd.Parameters.Add(paramCityName);
            cmd.Parameters.Add(paramDistrictName);
            cmd.Parameters.Add(paramIsLocal);
            cmd.Parameters.Add(paramStatus);
            cmd.Parameters.Add(paramLocalCode);

            return SqlHelper.ExecuteNonQuery(cmd);
        }
Example #4
0
 public int GetAreaType(AreaInfo oParam)
 {
     if (oParam.CitySysNo != AppConst.IntNull)
         return (int)AppEnum.AreaType.District;
     else if (oParam.ProvinceSysNo != AppConst.IntNull)
         return (int)AppEnum.AreaType.City;
     else
         return (int)AppEnum.AreaType.Province;
 }
Example #5
0
        public void ImportArea()
        {
            if (!AppConfig.IsImportable)
                throw new BizException("Is Importable is false");

            /*  do not  use the following code after Data Pour in */
            string sql = " select top 1 * from area ";
            DataSet ds = SqlHelper.ExecuteDataSet(sql);
            if (Util.HasMoreRow(ds))
                throw new BizException("the table area is not empty");

            TransactionOptions options = new TransactionOptions();
            options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
            options.Timeout = TransactionManager.DefaultTimeout;

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
            {

                string sql1 = "select * from ipp2003..area where countrySysNo = 1 and provinceSysNo = 0"; //ͨ��ʡ�� and SysNo <> 36";
                DataSet ds1 = SqlHelper.ExecuteDataSet(sql1);
                foreach (DataRow dr1 in ds1.Tables[0].Rows)
                {
                    AreaInfo oProvince = new AreaInfo();
                    oProvince.ProvinceName = Util.TrimNull(dr1["ProvinceName"]);
                    oProvince.IsLocal = Util.TrimIntNull(dr1["IsLocal"]);
                    oProvince.Status = Util.TrimIntNull(dr1["Status"]);
                    oProvince.OrderNumber = "zzz";
                    this.InsertArea(oProvince);

                    //insert into convert table
                    ImportInfo oProvinceConvert = new ImportInfo();
                    oProvinceConvert.OldSysNo = Util.TrimIntNull(dr1["SysNo"]);
                    oProvinceConvert.NewSysNo = oProvince.SysNo;
                    new ImportDac().Insert(oProvinceConvert, "Area");

                    string sql2 = "select * from ipp2003..area where provinceSysNo = " + Util.TrimIntNull(dr1["SysNo"]) + " and citySysNo = 0 ";
                    DataSet ds2 = SqlHelper.ExecuteDataSet(sql2);
                    foreach (DataRow dr2 in ds2.Tables[0].Rows)
                    {
                        AreaInfo oCity = new AreaInfo();
                        oCity.ProvinceSysNo = oProvince.SysNo;
                        oCity.ProvinceName = Util.TrimNull(dr1["ProvinceName"]);
                        oCity.CityName = Util.TrimNull(dr2["CityName"]);
                        oCity.IsLocal = Util.TrimIntNull(dr2["IsLocal"]);
                        oCity.Status = Util.TrimIntNull(dr2["Status"]);
                        oCity.OrderNumber = "zzz";
                        this.InsertArea(oCity);

                        //insert into convert table
                        ImportInfo oCityConvert = new ImportInfo();
                        oCityConvert.OldSysNo = Util.TrimIntNull(dr2["SysNo"]);
                        oCityConvert.NewSysNo = oCity.SysNo;
                        new ImportDac().Insert(oCityConvert, "Area");

                        string sql3 = "select * from ipp2003..area where citySysNo = " + Util.TrimIntNull(dr2["SysNo"]);
                        DataSet ds3 = SqlHelper.ExecuteDataSet(sql3);
                        foreach (DataRow dr3 in ds3.Tables[0].Rows)
                        {
                            AreaInfo oDistrict = new AreaInfo();

                            oDistrict.ProvinceSysNo = oCity.ProvinceSysNo;
                            oDistrict.CitySysNo = oCity.SysNo;
                            oDistrict.ProvinceName = Util.TrimNull(dr3["ProvinceName"]);
                            oDistrict.CityName = Util.TrimNull(dr3["CityName"]);
                            oDistrict.DistrictName = Util.TrimNull(dr3["DistrictName"]);
                            oDistrict.IsLocal = Util.TrimIntNull(dr3["IsLocal"]);
                            oDistrict.Status = Util.TrimIntNull(dr3["Status"]);
                            oDistrict.OrderNumber = "zzz";
                            this.InsertArea(oDistrict);

                            //insert into convert table
                            ImportInfo oDistrictConvert = new ImportInfo();
                            oDistrictConvert.OldSysNo = Util.TrimIntNull(dr3["SysNo"]);
                            oDistrictConvert.NewSysNo = oDistrict.SysNo;
                            new ImportDac().Insert(oDistrictConvert, "Area");
                        }
                    }
                }
                scope.Complete();
            }
        }
Example #6
0
 /// <summary>
 /// ������Ȼ�ñ�������Ӧ��ȵĵ�����
 /// </summary>
 /// <param name="depth"></param>
 /// <returns></returns>
 public int GetAreaSysNo(int depth, AreaInfo oArea)
 {
     if (depth == this.GetAreaType(oArea))
     {
         return oArea.SysNo;
     }
     switch (depth)
     {
         case (int)AppEnum.AreaType.Province:
             return oArea.ProvinceSysNo;
         case (int)AppEnum.AreaType.City:
             return oArea.CitySysNo;
         case (int)AppEnum.AreaType.District:
             return oArea.SysNo;
         default:
             return 0;
     }
 }
Example #7
0
 private void Map(AreaInfo oParam, DataRow tempdr)
 {
     oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
     oParam.ProvinceSysNo = Util.TrimIntNull(tempdr["ProvinceSysNo"]);
     oParam.CitySysNo = Util.TrimIntNull(tempdr["CitySysNo"]);
     oParam.ProvinceName = Util.TrimNull(tempdr["ProvinceName"]);
     oParam.CityName = Util.TrimNull(tempdr["CityName"]);
     oParam.DistrictName = Util.TrimNull(tempdr["DistrictName"]);
     oParam.OrderNumber = Util.TrimNull(tempdr["OrderNumber"]);
     oParam.IsLocal = Util.TrimIntNull(tempdr["IsLocal"]);
     oParam.Status = Util.TrimIntNull(tempdr["Status"]);
     oParam.LocalCode = Util.TrimIntNull(tempdr["LocalCode"]);
 }
Example #8
0
        public int UpdateArea(AreaInfo oParam)
        {
            if (!areaHash.ContainsKey(oParam.SysNo))
                throw new BizException("the area does not exist, update failed");

            int result = new ASPDac().UpdateArea(oParam);
            SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);

            areaHash.Remove(oParam.SysNo);
            areaHash.Add(oParam.SysNo, oParam);

            return result;
        }
Example #9
0
        public int InsertArea(AreaInfo oParam)
        {
            if (!AppConfig.IsImportable)
                foreach (AreaInfo item in areaHash.Values)
                {
                    if (item.GetWholeName() == oParam.GetWholeName())
                        throw new BizException("area duplicated");
                }
            oParam.SysNo = SequenceDac.GetInstance().Create("Area_Sequence");
            int result = new ASPDac().InsertArea(oParam);
            SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);

            areaHash.Add(oParam.SysNo, oParam);
            return result;
        }
Example #10
0
 public void InitArea()
 {
     lock (areaLock)
     {
         if (areaHash != null)
             areaHash.Clear();
         string sql = "select * from area order by ProvinceName,CityName,DistrictName";
         DataSet ds = SqlHelper.ExecuteDataSet(sql);
         if (!Util.HasMoreRow(ds))
             return;
         foreach (DataRow dr in ds.Tables[0].Rows)
         {
             AreaInfo item = new AreaInfo();
             Map(item, dr);
             if (areaHash == null)
             {
                 areaHash = new Hashtable(1000);
             }
             areaHash.Add(item.SysNo, item);
         }
     }
 }