private ONHAND_D generateTransactionNo(string prefixRules, string runningNo)
{
var pair = new ONHAND_D();
var rules = prefixRules.Split(',');
var now = DateTime.Now;
foreach (var r in rules)
{
var rule = r.Trim();
if (rule == "YY" || rule == "MM")
{
pair.TrxNo += now.ToString(rule);
}
else
{
//assume is Fxx, until further instruction
pair.TrxNo += rule.Substring(1);
}
}
pair.TrxNo += runningNo;
//compute next number for storage.
var runningInt = 0;
Int32.TryParse(runningNo, out runningInt);
++runningInt;
pair.NextNo = runningInt.ToString(new String('0', runningNo.Length));
return(pair);
}
public List <ONHAND_D_Table> Get_ONHAND_D_List(ONHAND_D request)
{
List <ONHAND_D_Table> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
if (!string.IsNullOrEmpty(request.strONHAND_NO))
{
string strSQL = "";
strSQL = " select " +
" ISNULL(SHP_CODE, '') AS SHP_CODE, " +
" ISNULL((select BusinessPartyName from rcbp1 where BusinessPartyCode = SHP_CODE ),'') AS 'ShipperName', " +
" ISNULL(CNG_CODE,'') AS CNG_CODE, " +
" ISNULL( (select BusinessPartyName from rcbp1 where BusinessPartyCode = CNG_CODE),'' ) AS 'ConsigneeName', " +
" ONHAND_date, " +
" ISNULL(CASE_NO,'') AS CASE_NO, " +
" ISNULL( PUB_YN,'') AS PUB_YN, " +
" ISNULL(HAZARDOUS_YN,'') AS HAZARDOUS_YN , " +
" ISNULL(CLSF_YN,'') AS CLSF_YN, " +
" ISNULL(ExerciseFlag,'') AS ExerciseFlag , " +
" ISNULL(LOC_CODE,'') AS LOC_CODE, " +
" ISNULL(TRK_CODE,'') AS TRK_CODE, " +
" ISNULL(TRK_CHRG_TYPE,'') AS TRK_CHRG_TYPE, " +
" PICKUP_SUP_datetime, " +
" ISNULL(NO_INV_WH,0) AS NO_INV_WH, " +
" ISNULL((select sum(PIECES) from OH_PID_D where onhand_no = ONHAND_D.onhand_no ), 0) AS TotalPCS, " +
" ISNULL((select sum(GROSS_LB) from OH_PID_D where onhand_no = ONHAND_D.onhand_no ),0 ) AS TotalWeight " +
" from ONHAND_D where onhand_no ='" + request.strONHAND_NO + "'";
Result = db.Select <ONHAND_D_Table>(strSQL);
}
}
}
catch { throw; }
return(Result);
}
public int ConfirmAll_ONHAND_D(ONHAND_D request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
if (request.UpdateAllString != null && request.UpdateAllString != "")
{
JArray ja = (JArray)JsonConvert.DeserializeObject(request.UpdateAllString);
if (ja != null)
{
for (int i = 0; i < ja.Count(); i++)
{
string strSql = "";
string SHP_CODE = ja[i]["SHP_CODE"].ToString();
string CNG_CODE = ja[i]["CNG_CODE"].ToString();
string ONHAND_date = ja[i]["ONHAND_date"].ToString();
string CASE_NO = CASE_NO = ja[i]["CASE_NO"].ToString();
string PUB_YN = ja[i]["PUB_YN"].ToString();
string HAZARDOUS_YN = ja[i]["HAZARDOUS_YN"].ToString();
string CLSF_YN = ja[i]["CLSF_YN"].ToString();
string ExerciseFlag = ja[i]["ExerciseFlag"].ToString();
string LOC_CODE = ja[i]["LOC_CODE"].ToString();
string TRK_CODE = ja[i]["TRK_CODE"].ToString();
string TRK_CHRG_TYPE = ja[i]["TRK_CHRG_TYPE"].ToString();
string PICKUP_SUP_datetime = ja[i]["PICKUP_SUP_datetime"].ToString();
int NO_INV_WH;
string UserID = ja[i]["UserID"].ToString();
if (ja[i]["NO_INV_WH"].ToString() == "")
{
NO_INV_WH = 0;
}
else
{
NO_INV_WH = int.Parse(ja[i]["NO_INV_WH"].ToString());
}
strSql = "insert into ONHAND_D( " +
" onhand_no," +
" SHP_CODE," +
" CNG_CODE ," +
" ONHAND_date," +
" CASE_NO ," +
" PUB_YN," +
" HAZARDOUS_YN ," +
" CLSF_YN ," +
" ExerciseFlag ," +
" LOC_CODE ," +
" TRK_CODE ," +
" TRK_CHRG_TYPE ," +
" PICKUP_SUP_datetime," +
" NO_INV_WH," +
" CreateBy," +
" UpdateBy," +
" CreateDateTime," +
" UpdateDateTime," +
" StatusCode " +
" )" +
"values( " +
Modfunction.SQLSafeValue(generateOnhandNo()) + " , " +
Modfunction.SQLSafeValue(SHP_CODE) + "," +
Modfunction.SQLSafeValue(CNG_CODE) + "," +
Modfunction.SQLSafeValue(ONHAND_date) + "," +
Modfunction.SQLSafeValue(CASE_NO) + "," +
Modfunction.SQLSafeValue(PUB_YN) + "," +
Modfunction.SQLSafeValue(HAZARDOUS_YN) + "," +
Modfunction.SQLSafeValue(CLSF_YN) + "," +
Modfunction.SQLSafeValue(ExerciseFlag) + "," +
Modfunction.SQLSafeValue(LOC_CODE) + "," +
Modfunction.SQLSafeValue(TRK_CODE) + "," +
Modfunction.SQLSafeValue(TRK_CHRG_TYPE) + "," +
Modfunction.SQLSafeValue(PICKUP_SUP_datetime) + "," +
NO_INV_WH + "," +
Modfunction.SQLSafeValue(UserID) + "," +
Modfunction.SQLSafeValue(UserID) + "," +
"GETDATE()," +
"GETDATE()," +
"'USE'" +
") ";
db.ExecuteSql(strSql);
}
}
Result = 1;
}
}
}
catch { throw; }
return(Result);
}
