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); }