方法一： 

            DataSet ds = new DataSet;
            int p_int_newCode = 0;
            string P_string_newcode = "";
            ds = bc.ExecDS("select * from repair order by ID");
            if (ds.Tables[0].Rows.Count == 0)
            {
                labID.Text = DateTime.Now.ToString("yyyy-MM-dd") + "BX100001";
            }
            else
            {
                P_string_newcode = Convert.ToString(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["ID"]);
                p_int_newCode = Convert.ToInt32(P_string_newcode.Substring(12, 6)) + 1;
                P_string_newcode = DateTime.Now.ToString("yyyy-MM-dd") + "BX" + p_int_newCode.ToString();
                labID.Text = P_string_newcode;
            }

 

在ASP.NET中寫在Page_Load事件里

 

方法二：

#region   public void GetCustomerNO()編號自動增長
        //編號自動增長
        public void GetCustomerNO()//---------------------------------------------------------
        {
            int countone = 0;//計算零的個數(shù)
            string Zero = "C";//獲取數(shù)值前面的字符串
            string myID = "";//獲得字符串
            Logistics.DALayer.Customer myCustomer = new Logistics.DALayer.Customer();
            //自動增長邦定
            DataTable myDataTable = myCustomer.GetCustomerNO();
            //截取字符"C"
            if (myDataTable.Rows.Count == 0)
            {
                myID = "C000";
                myID = myID.Substring(1, myID.Length - 1);
            }
            else
            {
                myID = myDataTable.Rows[myDataTable.Rows.Count - 1]["CustomerNO"].ToString();
                myID = myID.Substring(1, myID.Length - 1);
            }
            //判斷有多上個零
            for (int i = 0; i <= myID.Length - 1; i++)
            {
                if (myID.Substring(i, 1) == "9")
                {
                    countone--;
                }
                if (myID.Substring(i, 1) == "0")
                {
                    if (i != myID.Length - 1)
                    {
                        countone++;
                        if (myID.Substring(i + 1, 1) != "0")
                        {
                            continue;
                        }
                    }
                }
            }
            //組合字符串
            for (int m = 0; m < countone; m++)
            {
                Zero += "0";
            }
            this.txtCustomerNO.Text = Zero + Convert.ToString((Convert.ToInt32(myID) + 1));
        }
        #endregion