public int Insert(ProdVdReq query) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); sql.Append(" Insert into prod_vd_req ( "); sql.Append(" vendor_id,product_id,req_status,req_datatime,`explain`,"); sql.Append("req_type,user_id,reply_datetime,reply_note ) values ( "); sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.vendor_id, query.product_id, query.req_status, CommonFunction.DateTimeToString(query.req_datatime), query.explain); sql.AppendFormat("'{0}','{1}','{2}','{3}' );", query.req_type, query.user_id, CommonFunction.DateTimeToString(query.reply_datetime), query.reply_note); return _dbAccess.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("ProdVdReqDao.Insert-->" + ex.Message + sql.ToString(), ex); } }
public int Update(ProdVdReq query) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); sql.Append("set sql_safe_updates=0;"); sql.Append(" update prod_vd_req set "); sql.AppendFormat(" vendor_id='{0}'", query.vendor_id); sql.AppendFormat(" ,req_status='{0}' ", query.req_status); sql.AppendFormat(" ,req_datatime='{0} ' ", CommonFunction.DateTimeToString(query.req_datatime)); sql.AppendFormat(" ,`explain`='{0}' ", query.explain); sql.AppendFormat(" ,req_type='{0}' ", query.req_type); sql.AppendFormat(" ,reply_note='{0}' ", query.reply_note); sql.AppendFormat(" ,reply_datetime='{0}' ", CommonFunction.DateTimeToString(query.reply_datetime)); sql.AppendFormat(" ,user_id='{0}' ", query.user_id); sql.AppendFormat(" where product_id= '{0}'", query.product_id); sql.AppendFormat(" and rid= '{0}'", query.rid); sql.Append(";set sql_safe_updates=1;"); return _dbAccess.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("ProdVdReqDao.Update-->" + ex.Message + sql.ToString(), ex); } }