protected void Page_Load(object sender, EventArgs e)
{
if (OrderSysDataAccess.GetInstance().CreateDBConnect() == false)
{
Response.Write("<script language=javascript>alert('数据库连接失败，请稍后刷新重试！');window.location = 'Default.aspx';</script>");
}
}
public DataSet findUserListByDepartmentId(int departmentId)
{
string str = "select u.id as id, u.name as name, u.sex as sex, " +
"u.telephone as telephone, u.remarks as remarks from t_user u, t_dept d where " +
"u.dep_id = d.id and d.id = " + departmentId;
return(OrderSysDataAccess.GetInstance().findDataList(str));
}
public bool createGoods(string name, string number, string price, string picture, string remarks)
{
string insertStr = "insert into t_goods(name, number, price, picture, remarks) values('" + name + "', "
+ number + ", " + price + ", '" + picture + "', '" + remarks + " ')";
Console.WriteLine("sql = " + insertStr);
return(OrderSysDataAccess.GetInstance().executeSqlCmd(insertStr));
}
protected void Page_Load(object sender, EventArgs e)
{
testgit
if (OrderSysDataAccess.GetInstance().CreateDBConnect() == false)
{
Response.Write("<script language=javascript>alert('数据库连接失败，请稍后刷新重试！');window.location = 'login.aspx';</script>");
}
/*
* string connstring2 = "server =.; database = PrisonOrder; integrated security = SSPI";
* //database=test_login 数据库名
* SqlConnection conn = new SqlConnection(connstring2);
* SqlCommand cmd = conn.CreateCommand(); //创建数据库命令
*
* UserService.GetInstance().findUserbyNameAndPassword();
*
* try
* {
* conn.Open();//打开数据库
*
* string user_number = "admin2";
* string user_pwd = "admin2";
* cmd.CommandText = "select * from t_user where user_name = '" + user_number + "' and user_password="******"'" + user_pwd + "'"; //创建查询语句
* SqlDataReader sdr = cmd.ExecuteReader(); //从数据库中读取数据流存入reader中
* if (sdr.Read()) //从sdr中读取下一行数据,如果没有数据,sdr.Read()返回flase
* {
* HttpContext.Current.Session["UserId"] = user_number;
* HttpContext.Current.Session["Userpwd"] = user_pwd;
* Response.Redirect("welcome.aspx");
* }
* else
* {
* //Message.Text = "输入错误，请重新输入！";
*
* // Response.Redirect("login.aspx");
* // Response.Write("<script>confirm('输入账号或密码错误！');</script>");
*
* Response.Write("<script language=javascript>alert('输入账号或密码错误！');window.location = 'login.aspx';</script>");
*
* }
* }
* catch (Exception ee)
* {
* //Response.Write("The connection is fair");
* String str = ee.ToString();
* Console.WriteLine("Hello,world");
* Console.WriteLine(str);
* }
* finally
* {
* String str2 = "dasafs";
* Console.WriteLine(str2);
* conn.Close();
* }
*/
}
public bool modifyGoods(int id, string name, string number, string price, string picture, string remarks)
{
/*string updateStr = "update t_goods set name = '" + name + "', " +
* "number = " + number + ", price = " + price + ", picture = '" +
* picture + "', remarks = '" + remarks + "' where id = " + id;*/
string updateStr = "update t_goods set name = '" + name + "', " +
"number = " + number + ", price = " + price + ", remarks = '" + remarks + "' where id = " + id;
Console.WriteLine("sql = " + updateStr);
return(OrderSysDataAccess.GetInstance().executeSqlCmd(updateStr));
}
private void GenTreeNode()
{
if (OrderSysDataAccess.GetInstance().CreateDBConnect() == false)
{
Response.Write("<script language=javascript>alert('数据库连接失败，请稍后刷新重试！');window.location = 'Default.aspx';</script>");
return;
}
List <Prison> prisonList = UserService.GetInstance().findPrisonInfoByUser("admin");
TreeNode rootNode = new TreeNode();
this.Organization_View.Nodes.Add(rootNode);
Organization_View.ShowLines = true;
foreach (Prison prison in prisonList)
{
TreeNode prisonNode = new TreeNode();
prisonNode.Text = prison.Name;
prisonNode.NavigateUrl = null;
prisonNode.Value = "" + prison.Id;
rootNode.ChildNodes.Add(prisonNode);
foreach (Department department in prison.DepartmentList)
{
TreeNode departmentNode = new TreeNode();
if (departmentId == -1)
{
departmentId = department.Id;
departmentName = department.Name;
}
departmentNode.Text = department.Name;
departmentNode.NavigateUrl = null;
departmentNode.Value = "" + department.Id;
prisonNode.ChildNodes.Add(departmentNode);
}
}
RefreshGridViewByUserList();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
return;
}
if (OrderSysDataAccess.GetInstance().CreateDBConnect() == false)
{
Response.Write("<script language=javascript>alert('数据库连接失败，请稍后刷新重试！');window.location = 'Default.aspx';</script>");
return;
}
DataSet dataset = GoodsService.GetInstance().findGoodsList();
if ((dataset != null) && (dataset.Tables[0].Rows.Count > 0))
{
GridView1.DataSource = dataset;
GridView1.DataBind();
}
}
public DataSet findPrisonByUser(string userName)
{
string str = "select p.id, p.name from t_user u, t_prison p, t_dept d where u.dep_id = d.id and d.prison_id = p.id and u.name = '" + userName + "'";
return(OrderSysDataAccess.GetInstance().findDataList(str));
}
public bool findUserbyNameAndPassword(string userName, string password)
{
string str = "select * from t_user where name = '" + userName + "' and password="******"'" + password + "'";
return(OrderSysDataAccess.GetInstance().findDataByCommand(str));
}
public bool deleteGoodsList(string goodsList)
{
string deleteStr = "delete from t_goods where id in( " + goodsList + ")";
return(OrderSysDataAccess.GetInstance().executeSqlCmd(deleteStr));
}
public DataSet findGoodsById(string goodsId)
{
string str = "select * from t_goods where id = " + goodsId;
return(OrderSysDataAccess.GetInstance().findDataList(str));
}
public DataSet findGoodsList()
{
string str = "select * from t_goods";
return(OrderSysDataAccess.GetInstance().findDataList(str));
}
public DataSet findDepListByPrisonId(int prisonId)
{
string str = "select d.id, d.name from t_prison p, t_dept d where d.prison_id = p.id and p.id = " + prisonId;
return(OrderSysDataAccess.GetInstance().findDataList(str));
}
