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