public void Attachment_Delete(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
string status = "0";
string context = Common.StringToJson("");
int attachmentId = SafeValue.SafeInt(job["Id"], 0);
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.fixActionInfo_ByAttachmentId(attachmentId);
//lg.Remark = "Attachment delete file";
lg.setActionLevel(attachmentId, CtmJobEventLogRemark.Level.Attachment, 2);
string sql = string.Format(@"delete from CTM_Attachment where Id=@attachmentId");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@attachmentId", attachmentId, SqlDbType.Int));
ConnectSql_mb.sqlResult result = ConnectSql_mb.ExecuteNonQuery(sql, list);
if (result.status)
{
status = "1";
//===========log
lg.log();
}
Common.WriteJsonP(status, context);
}
public void ContainerTrip_Detail_Save(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Id", SafeValue.SafeInt(job["Id"], 0), SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@DriverCode", job["DriverCode"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ChessisCode", job["ChessisCode"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ToParkingLot", job["ToParkingLot"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@Remark", job["Remark"], SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@ToCode", job["ToCode"], SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@FromDate", job["FromDate_e"], SqlDbType.NVarChar, 10));
string sql = string.Format(@"update CTM_JobDet2 set DriverCode=@DriverCode,ChessisCode=@ChessisCode,ToParkingLot=@ToParkingLot,Remark=@Remark,ToCode=@ToCode,FromDate=@FromDate
where Id=@Id");
bool status = ConnectSql_mb.ExecuteNonQuery(sql, list).status;
if (status)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isTRIP(SafeValue.SafeInt(job["Id"], 0));
//lg.Remark = "Trip Update";
lg.setActionLevel(SafeValue.SafeInt(job["Id"], 0), CtmJobEventLogRemark.Level.Trip, 3);
lg.log();
}
Common.WriteJsonP(status, Common.StringToJson(""));
}
public void Review_In_Save(string info)
{
string info_ = HttpUtility.UrlDecode(Server.UrlDecode(info));
JObject job = (JObject)JsonConvert.DeserializeObject(info_);
string status = "0";
string context = Common.StringToJson("");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
//string sql = string.Format(@"update job_receipt set StatusCode=@StatusCode,ReceiveDate=getdate(),UserId=@UserId where row_id=@row_id");
string sql = string.Format(@"update job_house set CargoStatus=@StatusCode,EntryDate=getdate() where Id=@row_id");
list.Add(new ConnectSql_mb.cmdParameters("@row_id", SafeValue.SafeInt(job["Oid"], 0), SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@StatusCode", job["StatusCode"], SqlDbType.NVarChar, 30));
list.Add(new ConnectSql_mb.cmdParameters("@UserId", job["UserId"], SqlDbType.NVarChar, 100));
if (ConnectSql_mb.ExecuteNonQuery(sql, list).context.Equals("1"))
{
status = "1";
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isCARGO(SafeValue.SafeInt(job["Oid"], 0));
//lg.Remark = "Cargo status change:" + job["StatusCode"];
lg.setActionLevel(SafeValue.SafeInt(job["Oid"], 0), CtmJobEventLogRemark.Level.Cargo, 4, ":" + job["StatusCode"]);
lg.log();
}
Common.WriteJsonP(status, context);
}
public void Cost_Delete_ById(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
int No = SafeValue.SafeInt(job["No"], 0);
bool status = false;
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.setActionLevel(No, CtmJobEventLogRemark.Level.Invoice, 6);
string sql = string.Format(@"delete from job_cost where Id=@No");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@No", No, SqlDbType.Int));
ConnectSql_mb.sqlResult res = ConnectSql_mb.ExecuteNonQuery(sql, list);
if (res.status && res.context == "1")
{
status = true;
lg.log();
}
Common.WriteJsonP(status, Common.StringToJson(""));
}
public void ContainerTrips_ChangeStatus(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
string context = Common.StringToJson("");
string sql = string.Format(@"update ctm_jobdet1 set StatusCode=@StatusCode where Id=@contId");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@contId", SafeValue.SafeInt(job["contId"], 0), SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@StatusCode", job["StatusCode"], SqlDbType.NVarChar, 100));
bool status = ConnectSql_mb.ExecuteNonQuery(sql, list).status;
if (status)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isCONT(SafeValue.SafeInt(job["contId"], 0));
//lg.Remark = "Container change status:" + job["StatusCode"];
lg.setActionLevel(SafeValue.SafeInt(job["contId"], 0), CtmJobEventLogRemark.Level.Container, 4, " :" + job["StatusCode"]);
lg.log();
}
Common.WriteJsonP(status, context);
}
public void EGL_Driver_SaveDetail(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
string status = "0";
string context = Common.StringToJson("");
int Id = SafeValue.SafeInt(job["Id"], 0);
string Code = job["Code"].ToString();
string Name = job["Name"].ToString();
string Tel = job["Tel"].ToString();
string ICNo = job["ICNo"].ToString();
string Remark = job["Remark"].ToString();
string Isstaff = job["Isstaff"].ToString();
string TowheaderCode = job["TowheaderCode"].ToString();
string ServiceLevel = job["ServiceLevel"].ToString();
string StatusCode = job["StatusCode"].ToString();
string TeamNo = job["TeamNo"].ToString();
string LicenseExpiry = job["LicenseExpiry"].ToString();
string sql = "";
sql = string.Format(@"update ctm_driver set
Code=@Code,Name=@Name,Tel=@Tel,ICNo=@ICNo,Remark=@Remark,Isstaff=@Isstaff,TowheaderCode=@TowheaderCode,ServiceLevel=@ServiceLevel,StatusCode=@StatusCode,TeamNo=@TeamNo,LicenseExpiry=@LicenseExpiry
where Id=@Id");
if (Id == 0)
{
sql = string.Format(@"insert into ctm_driver (Code,Name,Tel,ICNo,Remark,Isstaff,TowheaderCode,ServiceLevel,StatusCode,TeamNo,LicenseExpiry)
values (@Code,@Name,@Tel,@ICNo,@Remark,@Isstaff,@TowheaderCode,@ServiceLevel,@StatusCode,@TeamNo,@LicenseExpiry)");
}
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Id", Id, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@Code", Code, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@Name", Name, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@Tel", Tel, SqlDbType.NVarChar, 30));
list.Add(new ConnectSql_mb.cmdParameters("@ICNo", ICNo, SqlDbType.NVarChar, 50));
list.Add(new ConnectSql_mb.cmdParameters("@Remark", Remark, SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@Isstaff", Isstaff, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@TowheaderCode", TowheaderCode, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ServiceLevel", ServiceLevel, SqlDbType.NVarChar, 30));
list.Add(new ConnectSql_mb.cmdParameters("@StatusCode", StatusCode, SqlDbType.NVarChar, 30));
list.Add(new ConnectSql_mb.cmdParameters("@TeamNo", TeamNo, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@LicenseExpiry", LicenseExpiry, SqlDbType.NVarChar, 8));
if (ConnectSql_mb.ExecuteNonQuery(sql, list).context.Equals("1"))
{
status = "1";
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.ActionLevel = "Driver";
lg.ActionId = Id;
lg.Remark = "Driver Save";
lg.log();
}
Common.WriteJsonP(status, context);
}
public void Performance_EditSave(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
JArray jar = (JArray)JsonConvert.DeserializeObject(job["selectedList"].ToString());
string fromName = job["user"].ToString();
string toName = job["Name"].ToString();
string sql = "";
List <ConnectSql_mb.cmdParameters> list = null;
DataTable dt = null;
for (int i = 0; i < jar.Count; i++)
{
int itemId = SafeValue.SafeInt(jar[i]["Id"], 0);
int valueIndex = SafeValue.SafeInt(jar[i]["value"], 0);
if (valueIndex > 0 && valueIndex <= 5)
{
sql = string.Format(@"select type_id,cate_id,Id as item_id,0 as case_id,pts_value1,pts_value2,pts_value3,pts_value4,pts_value5 from pts_item where Id=@Id");
list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Id", itemId, SqlDbType.Int));
dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
int type_id = SafeValue.SafeInt(dt.Rows[0]["type_id"], 0);
int cate_id = SafeValue.SafeInt(dt.Rows[0]["cate_id"], 0);
int item_id = itemId;
int case_id = SafeValue.SafeInt(dt.Rows[0]["case_id"], 0);
decimal pts_value = SafeValue.SafeDecimal(dt.Rows[0]["pts_value" + valueIndex]);
sql = string.Format(@"insert into pts_record (type_id,cate_id,item_id,case_id,pts_index,pts_value,review_time,review_user,pts_user)
values (@type_id,@cate_id,@item_id,@case_id,@pts_index,@pts_value,getdate(),@review_user,@pts_user)
select @@Identity");
list.Add(new ConnectSql_mb.cmdParameters("@type_id", type_id, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@cate_id", cate_id, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@item_id", item_id, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@case_id", case_id, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@pts_index", valueIndex, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@pts_value", pts_value, SqlDbType.Decimal));
list.Add(new ConnectSql_mb.cmdParameters("@review_user", fromName, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@pts_user", toName, SqlDbType.NVarChar, 100));
ConnectSql_mb.sqlResult res = ConnectSql_mb.ExecuteScalar(sql, list);
if (res.status)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.setActionLevel(SafeValue.SafeInt(res.context, 0), CtmJobEventLogRemark.Level.Performance, 1);
lg.log();
}
}
}
}
Common.WriteJsonP(true, Common.StringToJson(""));
}
public void EGL_Reporting_Attachment_Add(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
ConnectSql_mb.cmdParameters cpar = null;
string status = "0";
string context = Common.StringToJson("");
string sql = string.Format(@"insert into Vehicle_Reporting_Attachment (JobType,RefNo,ContainerNo,TripId,FileType,FileName,FilePath,CreateBy,CreateDateTime,FileNote) values(@JobType,@RefNo,@ContainerNo,@TripId,@FileType,@FileName,@FilePath,@CreateBy,Getdate(),@FileNote)
select @@Identity");
string fileStart = System.Configuration.ConfigurationManager.AppSettings["MobileServerUrl"].ToString();
if (fileStart == null)
{
fileStart = "";
}
string fileEnd = job["FilePath"].ToString();
fileEnd = fileEnd.Substring(0, fileEnd.LastIndexOf('/')) + "/500/" + fileEnd.Substring(fileEnd.LastIndexOf('/') + 1);
fileEnd = fileStart + fileEnd;
cpar = new ConnectSql_mb.cmdParameters("@JobType", job["ContainerNo"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@RefNo", job["JobNo"], SqlDbType.NVarChar, 100);
list.Add(cpar);
//cpar = new ConnectSql_mb.cmdParameters("@ContainerNo", job["ContainerNo"], SqlDbType.NVarChar, 100);
//list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@TripId", job["TripId"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FileType", job["FileType"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FileName", job["FileName"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FilePath", fileEnd, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@CreateBy", job["CreateBy"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FileNote", job["FileNote"], SqlDbType.NVarChar, 100);
list.Add(cpar);
ConnectSql_mb.sqlResult result = ConnectSql_mb.ExecuteScalar(sql, list);
if (result.status)
{
status = "1";
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.setActionLevel(SafeValue.SafeInt(result.context, 0), CtmJobEventLogRemark.Level.Attachment, 1, ":" + job["FileType"] + "[" + job["FileName"] + "]");
lg.log();
}
Common.WriteJsonP(status, context);
}
public void FSL_Container_ReadyReturn(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
int contId = SafeValue.SafeInt(job["contId"], 0);
string Time = SafeValue.SafeString(job["Time"]);
string Location = SafeValue.SafeString(job["Location"]);
string user = SafeValue.SafeString(job["user"]);
C2.CtmJobDet1Biz det1Bz = new C2.CtmJobDet1Biz(contId);
C2.CtmJobDet1 det1 = det1Bz.getData();
bool status = false;
string context = Common.StringToJson("");
if (det1 != null)
{
try
{
det1.WhsReadyInd = "Y";
det1.WhsReadyTime = Time;
det1.WhsReadyLocation = Location;
C2.Manager.ORManager.StartTracking(det1, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(det1);
status = true;
#region lot alert
string sql = string.Format(@"select ClientId,EmailAddress
from CTM_JobDet1 as det1
left outer join CTM_Job as job on det1.JobNo=job.JobNo
where det1.Id=@contId");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@contId", contId, SqlDbType.Int));
string client = "";
string EmailAddress = "";
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
client = SafeValue.SafeString(dt.Rows[0]["ClientId"]);
EmailAddress = SafeValue.SafeString(dt.Rows[0]["EmailAddress"]);
}
C2.CtmJobEventLog log = new C2.CtmJobEventLog();
log.Platform_isMobile();
log.Controller = user;
log.ActionLevel_isCONT(contId);
log.isAlert(client);
log.setRemark(CtmJobEventLogRemark.Level.Container, -1, user + " set ready to return [" + Time + "]");
log.log();
#endregion
C2.Email.SendEmail(EmailAddress, "[email protected],[email protected]", "", "TSL Customer Alert", "Dear Customer:Container:[" + det1.ContainerNo + "] is ready to return.", "");
context = "{\"Client\":\"" + client + "\",\"text\":\"" + det1.ContainerNo + " ready to return\"}";
}
catch { }
}
Common.WriteJsonP(status, context);
}
public void ContainerTrip_Detail_Delete(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
int status = 0;
string deleteType = job["deleteType"].ToString();
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Id", SafeValue.SafeInt(job["Id"], 0), SqlDbType.Int));
string sql = string.Format(@"select StatusCode from CTM_JobDet2 where Id=@Id");
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["StatusCode"].ToString() == "S")
{
status = 2;
if (deleteType == "S")
{
status = 0;
}
}
if (status <= 0)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isTRIP(SafeValue.SafeInt(job["Id"], 0));
//lg.Remark = "Trip Delete";
lg.setActionLevel(SafeValue.SafeInt(job["Id"], 0), CtmJobEventLogRemark.Level.Trip, 2);
lg.log();
sql = string.Format(@"delete from CTM_JobDet2 where Id=@Id");
ConnectSql_mb.sqlResult result = ConnectSql_mb.ExecuteNonQuery(sql, list);
if (result.status)
{
status = 1;
}
}
}
Common.WriteJsonP(status, Common.StringToJson(job["Id"].ToString()));
}
public void Cost_AddNew(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
bool status = false;
string code = job["code"].ToString();
string des = job["name"].ToString();
decimal value = SafeValue.SafeDecimal(job["value"], 0);
int TripNo = SafeValue.SafeInt(job["TripNo"], 0);
string LineType = job["LineType"].ToString();
string sql = string.Format(@"select det2.Id,job.JobNo,job.JobType,det1.ContainerNo,det1.ContainerType
from ctm_jobdet2 as det2
left outer join CTM_JobDet1 as det1 on det2.Det1Id=det1.Id
left outer join CTM_Job as job on det2.JobNo=job.JobNo
where det2.Id=@TripNo");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@TripNo", TripNo, SqlDbType.Int));
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
sql = string.Format(@"insert into job_cost (LineId,LineType,JobNo,JobType,ContNo,ContType,TripNo,VendorId,ChgCode,ChgCodeDes,Remark,Qty,Price,CurrencyId,ExRate,DocAmt,LocAmt,CompanyId)
values((select count(*) from job_cost where JobNo=@JobNo),@LineType,@JobNo,@JobType,@ContNo,@ContType,@TripNo,'',@ChgCode,@ChgCodeDes,'',1,@Price,'SGD',1,0,0,0)
select @@Identity");
list.Add(new ConnectSql_mb.cmdParameters("@JobNo", dt.Rows[0]["JobNo"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@LineType", LineType, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@JobType", dt.Rows[0]["JobType"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ContNo", dt.Rows[0]["ContainerNo"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ContType", dt.Rows[0]["ContainerType"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ChgCode", code, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ChgCodeDes", des, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@Price", value, SqlDbType.Decimal));
ConnectSql_mb.sqlResult res = ConnectSql_mb.ExecuteScalar(sql, list);
if (res.status)
{
status = true;
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.setActionLevel(SafeValue.SafeInt(res.context, 0), CtmJobEventLogRemark.Level.Invoice, 5);
lg.log();
}
Common.WriteJsonP(status, Common.StringToJson(""));
}
public void EGL_DriverCash_SaveDetail(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
string status = "0";
string context = Common.StringToJson("");
int Id = SafeValue.SafeInt(job["Id"], 0);
string DriverCode = job["DriverCode"].ToString();
string EventDate = job["EventDate"].ToString();
string EventType = job["EventType"].ToString();
decimal TotalAmount = SafeValue.SafeDecimal(job["TotalAmount"].ToString(), 0);
string Description = job["Description"].ToString();
string sql = "";
sql = string.Format(@"update Ref_DriverCash set DriverCode=@DriverCode,EventDate=@EventDate,EventType=@EventType,TotalAmount=@TotalAmount,Description=@Description where Id=@Id");
if (Id == 0)
{
sql = string.Format(@"insert into Ref_DriverCash (DriverCode,EventDate,EventType,TotalAmount,Description) values(@DriverCode,@EventDate,@EventType,@TotalAmount,@Description)");
}
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Id", Id, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@DriverCode", DriverCode, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@EventDate", EventDate, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@EventType", EventType, SqlDbType.NVarChar, 20));
list.Add(new ConnectSql_mb.cmdParameters("@TotalAmount", TotalAmount, SqlDbType.Decimal));
list.Add(new ConnectSql_mb.cmdParameters("@Description", Description, SqlDbType.NVarChar, 300));
if (ConnectSql_mb.ExecuteNonQuery(sql, list).context.Equals("1"))
{
status = "1";
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.ActionLevel = "DriverCash";
lg.ActionId = Id;
lg.Remark = "Driver Cash Save";
lg.log();
}
Common.WriteJsonP(status, context);
}
public void Attendance_EditSave(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
string user = job["user"].ToString();
string action = job["action"].ToString();
string sql = string.Format(@"insert into pts_attendance (createdate,record_type,record_user,record_note)
values(getdate(),@record_type,@record_user,@record_note)
select @@Identity");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@record_type", action, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@record_user", user, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@record_note", "", SqlDbType.NVarChar, 300));
ConnectSql_mb.sqlResult result = ConnectSql_mb.ExecuteScalar(sql, list);
if (result.status && action.ToLower().IndexOf("in") >= 0)
{
sql = string.Format(@"insert into pts_record (type_id,cate_id,item_id,case_id,pts_index,pts_value,review_time,review_user,pts_user)
values (@type_id,@cate_id,@item_id,@case_id,@pts_index,@pts_value,getdate(),@review_user,@pts_user)");
list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@type_id", 0, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@cate_id", 0, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@item_id", 0, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@case_id", 0, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@pts_index", 0, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@pts_value", 10, SqlDbType.Decimal));
list.Add(new ConnectSql_mb.cmdParameters("@review_user", user, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@pts_user", user, SqlDbType.NVarChar, 100));
ConnectSql_mb.ExecuteNonQuery(sql, list);
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.setActionLevel(SafeValue.SafeInt(result.context, 0), CtmJobEventLogRemark.Level.Attendance, 1);
lg.log();
}
Common.WriteJsonP(true, Common.StringToJson(""));
}
public void UserLogin_Login_auto(string info)
{
string info_ = HttpUtility.UrlDecode(Server.UrlDecode(info));
JObject jo = (JObject)JsonConvert.DeserializeObject(info_);
bool status = false;
string context = Common.StringToJson("");
string account = jo["account"].ToString();
string pw = jo["password"].ToString();
if (account == null || account.Length <= 0)
{
context = Common.StringToJson("Request Account");
}
else
{
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
ConnectSql_mb.cmdParameters cpar = null;
string sql = string.Format(@"select top 1 * from [user] where IsActive=1 and Tel=@Tel and Pwd=@Pwd and Role='Client'");
cpar = new ConnectSql_mb.cmdParameters("@Tel", account, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Pwd", pw, SqlDbType.NVarChar, 100);
list.Add(cpar);
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
status = true;
context = Common.DataRowToJson(dt);
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = dt.Rows[0]["Name"].ToString();
lg.Remark = dt.Rows[0]["Name"] + " Login";
lg.ActionLevel = "USER";
lg.ActionType = "Login";
lg.log();
}
else
{
context = Common.StringToJson("Password error");
}
}
Common.WriteJsonP(status, context);
}
public void Review_Detail_Save(string info)
{
string info_ = HttpUtility.UrlDecode(Server.UrlDecode(info));
JObject job = (JObject)JsonConvert.DeserializeObject(info_);
bool status = false;
string context = Common.StringToJson("");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Oid", SafeValue.SafeInt(job["Oid"], 0), SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@Qty", SafeValue.SafeInt(job["Qty"], 0), SqlDbType.Decimal));
list.Add(new ConnectSql_mb.cmdParameters("@Weight", SafeValue.SafeDecimal(job["Weight"]), SqlDbType.Decimal));
list.Add(new ConnectSql_mb.cmdParameters("@M3", SafeValue.SafeDecimal(job["M3"]), SqlDbType.Decimal));
list.Add(new ConnectSql_mb.cmdParameters("@PackType", job["PackType"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@Markings", job["Markings"], SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@Contents", job["Contents"], SqlDbType.NVarChar, 300));
//string sql = string.Format(@"update job_receipt set Qty=@Qty,Weight=@Weight,M3=@M3,PackType=@PackType,Markings=@Markings,Contents=@Contents where row_id=@Oid");
string sql = string.Format(@"update job_house set QtyOrig=@Qty,WeightOrig=@Weight,VolumeOrig=@M3,PackTypeOrig=@PackType,Marking1=@Markings,Remark1=@Contents where Id=@Oid");
ConnectSql_mb.sqlResult result = ConnectSql_mb.ExecuteNonQuery(sql, list);
if (result.status)
{
status = true;
context = Common.StringToJson(result.context);
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isCARGO(SafeValue.SafeInt(job["Oid"], 0));
//lg.Remark = "Cargo update";
lg.setActionLevel(SafeValue.SafeInt(job["Oid"], 0), CtmJobEventLogRemark.Level.Cargo, 3);
lg.log();
}
Common.WriteJsonP(status, context);
}
public void Attendance_addSave(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
string user = SafeValue.SafeString(job["user"]);
string role = SafeValue.SafeString(job["role"]);
string type = SafeValue.SafeString(job["type"]);
string lat = SafeValue.SafeString(job["lat"]);
string lng = SafeValue.SafeString(job["lng"]);
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = user;
lg.Lat = lat;
lg.Lng = lng;
lg.Note1Type = "Attendance";
lg.Note1 = type;
lg.log();
Common.WriteJsonP(true, Common.StringToJson(""));
}
public void ContainerTrips_Save(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
string context = Common.StringToJson("");
string sql = string.Format(@"update ctm_jobdet1 set ContainerNo=@ContainerNo,SealNo=@SealNo where Id=@contId");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@contId", SafeValue.SafeInt(job["Id"], 0), SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@ContainerNo", job["ContainerNo"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@SealNo", job["SealNo"], SqlDbType.NVarChar, 100));
ConnectSql_mb.ExecuteNonQuery(sql, list);
sql = string.Format(@"update ctm_job set PickupFrom=@PickupFrom,DeliveryTo=@DeliveryTo,YardRef=@YardRef,
SpecialInstruction=@SpecialInstruction,Remark=@Remark,PermitNo=@PermitNo where JobNo=@JobNo");
list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@JobNo", job["JobNo"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@PickupFrom", job["PickupFrom"], SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@DeliveryTo", job["DeliveryTo"], SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@YardRef", job["YardRef"], SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@SpecialInstruction", job["SpecialInstruction"], SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@Remark", job["Remark"], SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@PermitNo", job["PermitNo"], SqlDbType.NVarChar, 100));
bool status = ConnectSql_mb.ExecuteNonQuery(sql, list).status;
if (status)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.ActionLevel_isCONT(SafeValue.SafeInt(job["Id"], 0));
lg.Remark = "Container Update";
lg.log();
}
Common.WriteJsonP(status, context);
}
public void ContainerTrips_AddNewTrip(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
int contId = SafeValue.SafeInt(job["contId"], 0);
string type = SafeValue.SafeString(job["type"], "SHF");
string temp = Trip_AddNew(contId, type);
if (temp.Equals(""))
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isCONT(contId);
//lg.Remark = "Add Trip";
lg.setActionLevel(contId, CtmJobEventLogRemark.Level.Trip, 1);
lg.log();
}
Common.WriteJsonP(temp.Equals(""), Common.StringToJson(temp));
}
public void UserLogin_Login(string info)
{
JObject jo = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
bool status = false;
string context = Common.StringToJson("");
string account = jo["account"].ToString();
string pw = jo["password"].ToString();
if (account == null || account.Length <= 0)
{
context = Common.StringToJson("Request Account");
}
else
{
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
//ConnectSql_mb.cmdParameters cpar = null;
string sql = string.Format(@"select PartyId as Name,LoginCode as Pwd,'Client' as Role
from xxparty
where LoginInd='YES' and PartyId=@Tel");
list.Add(new ConnectSql_mb.cmdParameters("@Tel", account, SqlDbType.NVarChar, 100));
//list.Add(new ConnectSql_mb.cmdParameters("@PW", pw, SqlDbType.NVarChar, 100));
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (pw.Equals(dt.Rows[i]["Pwd"].ToString()))
{
sql = string.Format(@"select top 1 PartyId as Name,LoginCode as Pwd,'Client' as Role
from xxparty
where LoginInd='YES' and PartyId=@Tel and LoginCode=@PW");
list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Tel", account, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@PW", pw, SqlDbType.NVarChar, 100));
DataTable dt1 = ConnectSql_mb.GetDataTable(sql, list);
status = true;
context = Common.DataRowToJson(dt1);
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = dt.Rows[i]["Name"].ToString();
lg.Remark = dt.Rows[i]["Name"] + " Login";
lg.ActionLevel = "Client";
lg.log();
break;
}
}
if (!status)
{
context = Common.StringToJson("Password error");
}
}
else
{
sql = string.Format(@"select PartyId as Name,LoginCode as Pwd,'Client' as Role
from xxparty
where PartyId=@Tel");
dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
context = Common.StringToJson("Expire Account");
}
else
{
context = Common.StringToJson("Account is not Exist");
}
}
}
Common.WriteJsonP(status, context);
}
public void Attachment_AddMutiple(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
JArray jar = (JArray)JsonConvert.DeserializeObject(job["list"].ToString());
List <ConnectSql_mb.cmdParameters> list = null;
ConnectSql_mb.cmdParameters cpar = null;
string status = "1";
string context = Common.StringToJson("");
string sql = string.Format(@"insert into CTM_Attachment(RefNo,ContainerNo,FileName,FilePath,FileType,CreateDateTime,JobNo,JobType,FileNote,TripId)
values (@OrderNo,@ContNo,@FileName,@FilePath,@FileType,Getdate(),@CargoId,@OrderType,@FileNote,@TripId)
select @@Identity");
string fileStart = null;
try
{
fileStart = System.Configuration.ConfigurationManager.AppSettings["MobileServerUrl"].ToString();
}
catch { }
if (fileStart == null)
{
fileStart = "";
}
string CreateBy = job["user"].ToString();
string JobNo = job["JobNo"].ToString();
string ContainerNo = job["ContainerNo"].ToString();
string TripId = job["TripId"].ToString();
string CargoId = SafeValue.SafeString(job["CargoId"]);
string JobType = "CTM";
string FileNote = "";
bool ShowCust = true;
for (int i = 0; i < jar.Count; i++)
{
string fileEnd = jar[i]["FP"].ToString();
fileEnd = fileEnd.Substring(0, fileEnd.LastIndexOf('/')) + "/" + fileEnd.Substring(fileEnd.LastIndexOf('/') + 1);
fileEnd = fileStart + fileEnd;
string FileType = jar[i]["FT"].ToString();
string FileName = jar[i]["FN"].ToString();
list = new List <ConnectSql_mb.cmdParameters>();
cpar = new ConnectSql_mb.cmdParameters("@OrderNo", JobNo, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ContNo", ContainerNo, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@CargoId", CargoId, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@TripId", TripId, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FileType", FileType, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@OrderType", JobType, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FileName", FileName, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FilePath", fileEnd, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@CreateBy", CreateBy, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FileNote", FileNote, SqlDbType.NVarChar, 300);
list.Add(cpar);
list.Add(new ConnectSql_mb.cmdParameters("@ShowCust", ShowCust, SqlDbType.Bit));
ConnectSql_mb.sqlResult res = ConnectSql_mb.ExecuteScalar(sql, list);
if (res.status)
{
//status = "1";
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = CreateBy;
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.fixActionInfo_ByAttachmentId(SafeValue.SafeInt(res.context, 0));
//lg.Remark = "Attachment upload file:" + job["FileName"];
lg.setActionLevel(SafeValue.SafeInt(res.context, 0), CtmJobEventLogRemark.Level.Attachment, 1, ":" + FileType + "[" + FileName + "]");
lg.log();
}
else
{
status = "0";
context = (context == "" ? "Save error:" : ",") + FileName;
}
}
context = Common.StringToJson(context);
Common.WriteJsonP(status, context);
}
public void UserLogin_Login(string info)
{
string info_ = HttpUtility.UrlDecode(Server.UrlDecode(info));
JObject jo = (JObject)JsonConvert.DeserializeObject(info_);
bool status = false;
string context = Common.StringToJson("");
string account = jo["account"].ToString();
string pw = jo["password"].ToString();
if (account == null || account.Length <= 0)
{
context = Common.StringToJson("Request Account");
}
else
{
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
ConnectSql_mb.cmdParameters cpar = null;
string sql = string.Format(@"select * from [user] where IsActive=1 and Tel=@Tel and Role='Client'");
cpar = new ConnectSql_mb.cmdParameters("@Tel", account, SqlDbType.NVarChar, 100);
list.Add(cpar);
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
Encryption.EncryptClass encrypt = new Encryption.EncryptClass();
for (int i = 0; i < dt.Rows.Count; i++)
{
string PW_code = SafeValue.SafeString(encrypt.DESEnCode(dt.Rows[i]["Name"].ToString(), pw), "");
if (PW_code.Equals(dt.Rows[i]["Pwd"].ToString()))
{
sql = string.Format(@"select * from [user] where SequenceId=@SequenceId");
list = new List <ConnectSql_mb.cmdParameters>();
cpar = new ConnectSql_mb.cmdParameters("@SequenceId", dt.Rows[i]["SequenceId"], SqlDbType.Int);
list.Add(cpar);
DataTable dt1 = ConnectSql_mb.GetDataTable(sql, list);
status = true;
context = Common.DataRowToJson(dt1);
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = dt.Rows[i]["Name"].ToString();
lg.Remark = dt.Rows[i]["Name"] + " Login";
lg.ActionLevel = "USER";
lg.log();
break;
}
}
if (!status)
{
context = Common.StringToJson("Password error");
}
}
else
{
sql = string.Format(@"select * from [user] where IsActive=0 and Tel=@Tel");
dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
context = Common.StringToJson("Expire Account");
}
else
{
context = Common.StringToJson("Account is not Exist");
}
}
}
Common.WriteJsonP(status, context);
}
public void Crane_ChangeStatus(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
ConnectSql_mb.cmdParameters cpar = null;
string status = "1";
string context = Common.StringToJson("");
string sql1 = "";
string sql = "";
string Statuscode = job["Statuscode"].ToString();
string ByUser = job["ByUser"].ToString();
if (Statuscode.Equals("S"))
{
sql = string.Format(@"select DoubleMounting,DriverCode from CTM_JobDet2 where Id=@Id");
list = new List <ConnectSql_mb.cmdParameters>();
cpar = new ConnectSql_mb.cmdParameters("@Id", job["Id"], SqlDbType.Int);
list.Add(cpar);
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
string dbMounting = "";
string DriverCode = "";
if (dt.Rows.Count > 0)
{
dbMounting = SafeValue.SafeString(dt.Rows[0]["DoubleMounting"], "");
DriverCode = SafeValue.SafeString(dt.Rows[0]["DriverCode"], "");
}
sql = string.Format(@"select Id,DoubleMounting
from ctm_jobdet2
where Statuscode='S' and DriverCode=@DriverCode");
list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@DriverCode", DriverCode, SqlDbType.NVarChar, 100));
dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
status = "0";
context = Common.StringToJson("Please end the other trip, then start this!");
}
}
//if (Statuscode.Equals("C"))
//{
// sql = string.Format(@"select isnull(sum(isnull(Qty,1)*isnull(Price,0)),0) as s from job_cost where TripNo=@Id and LineType='DP'");
// list = new List<ConnectSql_mb.cmdParameters>();
// cpar = new ConnectSql_mb.cmdParameters("@Id", job["Id"], SqlDbType.Int);
// list.Add(cpar);
// if (SafeValue.SafeDecimal(ConnectSql_mb.ExecuteScalar(sql, list).context, 0) == 0)
// {
// status = "0";
// context = Common.StringToJson("Require Trip Incentive!");
// }
//}
if (status.Equals("1"))
{
if (Statuscode.Equals("S"))
{
sql1 = ",FromDate=@FromDate,FromTime=@FromTime";
}
//if (Statuscode.Equals("C"))
//{
// sql1 = ",ToDate=@ToDate,ToTime=@ToTime";
//}
if (Statuscode.Equals("C"))
{
sql1 = ",ToDate=@ToDate,ToTime=@ToTime,FromDate=BookingDate,FromTime=BookingTime";
}
DateTime dtime = DateTime.Now;
string time = dtime.ToString("HH:mm");
sql = string.Format(@"update CTM_JobDet2 set Statuscode=@Statuscode{0} where Id=@Id", sql1);
list = new List <ConnectSql_mb.cmdParameters>();
cpar = new ConnectSql_mb.cmdParameters("@Id", job["Id"], SqlDbType.Int);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Statuscode", Statuscode, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FromDate", dtime, SqlDbType.DateTime);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@FromTime", time, SqlDbType.NVarChar, 10);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ToDate", dtime, SqlDbType.DateTime);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ToTime", time, SqlDbType.NVarChar, 10);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ByUser", ByUser, SqlDbType.NVarChar, 20);
list.Add(cpar);
if (ConnectSql_mb.ExecuteNonQuery(sql, list).status)
{
status = "1";
//EGL_JobTrip_AfterEndTrip(SafeValue.SafeString(job["Id"], "0"));
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isTRIP(SafeValue.SafeInt(job["Id"], 0));
//lg.Remark = "Trip change status:" + Statuscode;
lg.setActionLevel(SafeValue.SafeInt(job["Id"], 0), CtmJobEventLogRemark.Level.Trip, 4, ":" + Statuscode);
lg.log();
}
else
{
status = "0";
}
}
Common.WriteJsonP(status, context);
}
public void Vehcile_FuelLog_Save(string info)
{
string info_ = HttpUtility.UrlDecode(Server.UrlDecode(info));
JObject job = (JObject)JsonConvert.DeserializeObject(info_);
List <ConnectSql_mb.cmdParameters> list = null;
ConnectSql_mb.cmdParameters cpar = null;
string status = "1";
string context = Common.StringToJson("");
string sql = "";
list = new List <ConnectSql_mb.cmdParameters>();
cpar = new ConnectSql_mb.cmdParameters("@Id", job["Id"], SqlDbType.Int);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@VehicleNo", job["VehicleNo"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Type", job["Type"], SqlDbType.NVarChar, 10);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Volume", job["Volume"], SqlDbType.Decimal);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Amount", job["Amount"], SqlDbType.Decimal);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Note", job["Note"], SqlDbType.NVarChar, 300);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@CreateBy", job["user"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ReportDate", job["ReportDate"], SqlDbType.DateTime);
list.Add(cpar);
ConnectSql_mb.sqlResult re = null;
if (job["Id"].ToString().Equals("") || job["Id"].ToString().Equals("0"))
{
sql = string.Format(@"insert into Vehicle_FuelLog (VehicleNo,CreateDateTime,[Type],Volume,Amount,Note,CreateBy,ReportDate) values(@VehicleNo,getdate(),@Type,@Volume,@Amount,@Note,@CreateBy,@ReportDate)
select @@Identity");
re = ConnectSql_mb.ExecuteScalar(sql, list);
if (re.status)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.setActionLevel(SafeValue.SafeInt(re.context, 0), CtmJobEventLogRemark.Level.VehcileReport, 1);
lg.log();
}
}
else
{
sql = string.Format(@"update Vehicle_FuelLog set VehicleNo=@VehicleNo,[Type]=@Type,Volume=@Volume,Amount=@Amount,Note=@Note,ReportDate=@ReportDate where Id=@Id");
re = ConnectSql_mb.ExecuteNonQuery(sql, list);
if (re.status)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.setActionLevel(SafeValue.SafeInt(job["Id"], 0), CtmJobEventLogRemark.Level.VehcileReport, 3);
lg.log();
}
}
if (!re.status || re.context.Equals("0"))
{
status = "0";
context = Common.StringToJson("Save Error");
}
Common.WriteJsonP(status, context);
}
public void Crane_JobEdit_Save(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
ConnectSql_mb.cmdParameters cpar = null;
string status = "0";
string context = Common.StringToJson("");
string ByUser = job["ByUser"].ToString();
decimal OtHourType = SafeValue.SafeDecimal(job["OverTime"]);
string sql = string.Format(@"update CTM_JobDet2 set TowheadCode=@TowheadCode,Remark1=@Remark1,ToCode=@ToCode,DriverCode=@DriverCode,UpdateUser=@ByUser,UpdateTime=GetDate(),OtHour=@OtHour
where Id=@Id");
#region params
cpar = new ConnectSql_mb.cmdParameters("@Id", job["Id"], SqlDbType.Int);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Remark1", job["Remark1"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@TowheadCode", job["TowheadCode"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@DriverCode", job["DriverCode"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ToCode", job["ToCode"], SqlDbType.NVarChar, 300);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ByUser", ByUser, SqlDbType.NVarChar, 20);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@OtHour", SafeValue.SafeDecimal(job["OtHour"]), SqlDbType.Decimal);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@OtHourType", OtHourType, SqlDbType.Decimal);
list.Add(cpar);
#endregion
if (ConnectSql_mb.ExecuteNonQuery(sql, list).status)
{
status = "1";
Dictionary <string, decimal> d = new Dictionary <string, decimal>();
//d.Add("Trip", SafeValue.SafeDecimal(job["Trip"], 0));
d.Add("OverTime", SafeValue.SafeDecimal(job["OverTime"], 0));
//d.Add("Standby", SafeValue.SafeDecimal(job["Standby"], 0));
//d.Add("PSA", SafeValue.SafeDecimal(job["PSA"], 0));
//d.Add("OverTime", (OtHourType.Length > 0 ? 1 : 0));
C2.CtmJobDet2.Incentive_Save(SafeValue.SafeInt(job["Id"], 0), d);
d = new Dictionary <string, decimal>();
d.Add("EXPENSE", SafeValue.SafeDecimal(job["EXPENSE"], 0));
//d.Add("DHC", SafeValue.SafeDecimal(job["DHC"], 0));
//d.Add("WEIGHING", SafeValue.SafeDecimal(job["WEIGHING"], 0));
//d.Add("WASHING", SafeValue.SafeDecimal(job["WASHING"], 0));
//d.Add("REPAIR", SafeValue.SafeDecimal(job["REPAIR"], 0));
//d.Add("DETENTION", SafeValue.SafeDecimal(job["DETENTION"], 0));
//d.Add("DEMURRAGE", SafeValue.SafeDecimal(job["DEMURRAGE"], 0));
//d.Add("LIFT_ON_OFF", SafeValue.SafeDecimal(job["LIFT_ON_OFF"], 0));
//d.Add("C_SHIPMENT", SafeValue.SafeDecimal(job["C_SHIPMENT"], 0));
//d.Add("EMF", SafeValue.SafeDecimal(job["EMF"], 0));
//d.Add("OTHER", SafeValue.SafeDecimal(job["OTHER"], 0));
C2.CtmJobDet2.Claims_Save(SafeValue.SafeInt(job["Id"], 0), d);
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isTRIP(SafeValue.SafeInt(job["Id"], 0));
//lg.Remark = "Trip update";
lg.setActionLevel(SafeValue.SafeInt(job["Id"], 0), CtmJobEventLogRemark.Level.Trip, 3);
lg.log();
}
Common.WriteJsonP(status, context);
}
public void Vehcile_Mileage_Save(string info)
{
string info_ = HttpUtility.UrlDecode(Server.UrlDecode(info));
JObject job = (JObject)JsonConvert.DeserializeObject(info_);
List <ConnectSql_mb.cmdParameters> list = null;
ConnectSql_mb.cmdParameters cpar = null;
string status = "1";
string context = Common.StringToJson("");
string sql_where = " and Id<@Id";
if (job["Id"].ToString().Equals("") || job["Id"].ToString().Equals("0"))
{
sql_where = "";
}
string sql = string.Format(@"select isnull(max(value),0) from Vehicle_Mileage where createby=@CreateBy and VehicleNo=@VehicleNo {0}", sql_where);
list = new List <ConnectSql_mb.cmdParameters>();
cpar = new ConnectSql_mb.cmdParameters("@Id", job["Id"], SqlDbType.Int);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@VehicleNo", job["VehicleNo"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@CreateBy", job["user"], SqlDbType.NVarChar, 100);
list.Add(cpar);
decimal maxValue = SafeValue.SafeDecimal(ConnectSql_mb.ExecuteScalar(sql, list).context);
if (maxValue > SafeValue.SafeDecimal(job["Value"]))
{
status = "0";
context = Common.StringToJson("Mileage must more than " + maxValue);
}
else
{
list = new List <ConnectSql_mb.cmdParameters>();
cpar = new ConnectSql_mb.cmdParameters("@Id", job["Id"], SqlDbType.Int);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@VehicleNo", job["VehicleNo"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Value", job["Value"], SqlDbType.Decimal);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Note", job["Note"], SqlDbType.NVarChar, 300);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@CreateBy", job["user"], SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ReportDate", job["ReportDate"], SqlDbType.NVarChar, 30);
list.Add(cpar);
ConnectSql_mb.sqlResult re = null;
if (job["Id"].ToString().Equals("") || job["Id"].ToString().Equals("0"))
{
sql = string.Format(@"insert into Vehicle_Mileage (VehicleNo,CreateDateTime,Value,Note,CreateBy,ReportDate) values(@VehicleNo,getdate(),@Value,@Note,@CreateBy,@ReportDate)
select @@Identity");
re = ConnectSql_mb.ExecuteScalar(sql, list);
if (re.status)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.setActionLevel(SafeValue.SafeInt(re.context, 0), CtmJobEventLogRemark.Level.VehcileReport, 5);
lg.log();
}
}
else
{
sql = string.Format(@"update Vehicle_Mileage set VehicleNo=@VehicleNo,Value=@Value,Note=@Note,ReportDate=@ReportDate where Id=@Id");
re = ConnectSql_mb.ExecuteNonQuery(sql, list);
if (re.status)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
lg.setActionLevel(SafeValue.SafeInt(job["Id"], 0), CtmJobEventLogRemark.Level.VehcileReport, 7);
lg.log();
}
}
if (!re.status || re.context.Equals("0"))
{
status = "0";
context = Common.StringToJson("Save Error");
}
}
Common.WriteJsonP(status, context);
}
public void Crane_JobView_PODSave(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
int tripId = SafeValue.SafeInt(job["Id"], 0);
string BillingRemark = job["BillingRemark"].ToString();
string DeliveryRemark = job["DeliveryRemark"].ToString();
string Satisfaction = job["Satisfaction"].ToString();
string FromDate = job["FromDate"].ToString();
string FromTime = job["FromTime"].ToString();
string ToDate = job["ToDate"].ToString();
string ToTime = job["ToTime"].ToString();
decimal OtHour = SafeValue.SafeDecimal(job["OtHour"], 0);
int epodTrip = SafeValue.SafeInt(job["epodTrip"], 0);
string epodCB1 = SafeValue.SafeString(job["epodCB1"], "No");
string epodCB2 = SafeValue.SafeString(job["epodCB2"], "No");
string epodCB3 = SafeValue.SafeString(job["epodCB3"], "No");
string epodCB4 = SafeValue.SafeString(job["epodCB4"], "No");
string epodCB5 = SafeValue.SafeString(job["epodCB5"], "No");
string epodCB6 = SafeValue.SafeString(job["epodCB6"], "No");
int ManPowerNo = SafeValue.SafeInt(job["ManPowerNo"], 0);
string ExcludeLunch = SafeValue.SafeString(job["ExcludeLunch"]);
string epodSignedBy = SafeValue.SafeString(job["epodSignedBy"]);
string DeliveryResult = SafeValue.SafeString(job["DeliveryResult"]);
string epodHardCopy = SafeValue.SafeString(job["epodHardCopy"]);
string context = Common.StringToJson("");
string sql = string.Format(@"update CTM_JobDet2 set BillingRemark=@BillingRemark,DeliveryRemark=@DeliveryRemark,Satisfaction=@Satisfaction,PodType='C',
FromDate=@FromDate,FromTime=@FromTime,ToDate=@ToDate,ToTime=@ToTime,OtHour=@OtHour,TotalHour=@epodTrip,epodSignedBy=@epodSignedBy,
epodCB1=@epodCB1,epodCB2=@epodCB2,epodCB3=@epodCB3,epodCB4=@epodCB4,epodCB5=@epodCB5,epodCB6=@epodCB6,ManPowerNo=@ManPowerNo,ExcludeLunch=@ExcludeLunch,DeliveryResult=@DeliveryResult,epodHardCopy=@epodHardCopy
where Id=@tripId");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@tripId", tripId, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@BillingRemark", BillingRemark, SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@DeliveryRemark", DeliveryRemark, SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@Satisfaction", Satisfaction, SqlDbType.NVarChar, 30));
list.Add(new ConnectSql_mb.cmdParameters("@FromDate", FromDate, SqlDbType.NVarChar, 8));
list.Add(new ConnectSql_mb.cmdParameters("@FromTime", FromTime, SqlDbType.NVarChar, 5));
list.Add(new ConnectSql_mb.cmdParameters("@ToDate", ToDate, SqlDbType.NVarChar, 8));
list.Add(new ConnectSql_mb.cmdParameters("@ToTime", ToTime, SqlDbType.NVarChar, 5));
list.Add(new ConnectSql_mb.cmdParameters("@OtHour", OtHour, SqlDbType.Decimal));
list.Add(new ConnectSql_mb.cmdParameters("@epodTrip", epodTrip, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@epodSignedBy", epodSignedBy, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@epodCB1", epodCB1, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@epodCB2", epodCB2, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@epodCB3", epodCB3, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@epodCB4", epodCB4, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@epodCB5", epodCB5, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@epodCB6", epodCB6, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@ManPowerNo", ManPowerNo, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@ExcludeLunch", ExcludeLunch, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@DeliveryResult", DeliveryResult, SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@epodHardCopy", epodHardCopy, SqlDbType.NVarChar, 10));
ConnectSql_mb.sqlResult result = ConnectSql_mb.ExecuteNonQuery(sql, list);
if (result.status)
{
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isTRIP(tripId);
//lg.Remark = "Submit e-POD";
lg.setActionLevel(tripId, CtmJobEventLogRemark.Level.Trip, 5);
lg.log();
if (!ePOD_SendEmail(tripId))
{
context = Common.StringToJson("Submit successful, but send false");
}
}
Common.WriteJsonP(result.status, context);
}
public void Crane_AddNew(string info)
{
JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info)));
string JobNo = job["JobNo"].ToString();
string TowheadCode = job["TowheadCode"].ToString();
string BookingDate = job["BookingDate"].ToString();
string BookingTime = job["BookingTime"].ToString();
string BookingTime2 = job["BookingTime2"].ToString();
string DriverCode = job["DriverCode"].ToString();
string BookingRemark = job["BookingRemark"].ToString();
string ByUser = job["ByUser"].ToString();
string ToCode = "";
string Remark = "";
string sql = string.Format(@"select DeliveryTo,SpecialInstruction from ctm_job where JobNo=@JobNo");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@JobNo", JobNo, SqlDbType.NVarChar, 100));
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count == 1)
{
ToCode = dt.Rows[0]["DeliveryTo"].ToString();
Remark = dt.Rows[0]["SpecialInstruction"].ToString();
}
sql = string.Format(@"insert into CTM_JobDet2 (JobNo,ContainerNo,DriverCode,TowheadCode,ChessisCode,FromCode,FromDate,FromTime,ToCode,ToDate,ToTime,Statuscode,
BayCode,SubletFlag,StageCode,StageStatus,TripCode,Overtime,OverDistance,FromParkingLot,BookingDate,BookingTime,BookingTime2,BookingRemark,
ByUser,CreateUser,UpdateUser,CreateTime,UpdateTime,Remark) values
(@JobNo,'',@DriverCode,@TowheadCode,'',@FromCode,@FromDate,@FromTime,@ToCode,@FromDate,@FromTime,'P',
'','N','','',@TripCode,'Normal','N',@FromParkingLot,@BookingDate,@BookingTime,@BookingTime2,@BookingRemark,
@ByUser,@ByUser,@ByUser,getdate(),getdate(),@Remark)
select @@Identity");
list.Add(new ConnectSql_mb.cmdParameters("@DriverCode", DriverCode, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@TowheadCode", TowheadCode, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@FromCode", "", SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@FromDate", "19000101", SqlDbType.NVarChar, 8));
list.Add(new ConnectSql_mb.cmdParameters("@FromTime", "00:00", SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@BookingDate", BookingDate, SqlDbType.NVarChar, 8));
list.Add(new ConnectSql_mb.cmdParameters("@BookingTime", BookingTime, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@BookingTime2", BookingTime2, SqlDbType.NVarChar, 10));
list.Add(new ConnectSql_mb.cmdParameters("@ToCode", ToCode, SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@TripCode", "CRA", SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@FromParkingLot", "", SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@BookingRemark", BookingRemark, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ByUser", ByUser, SqlDbType.NVarChar, 20));
list.Add(new ConnectSql_mb.cmdParameters("@Remark", Remark, SqlDbType.NVarChar, 300));
ConnectSql_mb.sqlResult result = ConnectSql_mb.ExecuteScalar(sql, list);
if (result.status)
{
//===========log
C2.CtmJobEventLog lg = new C2.CtmJobEventLog();
lg.Platform_isMobile();
lg.Controller = SafeValue.SafeString(job["user"]);
lg.Lat = SafeValue.SafeString(job["Lat"]);
lg.Lng = SafeValue.SafeString(job["Lng"]);
//lg.ActionLevel_isTRIP(SafeValue.SafeInt(result.context, 0));
//lg.Remark = "Trip Add New";
lg.setActionLevel(SafeValue.SafeInt(result.context, 0), CtmJobEventLogRemark.Level.Trip, 1);
lg.log();
}
Common.WriteJsonP(result.status, Common.StringToJson(result.context));
}
