protected void Page_Load(object sender, EventArgs e)
{
DataModel dm = new DataModel();
lo = new LabOrder();
if (Request.Params["week"] == null || Request.Params["week"] == "")
{
dm.ReturnJsonMsg(Response, 0, "未知周次！");
}
if (Request.Params["cls"] == null || Request.Params["cls"] == "")
{
dm.ReturnJsonMsg(Response, 0, "未知节次！");
}
if (Request.Params["wd"] == null || Request.Params["wd"] == "")
{
dm.ReturnJsonMsg(Response, 0, "未知工作日！");
}
if (Request.Params["lab"] == null || Request.Params["lab"] == "")
{
dm.ReturnJsonMsg(Response, 0, "未知实验室！");
}
lo.OrderCls = Convert.ToInt32(Request.Params["cls"]);
lo.OrderWeek = Convert.ToInt32(Request.Params["week"]);
lo.OrderWeekday = Convert.ToInt32(Request.Params["wd"]);
//用户信息
luser = dm.GetUser(Convert.ToInt32(Session["lxyLabUserID"]));
//实验室信息
lab = dm.GetLab(Convert.ToInt32(Request.Params["lab"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["id"] != null && Request.Params["id"].Trim() != "")
{
DataModel dm = new DataModel();
int id = Convert.ToInt32(Request.Params["id"]);
lab = dm.GetLab(id);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["id"] == null || Request.Params["id"].Trim() == "")
{
Response.Write("未指定的ID");
Response.End();
}
else
{
DataModel dm=new DataModel();
int id = Convert.ToInt32(Request.Params["id"].Trim());
lab = dm.GetLab(id);
}
}
public void ProcessRequest(HttpContext context)
{
DataModel dm = new DataModel();
Lab lt = new Lab ();
lt.LabID = Convert.ToInt32(context.Request.Params["LabID"]);
lt.LabAddr = context.Request.Params["LabAddr"];
lt.LabName = context.Request.Params["LabName"];
lt.LabInfo = context.Request.Params["LabInfo"];
lt.LabAmount = Convert.ToInt32( context.Request.Params["LabAmount"]);
lt.LabType = Convert.ToInt32(context.Request.Params["LabType"]);
lt.LabDefault =false;
lt.LabAdmin = 1;
dm.SaveLab(lt);
dm.ReturnJsonMsg(context.Response, 1, "保存成功！", lt.LabID);
}
public int SaveLab(Lab lab)
{
InitCommand();
if (lab.LabID == 0)
{
//Insert new user
cmd.CommandText = "INSERT INTO Lab_tb (LabName,LabAdmin,LabAddr,LabInfo,LabAmount,LabType,LabDefault) VALUES (@LabName,@LabAdmin,@LabAddr,@LabInfo,@LabAmount,@LabType,@LabDefault)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@LabName", lab.LabName);
cmd.Parameters.AddWithValue("@LabAdmin", lab.LabAdmin);
cmd.Parameters.AddWithValue("@LabAddr", lab.LabAddr);
cmd.Parameters.AddWithValue("@LabInfo", lab.LabInfo);
cmd.Parameters.AddWithValue("@LabAmount", lab.LabAmount);
cmd.Parameters.AddWithValue("@LabType", lab.LabType);
cmd.Parameters.AddWithValue("@LabDefault", lab.LabDefault);
cmd.ExecuteNonQuery();
cmd.CommandText = "SELECT @@Identity ";
lab.LabID = (int)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "UPDATE Lab_tb SET " +
" LabName=@LabName,LabAdmin=@LabAdmin ,LabAddr=@LabAddr,LabInfo=@LabInfo,LabAmount=@LabAmount,LabType=@LabType,LabDefault=@LabDefault where LabID=@LabID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@LabName", lab.LabName);
cmd.Parameters.AddWithValue("@LabAdmin", lab.LabAdmin);
cmd.Parameters.AddWithValue("@LabAddr", lab.LabAddr);
cmd.Parameters.AddWithValue("@LabInfo", lab.LabInfo);
cmd.Parameters.AddWithValue("@LabAmount", lab.LabAmount);
cmd.Parameters.AddWithValue("@LabType", lab.LabType);
cmd.Parameters.AddWithValue("@LabDefault", lab.LabDefault);
cmd.Parameters.AddWithValue("@LabID", lab.LabID);
cmd.ExecuteNonQuery();
}
conn.Close();
return lab.LabID;
}
public List<Lab> GetLabs()
{
List<Lab> labs = new List<Lab>();
InitCommand();
cmd.CommandText = "select * from (( Lab_tb left join LabChType_tb on Lab_tb.LabType = LabChType_tb.LabChID ) left join LabType_tb on LabChType_tb.LabSupType= LabType_tb.LabTypeID ) ";
dr = cmd.ExecuteReader();
while (dr.Read())
{
Lab lab = new Lab();
lab.LabID = Convert.ToInt32(dr["LabID"]);
lab.LabAddr = dr["LabAddr"].ToString();
lab.LabAdmin = Convert.ToInt32(dr["LabAdmin"]);
lab.LabAmount = Convert.ToInt32(dr["LabAmount"]);
lab.LabDefault = Convert.ToBoolean(dr["LabDefault"]);
lab.LabInfo = dr["LabInfo"].ToString();
lab.LabName = dr["LabName"].ToString();
lab.LabType = Convert.ToInt32(dr["LabType"]);
lab.LabChName = dr["LabChName"].ToString();
lab.LabTypeName = dr["LabTypeName"].ToString();
labs.Add(lab);
}
return labs;
}
/// <summary>
/// 获取默认的实验室
/// </summary>
/// <returns></returns>
public Lab GetLab()
{
Lab lab = new Lab();
InitCommand();
string cmdText = "select * from ((( Lab_tb left join LabChType_tb on Lab_tb.LabType=LabChType_tb.LabChID) left join LabType_tb on LabChType_tb.LabSupType=LabType_tb.LabTypeID) left join Admin_tb on Lab_tb.LabAdmin=Admin_tb.AdminID) where LabDefault";
cmd.CommandText = cmdText;
dr = cmd.ExecuteReader();
if (dr.Read())
{
lab.LabAddr = dr["LabAddr"].ToString();
lab.LabAdmin = Convert.ToInt32(dr["LabAdmin"]);
lab.LabAmount = Convert.ToInt32(dr["LabAmount"]);
lab.LabDefault = Convert.ToBoolean(dr["LabDefault"]);
lab.LabID = Convert.ToInt32(dr["LabID"]);
lab.LabInfo = dr["LabInfo"].ToString();
lab.LabType = Convert.ToInt32(dr["LabType"]);
lab.LabName = dr["LabName"].ToString();
lab.LabChName = dr["LabChName"].ToString();
lab.LabTypeName = dr["LabTypeName"].ToString();
lab.LabSupType = Convert.ToInt32(dr["LabTypeID"]);
}
conn.Close();
return lab;
}