/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Updata(Model.SystemInfo model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@ReturnValue", SqlDbType.Int),
new SqlParameter("@HardInfo", SqlDbType.NVarChar, 500),
new SqlParameter("@UserSys", SqlDbType.NVarChar, 500),
new SqlParameter("@CourseSys", SqlDbType.NVarChar, 500),
new SqlParameter("@sPassword", SqlDbType.NVarChar, 500),
new SqlParameter("@Updata", SqlDbType.NVarChar, 500),
new SqlParameter("@UpdataUserSys", SqlDbType.NVarChar, 500),
new SqlParameter("@UpdataCourseSys", SqlDbType.NVarChar, 500),
new SqlParameter("@UpdataHardInfo", SqlDbType.NVarChar, 500),
new SqlParameter("@SN", SqlDbType.NVarChar, 500),
new SqlParameter("@UpdataSN", SqlDbType.NVarChar, 500),
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.HardInfo;
parameters[2].Value = model.UserSys;
parameters[3].Value = model.CourseSys;
parameters[4].Value = model.sPassword;
parameters[5].Value = model.Updata;
parameters[6].Value = model.UpdataUserSys;
parameters[7].Value = model.UpdataCourseSys;
parameters[8].Value = model.UpdataHardInfo;
parameters[9].Value = model.SN;
parameters[10].Value = model.UpdataSN;
ExamSys.RunProcedure("SystemInfo_Updata", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public List <Model.SystemInfo> GetList()
{
string strSql = "";
strSql = "Select * FROM SystemInfo";
List <Model.SystemInfo> List = new List <Model.SystemInfo>();
SqlParameter[] parameters =
{
};
using (SqlDataReader DR = ExamSys.ExecuteReader(strSql.ToString(), parameters))
{
while (DR.Read())
{
Model.SystemInfo model = new Model.SystemInfo();
model.CourseSys = DR["CourseSys"].ToString();
model.HardInfo = DR["HardInfo"].ToString();
model.SN = DR["SN"].ToString();
model.sPassword = DR["sPassword"].ToString();
model.Updata = DR["Updata"].ToString();
model.UpdataCourseSys = DR["UpdataCourseSys"].ToString();
model.UpdataHardInfo = DR["UpdataHardInfo"].ToString();
model.UpdataSN = DR["UpdataSN"].ToString();
model.UpdataUserSys = DR["UpdataUserSys"].ToString();
model.UserSys = DR["UserSys"].ToString();
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
protected void bt_Yes_Click(object sender, EventArgs e)
{
BLL.SystemInfo bll = new BLL.SystemInfo();
Model.SystemInfo model = new Model.SystemInfo();
string UserSys, CourseSys, SN;
UserSys = Session["UserSys"].ToString();
CourseSys = Session["CourseSys"].ToString();
SN = Session["SN"].ToString();
Session.RemoveAll();
model.HardInfo = "1";
model.UserSys = UserSys;
model.CourseSys = CourseSys;
model.SN = SN;
model.sPassword = tb_Password.Text.Trim();
bll.Add(model);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
public void Updata(Model.SystemInfo md)
{
Model.SystemInfo model = new Model.SystemInfo();
model.CourseSys = Common.Function.ToASCII(md.CourseSys);
model.HardInfo = Common.Function.ToASCII(md.HardInfo);
model.SN = Common.Function.ToASCII(md.SN);
model.sPassword = Common.Function.md5(md.sPassword);
model.Updata = Common.Function.ToASCII(md.Updata);
model.UpdataCourseSys = Common.Function.ToASCII(md.UpdataCourseSys);
model.UpdataHardInfo = Common.Function.ToASCII(md.UpdataHardInfo);
model.UpdataSN = Common.Function.ToASCII(md.UpdataSN);
model.UpdataUserSys = Common.Function.ToASCII(md.UpdataUserSys);
model.UserSys = Common.Function.ToASCII(md.UserSys);
if (dal.Updata(model) > 0)
{
Common.Function.AlertRedirect("成功！", "/Aspx/Success.htm");
}
else
{
Common.Function.AlertRedirect("失败！", "/Aspx/Failure.htm");
}
}
