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