/// <summary>
/// 伝票番号取得
/// </summary>
/// <param name="companyId">会社ID</param>
/// <param name="groupId">グループID</param>
/// <param name="db"></param>
/// <param name="kbn">伝票区分</param>
/// <param name="accountPeriod">会計年</param>
/// <param name="no">伝票番号</param>
/// <param name="id">伝票ID</param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static void GetInOutDeliveryNo(string companyId,
string groupId,
ExMySQLData db,
geInOutDeliverySlipKbn kbn,
long cause_no,
ref long _no,
ref long _id)
{
StringBuilder sb;
DataTable dt;
_no = 0;
_id = 0;
try
{
sb = new StringBuilder();
sb.Length = 0;
// 存在確認
sb.Append("SELECT ID " + Environment.NewLine);
sb.Append(" ,NO " + Environment.NewLine);
sb.Append(" FROM T_IN_OUT_DELIVERY_H AS T" + Environment.NewLine);
sb.Append(" WHERE T.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND T.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND T.GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND T.IN_OUT_DELIVERY_PROC_KBN = " + (int)kbn + Environment.NewLine);
sb.Append(" AND T.CAUSE_NO = " + cause_no + Environment.NewLine);
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
_no = ExCast.zCLng(dt.DefaultView[0]["NO"]);
_id = ExCast.zCLng(dt.DefaultView[0]["ID"]);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetInOutDeliveryNo", ex);
throw;
}
}
/// <summary>
/// 伝票番号取得
/// </summary>
/// <param name="companyId">会社ID</param>
/// <param name="groupId">グループID</param>
/// <param name="db"></param>
/// <param name="kbn">伝票区分</param>
/// <param name="accountPeriod">会計年</param>
/// <param name="no">伝票番号</param>
/// <param name="id">伝票ID</param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static void GetInOutDeliveryNo(string companyId,
string groupId,
ExMySQLData db,
geInOutDeliverySlipKbn kbn,
long cause_no,
ref long _no,
ref long _id)
{
StringBuilder sb;
DataTable dt;
_no = 0;
_id = 0;
try
{
sb = new StringBuilder();
sb.Length = 0;
// 存在確認
sb.Append("SELECT ID " + Environment.NewLine);
sb.Append(" ,NO " + Environment.NewLine);
sb.Append(" FROM T_IN_OUT_DELIVERY_H AS T" + Environment.NewLine);
sb.Append(" WHERE T.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND T.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND T.GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND T.IN_OUT_DELIVERY_PROC_KBN = " + (int)kbn + Environment.NewLine);
sb.Append(" AND T.CAUSE_NO = " + cause_no + Environment.NewLine);
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
_no = ExCast.zCLng(dt.DefaultView[0]["NO"]);
_id = ExCast.zCLng(dt.DefaultView[0]["ID"]);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetInOutDeliveryNo", ex);
throw;
}
}
