protected void Page_Load(object sender, EventArgs e) { B_Admin.CheckIsLogged(); IdentityAnalogue ia = new IdentityAnalogue(); ia.CheckEnableSA(); if (!IsPostBack) { SiteDPBind(); if (string.IsNullOrEmpty(Request.QueryString["ID"]))//添加与浏览 { DataBind(); dbPwdT.Text = function.GeneratePasswd(); } else { dbMod = dbBll.SelReturnModel(Request.QueryString["ID"]); addBtn_Click(null, null); dbNameT.Text = dbMod.DBName; dbUserT.Text = dbMod.DBUser; dbPwdT.Text = dbMod.DBInitPwd; bindUserT.Text = dbMod.UserName; bindUserD.Value = dbMod.UserID.ToString(); bindDomT.Text = dbMod.Remind; bindSiteDP.SelectedValue = dbMod.SiteID.ToString(); saveBtn.Text = "修改"; } } Call.HideBread(Master); }
protected void saveBtn_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { dbMod = dbBll.SelReturnModel(Request.QueryString["ID"]); } dbUserT.Text = dbUserT.Text.Trim(); dbPwdT.Text = dbPwdT.Text.Trim(); dbNameT.Text = dbNameT.Text.Trim(); dbMod.DBName = dbNameT.Text; dbMod.DBUser = dbUserT.Text; dbMod.DBInitPwd = dbPwdT.Text; dbMod.Remind = bindDomT.Text.Trim(); dbMod.Status = 1; if (bindSiteDP.SelectedIndex > 0) { dbMod.SiteID = DataConverter.CLng(bindSiteDP.SelectedValue); dbMod.SiteName = bindSiteDP.SelectedItem.Text; } else { dbMod.SiteID = 0; dbMod.SiteName = "尚未绑定"; } if (!string.IsNullOrEmpty(bindUserD.Value)) { dbMod.UserID = DataConverter.CLng(bindUserD.Value); dbMod.UserName = buser.GetUserByUserID(dbMod.UserID).UserName; } dbMod.CreateTime = DateTime.Now; if (string.IsNullOrEmpty(Request.QueryString["ID"]))//添加 { try { dbHelper.CreateDatabase(dbNameT.Text); dbHelper.CreateDatabaseUser(dbUserT.Text, dbPwdT.Text); dbHelper.CreateUserMap(dbNameT.Text, dbUserT.Text); dbBll.Insert(dbMod); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功');location=location;", true); } catch (Exception ex) { remindSpan.Visible = true; remindSpan.InnerText = "提示:" + ex.Message; } } else { dbBll.UpdateModel(dbMod); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('修改成功');location=location;", true); } }
protected void EGV_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName.ToLower()) { case "del2": //删除记录,同时删除目标数据库 string id = e.CommandArgument.ToString(); dbMod = dbBll.SelReturnModel(id); if (string.IsNullOrEmpty(dbMod.DBName)) { dbBll.DelByID(id); DataBind(); } else if (dbHelper.DelDB(dbMod.DBName)) { dbHelper.DelUserByName(dbMod.DBUser); dbBll.DelByID(id); DataBind(); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('移除失败,请检查数据库权限!!!');", true); } break; } }
//------------Update public bool UpdateModel(M_IDC_DBList model) { return(Sql.UpdateByIDs(TbName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters(model))); }
//-----------------Insert public int Insert(M_IDC_DBList model) { return(Sql.insert(TbName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }