public string GetNameById(object id)
{
AdTypeInfoVO info = null;
info = m_list.SingleOrDefault(p => p.Id == int.Parse(id.ToString()));
if (info == null)
{
info = GetSingle(new AdTypeInfoPara()
{
Id = int.Parse(id.ToString())
});
if (info != null)
{
m_list.Add(info);
return(info.Name);
}
}
else
{
return(info.Name);
}
return(id.ToString());
}
public override int InsertIdentityId(AdTypeInfoVO 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 = "@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)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdTypeInfoVO info = new AdTypeInfoVO();
info.Name = txtName.Value;
info.UserId = Account.UserId;
info.CreateDate = DateTime.Now;
info.Desc = txtDesc.Text;
info.LastDate = DateTime.Now;
AdTypeInfoBLL.Instance.Add(info);
Response.Redirect("/Accounts/Sys/AdTypeList.aspx");
}
public override bool Edit(AdTypeInfoVO 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 = "@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 = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override string GetOtherConditionByModel(AdTypeInfoVO m)
{
return("");
}
public override string GetOrderByModel(AdTypeInfoVO m)
{
return("");
}
