/// <summary>
/// 生成各种数据表的代码字段的值
/// </summary>
/// <param name="strTableName">数据表名</param>
/// <param name="strHeader">各种代码头</param>
/// <param name="intLength">代码可变动部分的长度</param>
/// <returns></returns>
public string BuildCode(string strTableName, string strWhere, string strCodeColumn, string strHeader, int intLength)
{
DataOperate dataOper = new DataOperate();
string strSql = "Select Max(" + strCodeColumn + ") From " + strTableName + " " + strWhere;
try
{
string strMaxCode = dataOper.GetSingleObject(strSql) as string;
if (String.IsNullOrEmpty(strMaxCode))
{
strMaxCode = strHeader + FormatString(intLength);
}
string strMaxSeqNum = strMaxCode.Substring(strHeader.Length);
return(strHeader + (Convert.ToInt32(strMaxSeqNum) + 1).ToString(FormatString(intLength)));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
throw ex;
}
}
