private string generateOnhandNo()
{
ONHAND_D pair;
var prefixRules = "";
var runningNo = "";
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
try
{
List <sanm1> sanm1 = db.Select <sanm1>("SELECT Prefix, NextNo FROM sanm1 WHERE NumberType = 'OMOH'");
prefixRules = Modfunction.CheckNull(sanm1[0].Prefix);
runningNo = Modfunction.CheckNull(sanm1[0].NextNo);
pair = generateTransactionNo(prefixRules, runningNo);
string strSql = "";
strSql = "NextNo=" + Modfunction.SQLSafeValue(pair.NextNo) + "";
db.Update("sanm1",
strSql,
"numbertype='OMOH' ");
}
catch (Exception ex)
{
throw ex;
}
}
return(pair.TrxNo);
}
private void grd_sasr1_SelectionChanged(object sender, EventArgs e)
{
if (grd_sasr1.RowCount > 0)
{
if (grd_sasr1.CurrentRow != null)
{
{
txt_RequestDes.Text = Modfunction.CheckNull(grd_sasr1.Rows[grd_sasr1.CurrentRow.Index].Cells["RequestDescription"].Value).ToString().Replace("\n", "\r\n");
txt_TestSummary.Text = grd_sasr1.Rows[grd_sasr1.CurrentRow.Index].Cells["TestSummary"].Value.ToString().Replace("\n", "\r\n");
this.txt_RequestDescription.Text = grd_sasr1.Rows[grd_sasr1.CurrentRow.Index].Cells["RequestDescription"].Value.ToString().Replace("\n", "\r\n");
txt_ProgramingSummary.Text = Modfunction.CheckNull(grd_sasr1.Rows[grd_sasr1.CurrentRow.Index].Cells["ProgrammingSummary"].Value).ToString().Replace("\n", "\r\n");
}
}
}
}
public void SaveInsertGroupNameEvent(string strInsertNextGroupCode, int intLineItem, string strJobNo, string strUserId)
{
List <Jmjm3> ResultJmjm3 = null;
List <Jmeg2> ResultJmeg2 = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
int intMaxLineItemNo = 0;
string strSelectJmjm3 = "Select Max(LineItemNo) as LineItemNo from Jmjm3 Where JobNo = '" + strJobNo + "'";
ResultJmjm3 = db.Select <Jmjm3>(strSelectJmjm3);
if (ResultJmjm3.Count > 0)
{
intMaxLineItemNo = ResultJmjm3[0].LineItemNo + 1;
}
string strSelectJmeg2 = "Select EventCode from Jmeg2 Where GroupCode = '" + strInsertNextGroupCode + "'";
ResultJmeg2 = db.Select <Jmeg2>(strSelectJmeg2);
if (ResultJmeg2.Count > 0)
{
if (intLineItem > 0)
{
string StrUpdateJmjm7 = "Update Jmjm7 Set JobLineItemNo = JobLineItemNo + " + ResultJmeg2.Count + " Where JobNo = '" + strJobNo + "' AND JobLineItemNo > " + intLineItem;
db.ExecuteSql(StrUpdateJmjm7);
string StrUpdateJmjm4 = "Update Jmjm4 Set JobLineItemNo = JobLineItemNo + " + ResultJmeg2.Count + " Where JobNo = '" + strJobNo + "' AND JobLineItemNo > " + intLineItem;
db.ExecuteSql(StrUpdateJmjm4);
string StrUpdateJmjm3 = "update Jmjm3 Set LineItemNo = LineItemNo + " + ResultJmeg2.Count + " Where JobNo = '" + strJobNo + "' AND LineItemNo > " + intLineItem;
db.ExecuteSql(StrUpdateJmjm3);
intMaxLineItemNo = intLineItem + 1;
}
for (int i = 0; i < ResultJmeg2.Count; i++)
{
string StrInsertJmjm3 = "INSERT INTO Jmjm3 (JobNo, LineItemNo,EventCode, Description, ShowETrackFlag,Remark,UpdateBy, UpdateDateTime) " + "Select '" + strJobNo + "'," + intMaxLineItemNo + ",EventCode,Description,EtrackFlag,Remark,'" + strUserId + "', getdate() from Jmje1 Where EventCode= '" + ResultJmeg2[i].EventCode + "'";
db.ExecuteSql(StrInsertJmjm3);
UpdateEventListToJmjm4(Modfunction.CheckNull(ResultJmeg2[i].EventCode), intMaxLineItemNo, strJobNo);
intMaxLineItemNo = intMaxLineItemNo + 1;
}
}
}
}
catch { throw; }
}
public List <Impa1> Get_Impa1_List()
{
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
string strSQL = "Select isNull(ShowCycleCountAppFlag,'N') as ShowCycleCountAppFlag,BarCodeField ,isnull(AppTallyConfirmStatus,'') as AppTallyConfirmStatus, isnull(AppPutawayConfirmStatus,'') as AppPutawayConfirmStatus ,isnull(AppPickConfirmStatus,'') as AppPickConfirmStatus ,isnull(AppIssueVerifyStatus,'') as AppIssueVerifyStatus from Impa1";
ResultImpa1 = db.Select <Impa1>(strSQL);
AppTallyConfirmStatus = Modfunction.CheckNull(ResultImpa1[0].AppTallyConfirmStatus);
AppPutawayConfirmStatus = Modfunction.CheckNull(ResultImpa1[0].AppPutawayConfirmStatus);
AppPickConfirmStatus = Modfunction.CheckNull(ResultImpa1[0].AppPickConfirmStatus);
AppIssueVerifyStatus = Modfunction.CheckNull(ResultImpa1[0].AppIssueVerifyStatus);
}
}
catch { throw; }
return(ResultImpa1);
}
public string GoodsTransfer(string strAsn, string strConfirmBy)
{
string Result = "";
string strBarCode = GetBarCode("UserDefine01");
DataTable dtWhScan = GetSQLCommandReturnDT("Select *,Impr1.TrxNo AS PrductTrxNo,Impr1.CustomerCode AS ProductCustomerCode from WhScan join Impr1 On Impr1." + strBarCode + " = WhScan.BarCode Where AsnNo = " + Modfunction.SQLSafeValue(strAsn) + " AND ComfirmBy = " + Modfunction.SQLSafeValue(strConfirmBy));
Boolean blnSameCustomer = true;
if (dtWhScan != null && dtWhScan.Rows.Count > 0)
{
string strCustomer = Modfunction.CheckNull(dtWhScan.Rows[0]["ProductCustomerCode"]);
for (int i = 1; i < dtWhScan.Rows.Count; i++)
{
if (strCustomer != Modfunction.CheckNull(dtWhScan.Rows[0]["ProductCustomerCode"]))
{
blnSameCustomer = false;
break;
}
}
Result = SaveImit(dtWhScan, blnSameCustomer);
}
return(Result);
}
public string Insert_Aemt1(List <Pid_AEMT1> objAemt1)
{
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
string KeyMAwbNo = setKeyMAwbNo(Modfunction.CheckNull(objAemt1[0].MAwbNo));
for (int i = 0; i < objAemt1.Count; i++)
{
string strSql = "";
string TallyById = "";
string MAwbNo = Modfunction.CheckNull(objAemt1[i].MAwbNo);
string PID_NO = Modfunction.CheckNull(objAemt1[i].PID_NO);
string LOC_CODE = Modfunction.CheckNull(objAemt1[i].LOC_CODE);
strSql = "insert into Aemt1( " +
" KeyMAwbNo ," +
" MAwbNo," +
" PID_NO, " +
" LOC_CODE, " +
" TallyById," +
" TallyByDateTime" +
" )" +
"values( " +
Modfunction.SQLSafeValue(KeyMAwbNo) + ", " +
Modfunction.SQLSafeValue(MAwbNo) + " , " +
Modfunction.SQLSafeValue(PID_NO) + " , " +
Modfunction.SQLSafeValue(LOC_CODE) + " , " +
Modfunction.SQLSafeValue(TallyById) + "," +
" GetDate()" +
") ";
db.ExecuteSql(strSql);
}
;
}
}
catch { throw; }
return("");
}
public int Update_verify_imgi1(Imgi request)
{
Get_Impa1_List();
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
if (Modfunction.CheckNull(AppIssueVerifyStatus) != "")
{
Result = db.Update <Imgi1>(
new
{
StatusCode = AppIssueVerifyStatus
},
p => p.TrxNo == int.Parse(request.TrxNo)
);
}
}
}
catch { throw; }
return(Result);
}
public int UpdateAll_Aemp1WithAido1(Aemp_Aido 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++)
{
if (ja[i]["TableName"] == null || ja[i]["TableName"].ToString() == "")
{
continue;
}
string strKey = ja[i]["Key"].ToString();
string strTableName = ja[i]["TableName"].ToString();
string strRemark = "";
string strStatusCode = "";
if (ja[i]["Remark"] != null || ja[i]["Remark"].ToString() != "")
{
strRemark = ja[i]["Remark"].ToString();
}
if (ja[i]["StatusCode"] != null || ja[i]["StatusCode"].ToString() != "")
{
strStatusCode = ja[i]["StatusCode"].ToString();
}
if (strStatusCode.ToLower() == "cancel")
{
string strJobNo = "";
if (ja[i]["JobNo"] != null || ja[i]["JobNo"].ToString() != "")
{
strJobNo = ja[i]["JobNo"].ToString();
}
if (strJobNo != "")
{
int intMaxLineItemNo = 1;
List <Jmjm3> list1 = db.Select <Jmjm3>("Select Max(LineItemNo) LineItemNo from Jmjm3 Where JobNo = " + Modfunction.SQLSafeValue(strJobNo));
if (list1 != null)
{
if (list1[0].LineItemNo > 0)
{
intMaxLineItemNo = list1[0].LineItemNo + 1;
}
}
db.Insert(new Jmjm3
{
JobNo = strJobNo,
DateTime = DateTime.Now,
UpdateDatetime = DateTime.Now,
LineItemNo = intMaxLineItemNo,
AutoFlag = "N",
StatusCode = "CANCEL",
UpdateBy = ja[0]["DriverCode"] == null ? "" : Modfunction.SQLSafe(ja[0]["DriverCode"].ToString()),
Remark = Modfunction.SQLSafe(strRemark),
Description = ja[0]["CancelDescription"] == null ? "" : Modfunction.SQLSafe(ja[0]["CancelDescription"].ToString())
});
if (strTableName == "Aemp1")
{
db.Update(strTableName,
" Remark = '" + Modfunction.SQLSafe(strRemark) + "'",
" TrxNo='" + strKey + "'");
}
else if (strTableName == "Sido1")
{
db.Update(strTableName,
" Remark = '" + Modfunction.SQLSafe(strRemark) + "'",
" TrxNo='" + strKey + "'");
}
else
{
db.Update(strTableName,
" Remark = '" + Modfunction.SQLSafe(strRemark) + "'",
" DeliveryOrderNo='" + strKey + "'");
}
}
}
else
{
if (strTableName == "Aemp1")
{
db.Update(strTableName,
" Remark = '" + Modfunction.SQLSafe(strRemark) + "',StatusCode = '" + strStatusCode + "',SignBy='" + Modfunction.CheckNull(request.SignBy) + "'",
" TrxNo='" + strKey + "'");
}
else if (strTableName == "Sido1")
{
db.Update(strTableName,
" Remark = '" + Modfunction.SQLSafe(strRemark) + "',StatusCode = '" + strStatusCode + "',SignBy='" + Modfunction.CheckNull(request.SignBy) + "'",
" TrxNo='" + strKey + "'");
}
else
{
db.Update(strTableName,
" Remark = '" + Modfunction.SQLSafe(strRemark) + "',StatusCode = '" + strStatusCode + "',SignBy='" + Modfunction.CheckNull(request.SignBy) + "'",
" DeliveryOrderNo='" + strKey + "'");
}
}
}
Result = 1;
}
}
}
}
catch { throw; }
return(Result);
}
public int confirm_Aemp1WithAido1(Aemp_Aido request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
if (request.TableName == "Aemp1")
{
db.Update(request.TableName,
" Remark = '" + request.Remark + "',StatusCode = 'POD',ActualPickUpDateTime=getdate(),SignBy='" + Modfunction.CheckNull(request.SignBy) + "'",
" TrxNo='" + request.Key + "'");
}
else if (request.TableName == "Sido1")
{
db.Update(request.TableName,
" Remark = '" + request.Remark + "',StatusCode = 'POD',SignBy='" + Modfunction.CheckNull(request.SignBy) + "'",
" TrxNo='" + request.Key + "'");
}
else
{
db.Update(request.TableName,
" Remark = '" + request.Remark + "',StatusCode = 'POD',ActualDeliveryDateTime=getdate(),SignBy='" + Modfunction.CheckNull(request.SignBy) + "'",
" DeliveryOrderNo='" + request.Key + "'");
}
}
}
catch { throw; }
return(Result);
}
public int LoginCheck(Wms_Login request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
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 strSqlSaus1 = "";
string strUserId = ja[i]["UserId"].ToString();
string strPassword = ja[i]["Password"].ToString();
//strSqlSaus1 = "Select count(*) From Saus1 Where UserId='" + Modfunction.CheckNull(strUserId) + "' And Password='******'";
strSqlSaus1 = "Select count(*) From Saus1 Where UserId='" + Modfunction.CheckNull(strUserId) + "'";
Result = db.Scalar <int>(strSqlSaus1);
}
}
}
}
}
catch { throw; }
return(Result);
}
public void UpdateEventListToJmjm4(string strEventCode, int intJobLineItemNo, string strJobNo)
{
List <Jmje2> ResultJmje2 = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
if (strEventCode != null && strEventCode != "")
{
string strSelectJmje2 = "Select * from Jmje2 Where EventCode = '" + strEventCode + "'";
ResultJmje2 = db.Select <Jmje2>(strSelectJmje2);
if (ResultJmje2.Count > 0)
{
int intLineItemNo = 1;
for (int i = 0; i < ResultJmje2.Count; i++)
{
string insertJmjm4 = "Insert Into Jmjm4(JobNo,JobLineItemNo,EventLineItemNo,LineItemNo,DoneFlag,ItemName,MobileUser,Remark) values (" +
"'" + strJobNo + "'," + intJobLineItemNo + "," + ResultJmje2[i].LineItemNo + "," + intLineItemNo + ",NULL,'" + Modfunction.CheckNull(ResultJmje2[i].ItemName) + "','" + Modfunction.CheckNull(ResultJmje2[i].MobileUser) + "', '' )";
intLineItemNo = intLineItemNo + 1;
db.ExecuteSql(insertJmjm4);
}
}
}
}
}
catch { throw; }
}
private string CreateGoodsReceiptNo(DataTable dt, string strNumberType)
{
string functionReturnValue = null;
int intI = 0;
string m_strJobSeqNo = "";
string m_strPullFrom = "";
string m_strUpdateNextField = "";
int intMonth = 0;
string strGoodsReceiptNo = null;
int intYear = 0;
string[] strArr = null;
DataTable dtRec = null;
DataTable dtRec2 = null;
string m_SQlCommandText = null;
functionReturnValue = "";
m_SQlCommandText = "Select * From Sanm1 Where NumberType = '" + strNumberType + "' Order By JobType Desc";
dtRec = GetSQLCommandReturnDT(m_SQlCommandText);
if ((dtRec != null))
{
if (dtRec.Rows.Count > 0)
{
if (dtRec.Rows[0]["Cycle"] == null)
{
return(functionReturnValue);
}
//Cycle = Continuous
if (dtRec.Rows[0]["Cycle"].ToString() == "C")
{
m_strPullFrom = "NextNo";
m_strJobSeqNo = Modfunction.CheckNull(dtRec.Rows[0]["NextNo"]);
//Cycle = Month
}
else if (Modfunction.CheckNull(dtRec.Rows[0]["Cycle"]) == "M")
{
intMonth = DateTime.Now.Month;
intYear = DateTime.Now.Year;
m_SQlCommandText = "Select * From Sanm2 Where TrxNo = " + Modfunction.CheckNull(dtRec.Rows[0]["TrxNo"]) + " And Year = '" + intYear + "'";
dtRec2 = GetSQLCommandReturnDT(m_SQlCommandText);
if ((dtRec2 != null))
{
if (dtRec2.Rows.Count > 0)
{
switch (intMonth)
{
case 1:
m_strPullFrom = "Mth01NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth01NextNo"].ToString();
break;
case 2:
m_strPullFrom = "Mth02NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth02NextNo"].ToString();
break;
case 3:
m_strPullFrom = "Mth03NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth03NextNo"].ToString();
break;
case 4:
m_strPullFrom = "Mth04NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth04NextNo"].ToString();
break;
case 5:
m_strPullFrom = "Mth05NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth05NextNo"].ToString();
break;
case 6:
m_strPullFrom = "Mth06NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth06NextNo"].ToString();
break;
case 7:
m_strPullFrom = "Mth07NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth07NextNo"].ToString();
break;
case 8:
m_strPullFrom = "Mth08NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth08NextNo"].ToString();
break;
case 9:
m_strPullFrom = "Mth09NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth09NextNo"].ToString();
break;
case 10:
m_strPullFrom = "Mth10NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth10NextNo"].ToString();
break;
case 11:
m_strPullFrom = "Mth11NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth11NextNo"].ToString();
break;
case 12:
m_strPullFrom = "Mth12NextNo";
m_strJobSeqNo = dtRec2.Rows[0]["Mth12NextNo"].ToString();
break;
}
}
else
{
return(functionReturnValue);
}
}
//No flag = Year
}
else if (Modfunction.CheckNull(dtRec.Rows[0]["Cycle"]) == "Y")
{
intYear = DateTime.Now.Year;
m_SQlCommandText = "Select YearNextNo From Sanm2 Where TrxNo = " + Modfunction.CheckNull(dtRec.Rows[0]["TrxNo"]) + " And Year = '" + intYear + "'";
dtRec2 = GetSQLCommandReturnDT(m_SQlCommandText);
if ((dtRec2 != null))
{
if (dtRec2.Rows.Count > 0)
{
m_strPullFrom = "YearNextNo";
m_strJobSeqNo = Modfunction.CheckNull(dtRec2.Rows[0]["YearNextNo"]);
}
else
{
return(functionReturnValue);
}
}
}
strGoodsReceiptNo = "";
if (Modfunction.CheckNull(dtRec.Rows[0]["Prefix"]) != "")
{
strArr = System.Text.RegularExpressions.Regex.Split(dtRec.Rows[0]["Prefix"].ToString(), ",");
for (intI = 0; intI <= strArr.Length; intI++)
{
strGoodsReceiptNo = strGoodsReceiptNo + ReturnPrefixSuffix(strArr[intI], dt);
}
}
strGoodsReceiptNo = strGoodsReceiptNo + m_strJobSeqNo;
// & "00"
if (Modfunction.CheckNull(dtRec.Rows[0]["Suffix"]).Trim().Length > 0)
{
strArr = null;
strArr = System.Text.RegularExpressions.Regex.Split(dtRec.Rows[0]["Suffix"].ToString(), ",");
for (intI = 0; intI <= strArr.Length; intI++)
{
strGoodsReceiptNo = strGoodsReceiptNo + ReturnPrefixSuffix(strArr[intI], dt);
}
}
functionReturnValue = strGoodsReceiptNo;
//120629DC NET3983
if (functionReturnValue.Length > 20)
{
functionReturnValue = functionReturnValue.Substring(functionReturnValue.Length - 20, 20);
}
m_strUpdateNextField = CheckUpdateFieldLength(m_strJobSeqNo);
//Cycle = Continuous
if (Modfunction.CheckNull(dtRec.Rows[0]["Cycle"]) == "C")
{
m_SQlCommandText = "Update Sanm1 Set " + m_strPullFrom + " = '" + Modfunction.SQLSafe(m_strUpdateNextField) + "' Where TrxNo = " + Modfunction.CheckNull(dtRec.Rows[0]["TrxNo"]);
//Add 1 For Next Job No
}
else
{
m_SQlCommandText = "Update Sanm2 Set " + m_strPullFrom + " = '" + Modfunction.SQLSafe(m_strUpdateNextField) + "' Where TrxNo = " + Modfunction.CheckNull(dtRec.Rows[0]["TrxNo"]) + " And Year = '" + intYear + "'";
}
GetSQLCommandReturnInt(m_SQlCommandText);
}
}
return(functionReturnValue);
}
private string ReturnPrefixSuffix(string strPrefixSuffix, DataTable dtImgr)
{
string functionReturnValue = null;
functionReturnValue = "";
// ERROR: Not supported in C#: OnErrorStatement
int intMth = 0;
switch (strPrefixSuffix)
{
case "MM":
functionReturnValue = DateTime.Now.Month.ToString();
break;
case "M":
intMth = DateTime.Now.Month;
if (intMth == 10)
{
functionReturnValue = "O";
}
else if (intMth == 11)
{
functionReturnValue = "N";
}
else if (intMth == 12)
{
functionReturnValue = "D";
}
else
{
functionReturnValue = intMth.ToString();
}
break;
case "YY":
functionReturnValue = DateTime.Now.ToString("yy");
break;
case "Y":
functionReturnValue = DateTime.Now.ToString("yy").Substring(1, 1);
break;
case "NN":
functionReturnValue = "00";
break;
case "N":
functionReturnValue = "0";
break;
case "CUST":
//120629DC NET3983
functionReturnValue = Modfunction.CheckNull(dtImgr.Rows[0]["CustomerCode"]);
break;
default:
if (strPrefixSuffix.Substring(0, 1) == "F")
{
functionReturnValue = strPrefixSuffix.Substring(1);
}
break;
}
return(functionReturnValue);
}
public int UpdateDone(Update_Done request)
{
int Result = -1;
List <Jmjm4> ResultJmjm4 = null;
List <Jmjm4> ResultJmjm4DoneFlag = null;
List <Jmje2> ResultJmje2 = null;
string strEventCode = "";
string strSqlJmje2 = "";
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
if (request.DoneDateTime != DateTime.MinValue)
{
Result = db.Update <Jmjm4>(new { DoneDateTime = request.DoneDateTime, DoneFlag = request.DoneFlag, Remark = request.Remark, ContainerNo = request.ContainerNo }, p => p.JobNo == request.JobNo && p.JobLineItemNo == request.JobLineItemNo && p.LineItemNo == request.LineItemNo);
}
else
{
Result = db.Update <Jmjm4>(new { DoneFlag = request.DoneFlag, Remark = request.Remark, ContainerNo = request.ContainerNo }, p => p.JobNo == request.JobNo && p.JobLineItemNo == request.JobLineItemNo && p.LineItemNo == request.LineItemNo);
}
if (Result > 0)
{
InsertContainerNo(request);
}
string strSql = "select (Select EventCode From jmjm3 where jmjm3.jobno=jmjm4.jobno and jmjm3.LineItemNo =jmjm4.JobLineItemNo ) as EventCode,* from jmjm4 where jobno ='" + request.JobNo + "'And JobLineItemNo='" + request.JobLineItemNo + "' And LineItemNo='" + request.LineItemNo + "' and PhoneNumber='" + request.PhoneNumber + "' ";
ResultJmjm4 = db.Select <Jmjm4>(strSql);
if (ResultJmjm4.Count > 0)
{
strEventCode = Modfunction.CheckNull(ResultJmjm4[0].EventCode);
strSqlJmje2 = "Select InsertNextEventCode ,InsertNextEventGroup From jmje2 Where EventCode='" + strEventCode + "' And LineItemNo in (Select EventLineItemNo From Jmjm4 Where jobno ='" + request.JobNo + "'And JobLineItemNo='" + request.JobLineItemNo + "' And LineItemNo='" + request.LineItemNo + "' )";
ResultJmje2 = db.Select <Jmje2>(strSqlJmje2);
if (ResultJmje2.Count > 0)
{
if (Modfunction.CheckNull(ResultJmje2[0].InsertNextEventCode) == "" && Modfunction.CheckNull(ResultJmje2[0].InsertNextEventGroup) == "")
{
bool BlnDoneFlag = true;
string strJmjm4DoneFlag = "select DoneFlag from jmjm4 where jobno ='" + request.JobNo + "'And JobLineItemNo='" + request.JobLineItemNo + "' and PhoneNumber='" + request.PhoneNumber + "' ";
ResultJmjm4DoneFlag = db.Select <Jmjm4>(strJmjm4DoneFlag);
if (ResultJmjm4DoneFlag.Count > 0)
{
for (int i = 0; i < ResultJmjm4DoneFlag.Count; i++)
{
if (ResultJmjm4DoneFlag[i].DoneFlag == "N")
{
BlnDoneFlag = false;
break;
}
}
if (BlnDoneFlag == true)
{
string strUpdateStautsCode;
strUpdateStautsCode = "Update Jmjm3 Set StatusCode ='CMP' Where JobNo ='" + request.JobNo + "' And LineItemNo ='" + request.JobLineItemNo + "'";
db.ExecuteSql(strUpdateStautsCode);
}
}
}
else
{
if (Modfunction.CheckNull(ResultJmje2[0].InsertNextEventCode).Length > 0)
{
SaveInsertNextEventCode(Modfunction.CheckNull(ResultJmje2[0].InsertNextEventCode), request.JobLineItemNo, request.JobNo, request.PhoneNumber);
}
if (Modfunction.CheckNull(ResultJmje2[0].InsertNextEventGroup).Length > 0)
{
SaveInsertGroupNameEvent(Modfunction.CheckNull(ResultJmje2[0].InsertNextEventGroup), request.JobLineItemNo, request.JobNo, request.PhoneNumber);
}
string strUpdateStautsCode;
strUpdateStautsCode = "Update Jmjm3 Set StatusCode ='CMP' Where JobNo ='" + request.JobNo + "' And LineItemNo ='" + request.JobLineItemNo + "'";
db.ExecuteSql(strUpdateStautsCode);
}
}
}
}
}
catch { throw; }
return(Result);
}
private string SaveImgr(DataTable dtWhScan, DataTable dtOmtx)
{
DataTable dtRec = null;
string Result = "";
int intSaveResult = -1;
DataTable dtImgr1 = GetSQLCommandReturnDT("Select Top 0 * from Imgr1");
dtImgr1.Columns.Remove(dtImgr1.Columns["TrxNo"]);
dtImgr1.Columns.Remove(dtImgr1.Columns["CreateDateTime"]);
dtImgr1.Columns.Remove(dtImgr1.Columns["UpdateDateTime"]);
dtImgr1.Rows.Add(dtImgr1.NewRow());
dtImgr1.Rows[0]["CustomerCode"] = dtWhScan.Rows[0]["CustomerCode"];
dtImgr1.Rows[0]["WarehouseCode"] = dtWhScan.Rows[0]["WarehouseCode"];
dtImgr1.Rows[0]["WarehouseName"] = dtWhScan.Rows[0]["WarehouseName"];
dtImgr1.Rows[0]["CustomerName"] = dtWhScan.Rows[0]["BusinessPartyName"];
dtImgr1.Rows[0]["CustomerAddress1"] = dtWhScan.Rows[0]["Address1"];
dtImgr1.Rows[0]["CustomerAddress2"] = dtWhScan.Rows[0]["Address2"];
dtImgr1.Rows[0]["CustomerAddress3"] = dtWhScan.Rows[0]["Address3"];
dtImgr1.Rows[0]["CustomerAddress4"] = dtWhScan.Rows[0]["Address4"];
dtImgr1.Rows[0]["ReceiptDate"] = DateTime.Today;
dtImgr1.Rows[0]["CreateBy"] = dtWhScan.Rows[0]["ConfirmBy"];
dtImgr1.Rows[0]["UpdateBy"] = dtWhScan.Rows[0]["ConfirmBy"];
dtImgr1.Rows[0]["WorkStation"] = "PDADriver_" + dtWhScan.Rows[0]["ConfirmBy"].ToString();
dtImgr1.Rows[0]["GoodsReceiptNoteNo"] = CreateGoodsReceiptNo(dtImgr1, "Imgr");
if (dtImgr1.Rows[0]["GoodsReceiptNoteNo"] == null || dtImgr1.Rows[0]["GoodsReceiptNoteNo"].ToString() == "")
{
dtRec = GetSQLCommandReturnDT("Select NextGoodsReceiptNo From Impa1");
dtImgr1.Rows[0]["GoodsReceiptNoteNo"] = Modfunction.CheckNull(dtRec.Rows[0][0]);
string strNewNextGoodsReceiptNo = CheckUpdateFieldLength(Modfunction.CheckNull(dtRec.Rows[0][0])).ToString();
GetSQLCommandReturnInt("Update Impa1 set NextGoodsReceiptNo = '" + Modfunction.SQLSafe(strNewNextGoodsReceiptNo) + "'");
}
intSaveResult = InsertTableRecordByDatatable("Imgr1", dtImgr1);
if (intSaveResult == -1)
{
return("Confirm unsuccess.");
}
dtRec = GetSQLCommandReturnDT("Select Max(TrxNo) from Imgr1 Where WorkStation = " + Modfunction.SQLSafeValue(dtImgr1.Rows[0]["WorkStation"]) + " AND CreateBy = " + Modfunction.SQLSafeValue(dtImgr1.Rows[0]["CreateBy"]) + " AND CustomerCode = " + Modfunction.SQLSafeValue(dtImgr1.Rows[0]["CustomerCode"]));
if (dtRec != null && dtRec.Rows.Count > 0)
{
int intTrxNo = Convert.ToInt32(dtRec.Rows[0][0]);
DataTable dtImgr2 = GetSQLCommandReturnDT("Select Top 0 from Imgr2 ");
dtImgr2.Rows.Clear();
for (int intIndex = 0; intIndex < dtWhScan.Rows.Count; intIndex++)
{
dtRec = GetSQLCommandReturnDT("Select * from Impr1 Where TrxNo = " + Convert.ToInt32(dtWhScan.Rows[intIndex]["ProductTrxNo"]).ToString());
if (dtRec != null && dtRec.Rows.Count > 0)
{
dtImgr2.Rows.Add(dtImgr2.NewRow());
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["TrxNo"] = intTrxNo;
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["LineItemNo"] = dtImgr2.Rows.Count;
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["DimensionFlag"] = dtRec.Rows[0]["DimensionFlag"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["UnitVol"] = dtRec.Rows[0]["UnitVol"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["UnitWt"] = dtRec.Rows[0]["UnitWt"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["UnitVolFlag"] = dtRec.Rows[0]["UnitVolFlag"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["ProductTrxNo"] = dtRec.Rows[0]["TrxNo"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["ProductDescription"] = dtRec.Rows[0]["ProductName"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["Weight"] = Convert.ToDecimal(dtRec.Rows[0]["UnitWt"]) * Convert.ToInt32(dtWhScan.Rows[intIndex]["Qty"]);
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["Volume"] = Convert.ToDecimal(dtRec.Rows[0]["UnitVol"]) * Convert.ToInt32(dtWhScan.Rows[intIndex]["Qty"]);
if (dtRec.Rows[0]["DimensionFlag"] != null)
{
if (dtRec.Rows[0]["DimensionFlag"].ToString() == "1")
{
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["PackingQty"] = dtWhScan.Rows[intIndex]["Qty"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["WholeQty"] = Convert.ToInt32(dtWhScan.Rows[intIndex]["Qty"]) * Convert.ToInt32(dtRec.Rows[0]["PackingPackageSize"]);
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["LooseQty"] = Convert.ToInt32(dtImgr2.Rows[dtImgr2.Rows.Count - 1]["WholeQty"]) * Convert.ToInt32(dtRec.Rows[0]["WholePackageSize"]);
}
if (dtRec.Rows[0]["DimensionFlag"].ToString() == "2")
{
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["WholeQty"] = dtWhScan.Rows[intIndex]["Qty"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["LooseQty"] = Convert.ToInt32(dtImgr2.Rows[dtImgr2.Rows.Count - 1]["WholeQty"]) * Convert.ToInt32(dtRec.Rows[0]["WholePackageSize"]);
}
if (dtRec.Rows[0]["DimensionFlag"].ToString() == "3")
{
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["LooseQty"] = dtWhScan.Rows[intIndex]["Qty"];
}
}
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["DimensionFlag"] = dtRec.Rows[0]["DimensionFlag"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["StoreNo"] = dtWhScan.Rows[intIndex]["StoreNo"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["CustomerCode"] = dtWhScan.Rows[intIndex]["CustomerCode"];
dtImgr2.Rows[dtImgr2.Rows.Count - 1]["WarehouseCode"] = dtWhScan.Rows[intIndex]["WarehouseCode"];
saveImsn1SerialNo(Modfunction.CheckNull(dtImgr1.Rows[0]["GoodsReceiptNoteNo"]), Convert.ToInt32(dtImgr2.Rows[dtImgr2.Rows.Count - 1]["LineItemNo"]), Modfunction.CheckNull(dtWhScan.Rows[intIndex]["SerialNo"]), true);
}
}
if (dtImgr2 != null && dtImgr2.Rows.Count > 0)
{
intSaveResult = InsertTableRecordByDatatable("Imgr2", dtImgr2);
if (intSaveResult == -1)
{
return("Confirm unsuccess.");
}
}
}
else
{
Result = "Confirm Unsuccess.";
}
return(Result);
}
private string SaveImit(DataTable dtWhScan, Boolean blnSameCustomer)
{
string Result = "";
DataTable dtRec;
DataTable dtImit = GetSQLCommandReturnDT("Select Top 0 from imit1");
if (dtImit != null)
{
dtImit.Rows.Add(dtImit.NewRow());
if (blnSameCustomer)
{
dtImit.Rows[0]["CustomerCode"] = dtWhScan.Rows[0]["ProductCustomerCode"];
}
dtImit.Rows[0]["TransferDateTime"] = DateTime.Today;
dtImit.Rows[0]["CreateBy"] = dtWhScan.Rows[0]["ConfirmBy"];
dtImit.Rows[0]["UpdateBy"] = dtWhScan.Rows[0]["ConfirmBy"];
dtImit.Rows[0]["WorkStation"] = "PDADriver_" + dtWhScan.Rows[0]["ConfirmBy"].ToString();
dtImit.Rows[0]["GoodsTransferNoteNo"] = CreateGoodsReceiptNo(dtImit, "Imit");
if (dtImit.Rows[0]["GoodsTransferNoteNo"] == null || dtImit.Rows[0]["GoodsTransferNoteNo"].ToString() == "")
{
dtRec = GetSQLCommandReturnDT("Select NextGoodsTransferNo From Impa1");
dtImit.Rows[0]["GoodsTransferNoteNo"] = Modfunction.CheckNull(dtRec.Rows[0][0]);
string strNewNextGoodsTransferNo = CheckUpdateFieldLength(Modfunction.CheckNull(dtRec.Rows[0][0])).ToString();
GetSQLCommandReturnInt("Update Impa1 set NextGoodsTransferNo = '" + Modfunction.SQLSafe(strNewNextGoodsTransferNo) + "'");
}
int intSaveResult = InsertTableRecordByDatatable("Imit1", dtImit);
if (intSaveResult == -1)
{
return("Confirm unsuccess.");
}
dtRec = GetSQLCommandReturnDT("Select Max(TrxNo) from Imit1 Where WorkStation = " + Modfunction.SQLSafeValue(dtImit.Rows[0]["WorkStation"]) + " AND CreateBy = " + Modfunction.SQLSafeValue(dtImit.Rows[0]["CreateBy"]));
if (dtRec != null && dtRec.Rows.Count > 0)
{
int intTrxNo = Convert.ToInt32(dtRec.Rows[0][0]);
DataTable dtImit2 = GetSQLCommandReturnDT("Select Top 0 from Imit2 ");
dtImit2.Rows.Clear();
for (int intIndex = 0; intIndex < dtWhScan.Rows.Count; intIndex++)
{
dtRec = GetSQLCommandReturnDT("Select * from Impr1 Where TrxNo = " + Convert.ToInt32(dtWhScan.Rows[intIndex]["ProductTrxNo"]).ToString());
if (dtRec != null && dtRec.Rows.Count > 0)
{
dtImit2.Rows.Add(dtImit2.NewRow());
dtImit2.Rows[dtImit2.Rows.Count - 1]["TrxNo"] = intTrxNo;
dtImit2.Rows[dtImit2.Rows.Count - 1]["LineItemNo"] = dtImit2.Rows.Count;
dtImit2.Rows[dtImit2.Rows.Count - 1]["ProductTrxNo"] = dtRec.Rows[0]["TrxNo"];
dtImit2.Rows[dtImit2.Rows.Count - 1]["Weight"] = Convert.ToDecimal(dtRec.Rows[0]["UnitWt"]) * Convert.ToInt32(dtWhScan.Rows[intIndex]["Qty"]);
dtImit2.Rows[dtImit2.Rows.Count - 1]["Volume"] = Convert.ToDecimal(dtRec.Rows[0]["UnitVol"]) * Convert.ToInt32(dtWhScan.Rows[intIndex]["Qty"]);
if (dtRec.Rows[0]["DimensionFlag"] != null)
{
if (dtRec.Rows[0]["DimensionFlag"].ToString() == "1")
{
dtImit2.Rows[dtImit2.Rows.Count - 1]["PackingQty"] = dtWhScan.Rows[intIndex]["Qty"];
dtImit2.Rows[dtImit2.Rows.Count - 1]["WholeQty"] = Convert.ToInt32(dtWhScan.Rows[intIndex]["Qty"]) * Convert.ToInt32(dtRec.Rows[0]["PackingPackageSize"]);
dtImit2.Rows[dtImit2.Rows.Count - 1]["LooseQty"] = Convert.ToInt32(dtImit2.Rows[dtImit2.Rows.Count - 1]["WholeQty"]) * Convert.ToInt32(dtRec.Rows[0]["WholePackageSize"]);
}
if (dtRec.Rows[0]["DimensionFlag"].ToString() == "2")
{
dtImit2.Rows[dtImit2.Rows.Count - 1]["WholeQty"] = dtWhScan.Rows[intIndex]["Qty"];
dtImit2.Rows[dtImit2.Rows.Count - 1]["LooseQty"] = Convert.ToInt32(dtImit2.Rows[dtImit2.Rows.Count - 1]["WholeQty"]) * Convert.ToInt32(dtRec.Rows[0]["WholePackageSize"]);
}
if (dtRec.Rows[0]["DimensionFlag"].ToString() == "3")
{
dtImit2.Rows[dtImit2.Rows.Count - 1]["LooseQty"] = dtWhScan.Rows[intIndex]["Qty"];
}
}
dtImit2.Rows[dtImit2.Rows.Count - 1]["NewStoreNo"] = dtWhScan.Rows[intIndex]["StoreNo"];
dtImit2.Rows[dtImit2.Rows.Count - 1]["NewWarehouseCode"] = dtWhScan.Rows[intIndex]["WarehouseCode"];
dtImit2.Rows[dtImit2.Rows.Count - 1]["StoreNo"] = dtWhScan.Rows[intIndex]["OldStoreNo"];
dtImit2.Rows[dtImit2.Rows.Count - 1]["WarehouseCode"] = dtWhScan.Rows[intIndex]["OldWarehouseCode"];
}
}
if (dtImit2 != null && dtImit2.Rows.Count > 0)
{
intSaveResult = InsertTableRecordByDatatable("Imit2", dtImit2);
if (intSaveResult == -1)
{
return("Confirm unsuccess.");
}
}
}
else
{
Result = "Confirm Unsuccess.";
}
return(Result);
}
return(Result);
}
public int insert_tjms5(Tobk request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
//if (request.UpdateAllString != null && request.UpdateAllString != "")
//{
// JArray ja = (JArray)JsonConvert.DeserializeObject(request.UpdateAllString);
// if (ja != null)
// {
// for (int i = 0; i < ja.Count(); i++)
// {
if (request.TrxNo.Length > 0)
{
int TrxNo = Modfunction.ReturnZero(request.TrxNo.ToString());
string EquipmentType = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.EquipmentType));
string EquipmentTypeDescription = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.EquipmentTypeDescription));
string ContainerNo = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.ContainerNo));
string CargoDescription = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.CargoDescription));
double Volume = Modfunction.ReturnDobule(request.Volume);
double ChargeWeight = Modfunction.ReturnDobule(request.ChargeWeight);
double ChgWtRoundUp = Modfunction.ReturnDobule(request.ChgWtRoundUp);
string VehicleNo = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.VehicleNo));
string startDateTime = "(select Top 1 ISNULL(StartDateTime,NULL) AS StartDateTime from tjms4 where TrxNo=" + TrxNo + ") ";
string endDateTime = "(select Top 1 ISNULL(EndDateTime,NULL) AS EndDateTime from tjms4 where TrxNo=" + TrxNo + ")";
string strSql = "";
int intMaxLineItemNo = 1;
List <Tjms5> list1 = db.Select <Tjms5>("Select Max(LineItemNo) LineItemNo from Tjms5 Where TrxNo = " + TrxNo);
if (list1 != null)
{
if (list1[0].LineItemNo > 0)
{
intMaxLineItemNo = list1[0].LineItemNo + 1;
}
}
if (intMaxLineItemNo != 0)
{
strSql = "insert into tjms5 (" +
" TrxNo ," +
" LineItemNo ," +
" EquipmentType ," +
" EquipmentTypeDescription ," +
" ContainerNo ," +
" CargoDescription ," +
" Volume ," +
" ChargeWeight ," +
" ChgWtRoundUp ," +
" editflag ," +
" VehicleNo " +
" )" +
"values( " +
TrxNo + " , " +
intMaxLineItemNo + " , " +
EquipmentType + " , " +
EquipmentTypeDescription + " , " +
ContainerNo + " , " +
CargoDescription + " , " +
Volume + " , " +
ChargeWeight + " , " +
ChgWtRoundUp + " , " +
"(Select isnull(editFlag,'') From tovt1 where VehicleTypeDescription =" + EquipmentTypeDescription + ")," +
VehicleNo + " " +
") ";
db.ExecuteSql(strSql);
strSql = " update tjms2 set ChargeWeight = (select sum(ChgWtRoundUp) from tjms5 where TrxNo=" + TrxNo + ") Where LineItemNo =1 and TrxNo=" + TrxNo + " ";
db.ExecuteSql(strSql);
}
}
// }
//}
Result = 1;
//}
}
}
catch { throw; }
return(Result);
}
public int UpdateAll_tjms5(Tobk request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
//if (request.UpdateAllString != null && request.UpdateAllString != "")
//{
// JArray ja = (JArray)JsonConvert.DeserializeObject(request.UpdateAllString);
// if (ja != null)
// {
// for (int i = 0; i < ja.Count(); i++)
// {
if (request.TrxNo.Length > 0)
{
int TrxNo = Modfunction.ReturnZero(request.TrxNo.ToString());
string EquipmentType = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.EquipmentType));
string EquipmentTypeDescription = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.EquipmentTypeDescription));
string ContainerNo = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.ContainerNo));
string CargoDescription = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.CargoDescription));
double Volume = Modfunction.ReturnDobule(request.Volume);
double ChargeWeight = Modfunction.ReturnDobule(request.ChargeWeight);
double ChgWtRoundUp = Modfunction.ReturnDobule(request.ChgWtRoundUp);
string VehicleNo = Modfunction.SQLSafeValue(Modfunction.CheckNull(request.VehicleNo));
int LineItemNo = Modfunction.ReturnZero(request.LineItemNo.ToString());
//int TrxNo = Modfunction.ReturnZero(request.TrxNo.ToString());
//string EquipmentType = Modfunction.SQLSafeValue(request.EquipmentType);
//string EquipmentTypeDescription = Modfunction.SQLSafeValue(request.EquipmentTypeDescription);
//string ContainerNo = Modfunction.SQLSafeValue(request.ContainerNo);
//string CargoDescription = Modfunction.SQLSafeValue(request.CargoDescription);
//int Volume = Modfunction.ReturnZero(request.Volume.ToString());
//int ChargeWeight = Modfunction.ReturnZero(request.ChargeWeight.ToString());
//int ChgWtRoundUp = Modfunction.ReturnZero(Modfunction.CheckNull(request.ChgWtRoundUp));
//string VehicleNo = Modfunction.SQLSafeValue(request.VehicleNo);
//int LineItemNo = Modfunction.ReturnZero(request.LineItemNo.ToString());
string strSql = "";
if (LineItemNo != 0)
{
strSql = "Update tjms5 set " +
"EquipmentType=" + EquipmentType + " , " +
"EquipmentTypeDescription=" + EquipmentTypeDescription + " ," +
"ContainerNo=" + ContainerNo + " , " +
"CargoDescription=" + CargoDescription + " , " +
"Volume=" + Volume + " ," +
"ChargeWeight=" + ChargeWeight + " , " +
"ChgWtRoundUp=" + ChgWtRoundUp + ", " +
"EditFlag=(select EditFlag from tovt1 where VehicleTypeDescription=" + EquipmentTypeDescription + " )," +
" VehicleNo=" + VehicleNo + " " +
"Where LineItemNo =" + LineItemNo + " And TrxNo=" + TrxNo + "";
db.ExecuteSql(strSql);
strSql = " update tjms2 set ChargeWeight = (select sum(ChgWtRoundUp) from tjms5 where TrxNo=" + TrxNo + ") Where LineItemNo =1 and TrxNo=" + TrxNo + " ";
db.ExecuteSql(strSql);
}
}
// }
//}
Result = 1;
//}
}
}
catch { throw; }
return(Result);
}