/// <summary>
/// 获取过磅编号（格式1-4位磅称，5-12位年月日，13-16位过磅编号 如0001 20080808 0001）
/// </summary>
/// <param name="TableName">表名</param>
/// <param name="KeyName">主键名</param>
/// <returns></returns>
public static string getMaxBangID(string TableName, string KeyName)
{
try
{
string RoomCode = new RWini().IniReadValue("RoomSetting", "RoomCode");
string sql = "Select CONVERT(varchar(8), GETDATE(), 112)+ right('0000'+cast(isnull(max(cast(substring(" + KeyName + ",14,4) as int)),0)+1 as varchar(4)),4)"
+ " From " + TableName
+ " Where substring(" + KeyName + ",5,8)=CONVERT(varchar(8), GETDATE(), 112) and substring(" + KeyName + ",1,4)='" + RoomCode.PadLeft(4, '0') + "'";
return RoomCode.PadLeft(4, '0') + DbHelperSQL.GetSingle(sql).ToString();
}
catch
{
return "";
}
}
/// <summary>
/// 获取过磅编号（格式1-4位磅称，5-18位年月日时分秒 如000120080808080808）
/// </summary>
/// <param name="TableName">表名</param>
/// <param name="KeyName">主键名</param>
/// <returns></returns>
public static string getMaxBangID()
{
try
{
DateTime dtTime = Convert.ToDateTime(DbHelperSQL.GetSingle("select getdate()"));
string RoomCode = new RWini().IniReadValue("RoomSetting", "RoomCode");
return RoomCode.PadLeft(4, '0') + dtTime.ToString("yyyyMMddHHmmss");
}
catch
{
return "";
}
}
