/// <summary>
/// 数据来源于最大值表！
/// 取最大值号〔已经自加1,无须再加1〕
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="codex">编码规则</param>
/// <param name="digit">位数</param>
/// <returns>生成后的编码</returns>
public string GetMaxNo(string tableName, string codex, int digit)
{
DataAccess db = new DataAccess(DataAccess.DBConn);
string maxNo = "";
ComCommand acmd = new ComCommand("PGetMax", db.DbConnection);
acmd.CommandType = System.Data.CommandType.StoredProcedure;
acmd.Parameters.AddWithValue("vi_TabName", tableName);
acmd.Parameters.AddWithValue("vi_Codex", codex);
acmd.Parameters.AddWithValue("vi_Digit", digit);
acmd.Parameters.AddWithValue("vo_ReturnValue", maxNo);
acmd.Parameters["vi_TabName"].Direction = System.Data.ParameterDirection.Input;
acmd.Parameters["vi_Codex"].Direction = System.Data.ParameterDirection.Input;
acmd.Parameters["vi_Digit"].Direction = System.Data.ParameterDirection.Input;
acmd.Parameters["vo_ReturnValue"].Direction = System.Data.ParameterDirection.InputOutput;
acmd.Parameters["vo_ReturnValue"].Size = 50;
try
{
db.Open();
acmd.ExecuteNonQuery();
maxNo = acmd.Parameters["vo_ReturnValue"].Value.ToString();
acmd.Dispose();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(maxNo.Trim());
}
public bool CheckCaseState(string caseId, string nameId, string typeId)
{
DataAccess db = new DataAccess(DataAccess.DBConn);
ComCommand acmd = new ComCommand("CheckCaseState", db.DbConnection);
acmd.CommandType = System.Data.CommandType.StoredProcedure;
acmd.Parameters.Add("caseId", caseId);
acmd.Parameters.Add("nameId", nameId);
acmd.Parameters.Add("typeId", typeId);
try
{
db.Open();
int count = acmd.ExecuteNonQuery();
acmd.Dispose();
if (count > 0)
{
return(true);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(false);
}
