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