private bool DoAdd()
{
Model.Forum_GroupExtended model = new Model.Forum_GroupExtended();
BLL.Forum_GroupExtended bll = new BLL.Forum_GroupExtended();
//编写添加操作Begin
//model.GroupId = txtGroupId.Text;
//model.ViewIpField = txtViewIpField.Text;
//model.AttachmentExtension = txtAttachmentExtension.Text;
//model.DayAttachmentSize = txtDayAttachmentSize.Text;
//model.PostIntervalSecond = txtPostIntervalSecond.Text;
//model.Search = txtSearch.Text;
//model.MemberList = txtMemberList.Text;
//model.PostCheck = txtPostCheck.Text;
//model.Cost = txtCost.Text;
//model.CostMax = txtCostMax.Text;
//model.PostUpdateLog = txtPostUpdateLog.Text;
//编写添加操作End
//if (bll.Add(model) > 0)
//{
// AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加dt_Forum_GroupExtended:"
// + model.user_name); //记录日志
// return true;
//}
return(false);
}
private bool DoEdit(int _id)
{
bool result = false;
BLL.Forum_GroupExtended bll = new BLL.Forum_GroupExtended();
Model.Forum_GroupExtended model = bll.GetModel(_id);
//编写编辑操作Begin
model.ViewIpField = Convert.ToInt32(txtViewIpField.Text);
model.AttachmentExtension = txtAttachmentExtension.Text;
model.DayAttachmentSize = Convert.ToInt32(txtDayAttachmentSize.Text);
model.PostIntervalSecond = Convert.ToInt32(txtPostIntervalSecond.Text);
model.Search = Convert.ToInt32(rblSearch.SelectedValue);
model.MemberList = Convert.ToInt32(rblMemberList.SelectedValue);
model.PostCheck = Convert.ToInt32(ddlPostCheck.SelectedValue);
model.Cost = Convert.ToInt32(rblCost.SelectedValue);
model.CostMax = Convert.ToDecimal(txtCostMax.Text);
model.PostUpdateLog = Convert.ToInt32(ddlPostUpdateLog.SelectedValue);
//编写编辑操作End
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改管理员"); //记录日志
result = true;
}
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Forum_GroupExtended model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + databaseprefix + "Forum_GroupExtended set ");
strSql.Append(" GroupId = @GroupId , ");
strSql.Append(" ViewIpField = @ViewIpField , ");
strSql.Append(" AttachmentExtension = @AttachmentExtension , ");
strSql.Append(" DayAttachmentSize = @DayAttachmentSize , ");
strSql.Append(" PostIntervalSecond = @PostIntervalSecond , ");
strSql.Append(" Search = @Search , ");
strSql.Append(" MemberList = @MemberList , ");
strSql.Append(" PostCheck = @PostCheck , ");
strSql.Append(" Cost = @Cost , ");
strSql.Append(" CostMax = @CostMax , ");
strSql.Append(" PostUpdateLog = @PostUpdateLog ");
strSql.Append(" where GroupId=@GroupId ");
SqlParameter[] parameters =
{
new SqlParameter("@GroupId", SqlDbType.Int, 4),
new SqlParameter("@ViewIpField", SqlDbType.Int, 4),
new SqlParameter("@AttachmentExtension", SqlDbType.NVarChar, 64),
new SqlParameter("@DayAttachmentSize", SqlDbType.Int, 4),
new SqlParameter("@PostIntervalSecond", SqlDbType.Int, 4),
new SqlParameter("@Search", SqlDbType.TinyInt, 1),
new SqlParameter("@MemberList", SqlDbType.TinyInt, 1),
new SqlParameter("@PostCheck", SqlDbType.TinyInt, 1),
new SqlParameter("@Cost", SqlDbType.Int, 4),
new SqlParameter("@CostMax", SqlDbType.Money, 8),
new SqlParameter("@PostUpdateLog", SqlDbType.Int, 4)
};
parameters[0].Value = model.GroupId;
parameters[1].Value = model.ViewIpField;
parameters[2].Value = model.AttachmentExtension;
parameters[3].Value = model.DayAttachmentSize;
parameters[4].Value = model.PostIntervalSecond;
parameters[5].Value = model.Search;
parameters[6].Value = model.MemberList;
parameters[7].Value = model.PostCheck;
parameters[8].Value = model.Cost;
parameters[9].Value = model.CostMax;
parameters[10].Value = model.PostUpdateLog;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Forum_GroupExtended DataRowToModel(DataRow row)
{
if (row != null)
{
Model.Forum_GroupExtended model = new Model.Forum_GroupExtended();
if (row["GroupId"].ToString() != "")
{
model.GroupId = int.Parse(row["GroupId"].ToString());
}
if (row["ViewIpField"].ToString() != "")
{
model.ViewIpField = int.Parse(row["ViewIpField"].ToString());
}
model.AttachmentExtension = row["AttachmentExtension"].ToString();
if (row["DayAttachmentSize"].ToString() != "")
{
model.DayAttachmentSize = int.Parse(row["DayAttachmentSize"].ToString());
}
if (row["PostIntervalSecond"].ToString() != "")
{
model.PostIntervalSecond = int.Parse(row["PostIntervalSecond"].ToString());
}
if (row["Search"].ToString() != "")
{
model.Search = int.Parse(row["Search"].ToString());
}
if (row["MemberList"].ToString() != "")
{
model.MemberList = int.Parse(row["MemberList"].ToString());
}
if (row["PostCheck"].ToString() != "")
{
model.PostCheck = int.Parse(row["PostCheck"].ToString());
}
if (row["Cost"].ToString() != "")
{
model.Cost = int.Parse(row["Cost"].ToString());
}
if (row["CostMax"].ToString() != "")
{
model.CostMax = decimal.Parse(row["CostMax"].ToString());
}
if (row["PostUpdateLog"].ToString() != "")
{
model.PostUpdateLog = int.Parse(row["PostUpdateLog"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据,它的副表也增加了一条 dt_Forum_GroupExtended
/// </summary>
public int Add(Model.Forum_Group model)
{
int _id = dal.Add(model);
Model.Forum_GroupExtended modelGroupExtended = new Model.Forum_GroupExtended();
modelGroupExtended.GroupId = _id;
new Forum_GroupExtended().Add(modelGroupExtended);
return(_id);
}
private void ShowInfo(int _id)
{
BLL.Forum_GroupExtended bll = new BLL.Forum_GroupExtended();
Model.Forum_GroupExtended model = bll.GetModel(_id);
//编写赋值操作Begin
txtViewIpField.Text = model.ViewIpField.ToString();
txtAttachmentExtension.Text = model.AttachmentExtension;
txtDayAttachmentSize.Text = model.DayAttachmentSize.ToString();
txtPostIntervalSecond.Text = model.PostIntervalSecond.ToString();
rblSearch.SelectedValue = model.Search.ToString();
rblMemberList.SelectedValue = model.MemberList.ToString();
ddlPostCheck.SelectedValue = model.PostCheck.ToString();
rblCost.SelectedValue = model.Cost.ToString();
txtCostMax.Text = model.CostMax.ToString();
ddlPostUpdateLog.Text = model.PostUpdateLog.ToString();
//编写赋值操作End
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.Forum_GroupExtended model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "Forum_GroupExtended(");
strSql.Append("GroupId,ViewIpField,AttachmentExtension,DayAttachmentSize,PostIntervalSecond,Search,MemberList,PostCheck,Cost,CostMax,PostUpdateLog");
strSql.Append(") values (");
strSql.Append("@GroupId,@ViewIpField,@AttachmentExtension,@DayAttachmentSize,@PostIntervalSecond,@Search,@MemberList,@PostCheck,@Cost,@CostMax,@PostUpdateLog");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@GroupId", SqlDbType.Int, 4),
new SqlParameter("@ViewIpField", SqlDbType.Int, 4),
new SqlParameter("@AttachmentExtension", SqlDbType.NVarChar, 64),
new SqlParameter("@DayAttachmentSize", SqlDbType.Int, 4),
new SqlParameter("@PostIntervalSecond", SqlDbType.Int, 4),
new SqlParameter("@Search", SqlDbType.TinyInt, 1),
new SqlParameter("@MemberList", SqlDbType.TinyInt, 1),
new SqlParameter("@PostCheck", SqlDbType.TinyInt, 1),
new SqlParameter("@Cost", SqlDbType.Int, 4),
new SqlParameter("@CostMax", SqlDbType.Money, 8),
new SqlParameter("@PostUpdateLog", SqlDbType.Int, 4)
};
parameters[0].Value = model.GroupId;
parameters[1].Value = model.ViewIpField;
parameters[2].Value = model.AttachmentExtension;
parameters[3].Value = model.DayAttachmentSize;
parameters[4].Value = model.PostIntervalSecond;
parameters[5].Value = model.Search;
parameters[6].Value = model.MemberList;
parameters[7].Value = model.PostCheck;
parameters[8].Value = model.Cost;
parameters[9].Value = model.CostMax;
parameters[10].Value = model.PostUpdateLog;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Forum_GroupExtended model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.Forum_GroupExtended model)
{
dal.Add(model);
}
