private void feeUpdate(string tariffCode, string tariffDes, string Cont, string Voyage, Decimal amount)
{
string fee_code = "";
switch (tariffCode)
{
case "8928":
fee_code = "Fee23";
break;
case "4546":
fee_code = "Fee21";
break;
case "5314":
fee_code = "Fee31";
break;
case "5311":
fee_code = "Fee31";
break;
case "4361":
fee_code = "Fee32";
break;
case "9502":
fee_code = "Fee33";
break;
}
if (!fee_code.Equals(""))
{
Cont = Cont.Replace(" ", "");
string sql = string.Format(@"select distinct job.JobNo from ctm_job as job
left outer join ctm_jobdet1 as det1 on job.jobno=det1.jobno
where det1.ContainerNo=@ContainerNo and job.Voyage=@Voyage");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@ContainerNo", Cont, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@Voyage", Voyage, SqlDbType.NVarChar, 100));
DataTable dt = ConnectSql_mb.GetDataTable(sql, list);
if (dt.Rows.Count > 0)
{
string jobNo = dt.Rows[0]["JobNo"].ToString();
sql = string.Format(@"update ctm_jobdet1 set {0}=@fee where ContainerNo=@ContainerNo and JobNo=@JobNo", fee_code);
list.Add(new ConnectSql_mb.cmdParameters("@fee", amount, SqlDbType.Decimal));
list.Add(new ConnectSql_mb.cmdParameters("@JobNo", jobNo, SqlDbType.NVarChar, 100));
if (ConnectSql_mb.ExecuteNonQuery(sql, list).status)
{
string user = HttpContext.Current.User.Identity.Name;
C_Job_Detail_EventLog c = new C_Job_Detail_EventLog();
c.Controller = user;
c.Remark = tariffDes + ": " + amount;
c.JobNo = jobNo;
c.ContainerNo = Cont;
c.Job_Detail_EventLog_Add();
}
}
}
}
public void Job_Detail_EventLog_Add()
{
C_Job_Detail_EventLog l = this;
//string sql = string.Format(@"insert into CTM_JobEventLog (CreateDateTime,Controller,JobNo,ContainerNo,Trip,Driver,Towhead,Trail,Remark,Note1,Note2,Note3,Note4,Lat,Lng,Platform,JobType,ParentJobNo,ParentJobType,Note1Type) values(getdate(),'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}')", l.Controller, l.JobNo, l.ContainerNo, l.Trip, l.Driver, l.Towhead, l.Trail, l.Remark, l.Note1, l.Note2, l.Note3, l.Note4, l.Lat, l.Lng, l.Platform, l.JobType, l.ParentJobNo, l.ParentJobType, l.Note1Type);
//ConnectSql_mb.ExecuteNonQuery(sql);
string sql = string.Format(@"insert into CTM_JobEventLog (CreateDateTime,Controller,JobNo,ContainerNo,Trip,Driver,Towhead,Trail,Remark,Note1,Note2,Note3,Note4,Lat,Lng,Platform,JobType,ParentJobNo,ParentJobType,Note1Type) values(getdate(),@Controller,@JobNo,@ContainerNo,@Trip,@Driver,@Towhead,@Trail,@Remark,@Note1,@Note2,@Note3,@Note4,@Lat,@Lng,@Platform,@JobType,@ParentJobNo,@ParentJobType,@Note1Type)");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
ConnectSql_mb.cmdParameters cpar = new ConnectSql_mb.cmdParameters("@Controller", l.Controller, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@JobNo", l.JobNo, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ContainerNo", l.ContainerNo, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Trip", l.Trip, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Driver", l.Driver, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Towhead", l.Towhead, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Trail", l.Trail, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Remark", l.Remark, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Note1", l.Note1, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Note2", l.Note2, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Note3", l.Note3, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Note4", l.Note4, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Lat", l.Lat, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Lng", l.Lng, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Platform", l.Platform, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@JobType", l.JobType, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ParentJobNo", l.ParentJobNo, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@ParentJobType", l.ParentJobType, SqlDbType.NVarChar, 100);
list.Add(cpar);
cpar = new ConnectSql_mb.cmdParameters("@Note1Type", l.Note1Type, SqlDbType.NVarChar, 100);
list.Add(cpar);
ConnectSql_mb.ExecuteNonQuery(sql, list);
}
