public int insertDeliverChangeLog(DeliverChangeLog dCL)
{
try
{
return _IDeliverChangeLogDao.insertDeliverChangeLog(dCL);
}
catch (Exception ex)
{
throw new Exception("DeliverChangeLogMgr-->insertDeliverChangeLog-->" + ex.Message, ex);
}
}
public int insertDeliverChangeLog(DeliverChangeLog dCL)
{
StringBuilder sbSql = new StringBuilder();
dCL.Replace4MySQL();
try
{
sbSql.AppendFormat(@"insert into delivery_change_log (deliver_id,dcl_create_user,dcl_create_datetime,dcl_create_muser,dcl_create_type,
dcl_note,dcl_ipfrom,expect_arrive_date,expect_arrive_period) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", dCL.deliver_id,
dCL.dcl_create_user,BLL.gigade.Common.CommonFunction.DateTimeToString( dCL.dcl_create_datetime), dCL.dcl_create_muser, dCL.dcl_create_type,
dCL.dcl_note, dCL.dcl_ipfrom, dCL.expect_arrive_date.ToString("yyyy-MM-dd"), dCL.expect_arrive_period);
return _access.execCommand(sbSql.ToString());
}
catch (Exception ex)
{
throw new Exception("DeliverChangeLogDao-->insertDeliverChangeLog-->" + ex.Message + sbSql.ToString(), ex);
}
}
