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