/// <summary>
/// 能过名称获取平台名称
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string GetNameById(object id)
{
AdSiteInfoVO info = null;
info = m_list.SingleOrDefault(p => p.Id == int.Parse(id.ToString()));
if (info == null)
{
info = GetSingle(new AdSiteInfoPara()
{
Id = int.Parse(id.ToString())
});
if (info != null)
{
m_list.Add(info);
return(info.Name);
}
}
else
{
return(info.Name);
}
return(id.ToString());
}
public override bool Edit(AdSiteInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@WebSite", Value = ParameterHelper.ConvertValue(m.WebSite)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LastDate", Value = ParameterHelper.ConvertValue(m.LastDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PlatformType", Value = ParameterHelper.ConvertValue(m.PlatformType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Contact", Value = ParameterHelper.ConvertValue(m.Contact)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdSiteInfoVO info = new AdSiteInfoVO();
info.Name = txtName.Value;
info.UserId = Account.UserId;
info.Contact = "";
info.CreateDate = DateTime.Now;
info.Desc = txtDesc.Text;
info.LastDate = DateTime.Now;
info.PlatformType = "";
info.WebSite = txtWebSite.Text;
AdSiteInfoBLL.Instance.Add(info);
Response.Redirect("/Accounts/Sys/SiteList.aspx");
}
public override int InsertIdentityId(AdSiteInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@WebSite", Value = ParameterHelper.ConvertValue(m.WebSite)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LastDate", Value = ParameterHelper.ConvertValue(m.LastDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PlatformType", Value = ParameterHelper.ConvertValue(m.PlatformType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Contact", Value = ParameterHelper.ConvertValue(m.Contact)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override string GetOtherConditionByModel(AdSiteInfoVO m)
{
return("");
}
public override string GetOrderByModel(AdSiteInfoVO m)
{
return("");
}
