自动生成编号

 /// <summary>
        /// 自动生成编号
        /// </summary>
        /// <param name="M_str_sqlstr">SQL语句</param>
        /// <param name="M_str_table">表名</param>
        /// <param name="M_str_tbColumn">列名</param>
        /// <param name="M_str_codeIndex">编号的前部分</param>
        /// <param name="M_str_codeNum">编号的后部分</param>
        /// <param name="txt">txtbox控件</param>
        public void autoNum(string M_str_sqlstr, string M_str_table, string M_str_tbColumn, string M_str_codeIndex, string M_str_codeNum, TextBox txt)//自动生成编号
        {
            string P_str_Code = "";
            int P_int_Code = 0;
            int P_int_Flenght = 0;
            int P_int_Llenght = 0;
            DataSet myds = this.getds(M_str_sqlstr, M_str_table);//得到相应信息的数据集
            if (myds.Tables[0].Rows.Count == 0)//DS中无信息时
            {
                txt.Text = M_str_codeIndex + M_str_codeNum;
            }
            else
            {
                P_str_Code = Convert.ToString(myds.Tables[0].Rows[myds.Tables[0].Rows.Count - 1][M_str_tbColumn]);//获得DS中最后一行第一列的信息
                P_int_Flenght = M_str_codeIndex.Length;
                P_int_Llenght = P_str_Code.Length - P_int_Flenght;//获取截取的位置
                P_int_Code = Convert.ToInt32(P_str_Code.Substring(P_int_Flenght, P_int_Llenght)) + 1;
                P_str_Code = M_str_codeIndex + P_int_Code.ToString();//得到编号
                txt.Text = P_str_Code;
            }
        }