private void MyBind() { if (Mid > 0) { M_DataSource dsMod = dsBll.SelReturnModel(Mid); DSName.Text = dsMod.DSName; DataSource_DP.SelectedValue = dsMod.Type; Remind_T.Text = dsMod.Remind; DBConnectText.Text = dsMod.ConnectionString; } }
/// <summary> /// 用于标签 /// </summary> /// <param name="type">数据源类型或数据源ID</param> public static SqlBase GetDSByType(string type) { B_DataSource dsBll = new B_DataSource(); switch (type) { case "main": case "second": case "new": return(DBCenter.DB); default: M_DataSource dsMod = dsBll.SelReturnModel(Convert.ToInt32(type)); SqlBase db = SqlBase.CreateHelper(dsMod.Type); db.ConnectionString = dsMod.ConnectionString; return(db); } }
protected void Save_Btn_Click(object sender, EventArgs e) { if (Mid > 0) { dsModel = dsBll.SelReturnModel(Mid); } dsModel.DSName = DSName.Text.Trim(); dsModel.ConnectionString = DBConnectText.Text; dsModel.CreateMan = badmin.GetAdminLogin().AdminName; dsModel.CreateTime = DateTime.Now; dsModel.Type = DataSource_DP.SelectedValue; dsModel.Remind = Remind_T.Text.Trim(); if (Mid > 0) { dsBll.UpdateModel(dsModel); } else { dsBll.Insert(dsModel); } function.WriteSuccessMsg("操作成功", "DSList.aspx"); }
/// <summary> /// 更新信息 /// </summary> public bool UpdateModel(M_DataSource model) { return(DBCenter.UpdateByID(model, model.ID)); }
//-------------------Create /// <summary> /// 依据模型,插入一条数据,Parameter形式,返回ID /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(M_DataSource model) { return(DBCenter.Insert(model)); }
/// <summary> /// 更新信息 /// </summary> public bool UpdateModel(M_DataSource model) { return(Sql.UpdateByIDs(strTableName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters())); }
//-------------------Create /// <summary> /// 依据模型,插入一条数据,Parameter形式,返回ID /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(M_DataSource model) { return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }