/// <summary> /// 修改在线充值配置 /// </summary> /// <param name="config">充值产品</param> /// <returns></returns> public int UpdateOnLineWeChat(OnLineWeChat config) { StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("UPDATE OnLineWeChat SET ") .Append("ConfigName=@ConfigName,") .Append("WeChat=@WeChat,") .Append("NickName=@NickName,") .Append("SortID=@SortID,") .Append("TagID=@TagID,") .Append("Nullity=@Nullity") .Append(" WHERE ConfigID=@ConfigID"); var prams = new List <DbParameter> { Database.MakeInParam("ConfigName", config.ConfigName), Database.MakeInParam("WeChat", config.WeChat), Database.MakeInParam("NickName", config.NickName), Database.MakeInParam("SortID", config.SortID), Database.MakeInParam("TagID", config.TagID), Database.MakeInParam("Nullity", config.Nullity), Database.MakeInParam("ConfigID", config.ConfigID) }; return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery.ToString(), prams.ToArray())); }
/// <summary> /// 数据保存 /// </summary> protected void btnSave_Click(object sender, EventArgs e) { OnLineWeChat config = new OnLineWeChat(); if (IntParam > 0) { if (!AuthUserOperationPermission(Permission.Edit)) { return; } config = FacadeManage.aideTreasureFacade.GetOnLineWeChat(IntParam); } config.ConfigName = CtrlHelper.GetText(txtConfigName); config.WeChat = CtrlHelper.GetText(txtWeChat); config.SortID = CtrlHelper.GetInt(txtSortID, 0); config.NickName = CtrlHelper.GetText(txtNickName); config.Nullity = Convert.ToByte(rblNullity.SelectedValue); config.TagID = Convert.ToByte(ddlTagID.SelectedValue); int result = IntParam > 0 ? FacadeManage.aideTreasureFacade.UpdateOnLineWeChat(config) : FacadeManage.aideTreasureFacade.InsertOnLineWeChat(config); if (result > 0) { ShowInfo("操作成功", "OnLineWeChatList.aspx", 1200); } else { ShowError("操作失败"); } }
/// <summary> /// 数据绑定 /// </summary> private void BindData() { if (IntParam > 0) { OnLineWeChat config = FacadeManage.aideTreasureFacade.GetOnLineWeChat(IntParam); if (config != null) { CtrlHelper.SetText(txtConfigName, config.ConfigName.ToString()); CtrlHelper.SetText(txtSortID, config.SortID.ToString()); CtrlHelper.SetText(txtWeChat, config.WeChat.ToString()); CtrlHelper.SetText(txtNickName, config.NickName.ToString()); ddlTagID.SelectedValue = config.TagID.ToString(); rblNullity.SelectedValue = config.Nullity.ToString(); } } }
/// <summary> /// 新增在线充值配置 /// </summary> /// <param name="config">充值产品</param> /// <returns></returns> public int InsertOnLineWeChat(OnLineWeChat config) { string sqlQuery = @"INSERT INTO OnLineWeChat(ConfigName,WeChat,NickName,SortID,TagID,Nullity,CollectDate) VALUES(@ConfigName,@WeChat,@NickName,@SortID,@TagID,@Nullity,getdate())"; var prams = new List <DbParameter> { Database.MakeInParam("ConfigName", config.ConfigName), Database.MakeInParam("WeChat", config.WeChat), Database.MakeInParam("NickName", config.NickName), Database.MakeInParam("SortID", config.SortID), Database.MakeInParam("TagID", config.TagID), Database.MakeInParam("Nullity", config.Nullity), }; return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery, prams.ToArray())); }
/// <summary> /// 修改在线充值配置 /// </summary> /// <param name="config">充值产品</param> /// <returns></returns> public int UpdateOnLineWeChat(OnLineWeChat config) { return(aideTreasureData.UpdateOnLineWeChat(config)); }
/// <summary> /// 新增在线充值配置 /// </summary> /// <param name="config">充值产品</param> /// <returns></returns> public int InsertOnLineWeChat(OnLineWeChat config) { return(aideTreasureData.InsertOnLineWeChat(config)); }