public int UpSite(SiteModel site)
{
site.Replace4MySQL();
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat(@"update site SET site_name='{0}',domain='{1}',cart_delivery='{2}'", site.site_name, site.domain, site.cart_delivery);
sb.AppendFormat(@",max_user='******',page_location='{1}'", site.max_user, site.page_location);
sb.AppendFormat(",site_updatedate='{0}',update_userid='{1}'", site.site_updatedate.ToString("yyyy-MM-dd HH:mm:ss"), site.update_userid);
sb.AppendFormat(" where site_id='{0}'", site.site_id);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("SiteDao-->UpSite-->" + ex.Message + sb.ToString(), ex);
}
}
public int UpSiteStatus(SiteModel site)
{
site.Replace4MySQL();
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat(@"update site set site_status='{0}',site_updatedate='{1}'", site.site_status, site.site_updatedate.ToString("yyyy-MM-dd HH:mm:ss"));
sb.AppendFormat(@",update_userid='{0}' where site_id='{1}'", site.update_userid, site.site_id);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("SiteDao-->UpSiteStatus-->" + ex.Message + sb.ToString(), ex);
}
}
/// <summary>
/// 添加站臺信息
/// </summary>
/// <param name="site"></param>
/// <returns>int</returns>
public int InsertSite(SiteModel site)
{
site.Replace4MySQL();
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat(@"insert into site(site_name,domain,cart_delivery,online_user");
sb.AppendFormat(@",max_user,page_location,site_status,site_createdate,site_updatedate,");
sb.AppendFormat(@"create_userid,update_userid)VALUES(");
sb.AppendFormat(@"'{0}','{1}','{2}','{3}',", site.site_name, site.domain, site.cart_delivery, site.online_user);
sb.AppendFormat(@"'{0}','{1}','{2}','{3}'", site.max_user, site.page_location, site.site_status, site.site_createdate.ToString("yyyy-MM-dd HH:mm:ss"));
sb.AppendFormat(@",'{0}','{1}','{2}')", site.site_updatedate.ToString("yyyy-MM-dd HH:mm:ss"), site.create_userid, site.update_userid);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("SiteDao-->InsertSite-->" + ex.Message + sb.ToString(), ex);
}
}
