Пример #1
0
        /// <summary>
        /// 获取系统区域表资料省Id
        /// </summary>
        /// <returns></returns>
        public string CreateSystemAreaProvinceId()
        {
            object strId;

            try
            {
                string strsql = string.Format(" SELECT GA03001 FROM GA03 WHERE GA03998=(SELECT MAX(GA03998) FROM GA03 WHERE GA03003=0 ) ");
                strId = Provider.ExecuteScalar(strsql, 0, null);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            if (strId == null)
            {
                strId = "100000";
            }
            else
            {
                strId = (Convert.ToInt32(strId) + 10000).ToString();
            }
            return(strId.ToString());
        }