点滴积累【C#】---检验编号在本表中自动生成，与其他表无关

检验编号在本表中自动生成，与其他表无关

效果：

描述：在本表中自动生成编号，与其他表无关。

调用：

protected void Page_Load(object sender, EventArgs e)
        {
            Response.Expires = -1;
            if (!IsPostBack)
            {
                if (ActionType == CommonEnum.ActionLevel.Write)
                { 
                    tbsybh.Text = Getsybh(); 
                }
            }
        }

protected string Getsybh()
        {
            string Getsybh = CommonFunction.GetByMenuCode(ThisPositionID, "hxty_lydj", "sybh", 5); ;
            return Getsybh;
        }

函数代码：

public static string GetByMenuCode(string ThisPositionID, string TableName, string RowName, int Digit)
        {
            string GetCode = string.Empty;
            string Title = string.Empty;
            string sql = string.Format("SELECT Max(RIGHT({0}," + Digit + ")+1) as RowName,LEFT(Max({0}),LEN(Max({0}))-" + Digit + ") as RowTitle FROM {1} ", RowName, TableName);
            DbCommand sqlCommand = ERPDataBase.ERPDB.GetSqlStringCommand(sql);
            DataSet dsData = new DataSet();
            ERPDataBase.ERPDB.LoadDataSet(sqlCommand, dsData, "data");
            if (dsData.Tables["data"].Rows.Count > 0)
            {
                DataRow row = dsData.Tables["data"].Rows[0];
                if (row["RowName"] == DBNull.Value)
                {
                    GetCode = "1";
                    GetCode = GetCode.PadLeft(Digit, '0');
                }
                else
                {
                    string second = row["RowName"].ToString();
                    GetCode = second.PadLeft(Digit, '0');
                }
                if (row["RowTitle"] != DBNull.Value)
                {
                    Title = row["RowTitle"].ToString();
                }
            }
            return Title + GetCode;
        }