/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public List <Model.Db> GetList()
{
string strSql = "";
strSql = "Select * FROM Db";
List <Model.Db> List = new List <Model.Db>();
SqlParameter[] parameters =
{
};
using (SqlDataReader DR = ExamSys.ExecuteReader(strSql.ToString(), parameters))
{
while (DR.Read())
{
Model.Db model = new Model.Db();
model.Server = DR["Server"].ToString();
model.Database = DR["Database"].ToString();
model.Password = DR["Password"].ToString();
model.Instance = DR["Instance"].ToString();
model.Port = DR["Port"].ToString();
model.User = DR["User"].ToString();
model.Key = DR["Key"].ToString();
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Updata(Model.Db model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@ReturnValue", SqlDbType.Int),
new SqlParameter("@Server", SqlDbType.NVarChar, 500),
new SqlParameter("@Database", SqlDbType.NVarChar, 500),
new SqlParameter("@Password", SqlDbType.NVarChar, 500),
new SqlParameter("@Instance", SqlDbType.NVarChar, 500),
new SqlParameter("@Port", SqlDbType.NVarChar, 500),
new SqlParameter("@User", SqlDbType.NVarChar, 500),
new SqlParameter("@Key", SqlDbType.NVarChar, 500),
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.Server;
parameters[2].Value = model.Database;
parameters[3].Value = model.Password;
parameters[4].Value = model.Instance;
parameters[5].Value = model.Port;
parameters[6].Value = model.User;
parameters[7].Value = model.Key;
ExamSys.RunProcedure("Db_Updata", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
/// <summary>
/// 添加
/// </summary>
public void Add(Model.Db md)
{
Model.Db model = new Model.Db();
model.Server = Common.Function.ToASCII(md.Server);
model.Database = Common.Function.ToASCII(md.Database);
model.Password = Common.Function.ToASCII(md.Password);
model.Instance = Common.Function.ToASCII(md.Instance);
model.Port = Common.Function.ToASCII(md.Port);
model.User = Common.Function.ToASCII(md.User);
model.Key = Common.Function.ToASCII(md.Key);
if (dal.Add(model) > 0)
{
if (md.Key == "UserSys")
{
Common.Function.Redirect("Setup3.aspx");
}
else
{
Common.Function.Redirect("Setup4.aspx");
}
}
else
{
Common.Function.AlertRedirect("添加失败！系统繁忙请稍后再试！", "/Aspx/Failure.htm");
}
}
protected void bt_Yes_Click(object sender, EventArgs e)
{
if (rbl_UserSys.SelectedValue == "外部")
{
BLL.Db bll = new BLL.Db();
Model.Db model = new Model.Db();
model.Server = tb_Server_UserSys.Text;
model.Database = tb_Database_UserSys.Text;
model.Password = tb_Password_UserSys.Text;
model.Instance = tb_Instance_UserSys.Text;
model.Port = tb_Port_UserSys.Text;
model.User = tb_User_UserSys.Text;
model.Key = lb_Key_UserSys.Text;
//
Session["UserSys"] = "1";
bll.Add(model);
}
else
{
//
Session["UserSys"] = "0";
Response.Redirect("Setup3.aspx");
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
public void Updata(Model.Db md)
{
Model.Db model = new Model.Db();
model.Server = Common.Function.ToASCII(md.Server);
model.Database = Common.Function.ToASCII(md.Database);
model.Password = Common.Function.ToASCII(md.Password);
model.Instance = Common.Function.ToASCII(md.Instance);
model.Port = Common.Function.ToASCII(md.Port);
model.User = Common.Function.ToASCII(md.User);
model.Key = Common.Function.ToASCII(md.Key);
if (dal.Updata(model) > 0)
{
Common.Function.AlertRedirect("成功！", "/Aspx/Success.htm");
}
else
{
Common.Function.AlertRedirect("失败！", "/Aspx/Failure.htm");
}
}
