public static int AddOrder(String patientNum, String useNum, String doctorNum, String orderNum, int type, String use_time) { String useName; Decimal price; if (type == 2) { price = (Decimal)DatabaseTool.ExeclSqlReturnItem(String.Format(SELECT_OPERATION_PRICE_BYID, useNum), "single_price"); useName = (String)DatabaseTool.ExeclSqlReturnItem(String.Format("select * from operation where o_num =\"{0}\"", useNum), "o_name"); } else if (type == 3) { price = (Decimal)DatabaseTool.ExeclSqlReturnItem(String.Format(SELECT_DEVICE_PRICE_BYID, useNum), "single_price"); useName = (String)DatabaseTool.ExeclSqlReturnItem(String.Format("select * from device where d_num =\"{0}\"", useNum), "d_name"); } else { return(-1); } if (DatabaseTool.ExecSql(String.Format(INSERT_ORDER_SQL, patientNum, useNum, 1, doctorNum, orderNum, type, System.DateTime.Now.ToString(), use_time, price, useName, 0))) { return(DatabaseTool.GetLastInsertId()); } else { return(-1); } }
protected void fetch_Click1(object sender, EventArgs e) { List <FetchRecords> fetchRecords = new List <FetchRecords>(); for (int i = 0; i < this.notFetchOrders.Rows.Count; i++) { if (((CheckBox)notFetchOrders.Rows[i].FindControl("select")).Checked) { FetchRecords f = new FetchRecords(); f.PatientNum = notFetchOrders.Rows[i].Cells[1].Text.ToString(); f.FetchTime = System.DateTime.Now.ToString(); f.Person = fetchPerson.Text; f.medName = notFetchOrders.Rows[i].Cells[5].Text.ToString(); f.Amount = Convert.ToInt32(notFetchOrders.Rows[i].Cells[4].Text); f.PatientName = DatabaseTool.ExeclSqlReturnItem(String.Format("select * from patient where p_number =\"{0}\" ", f.PatientNum), "p_name").ToString(); f.MedcineNum = notFetchOrders.Rows[i].Cells[6].Text.ToString(); f.OrderNum = notFetchOrders.Rows[i].Cells[7].Text.ToString(); fetchRecords.Add(f); } } if (FetchRecordService.AddFetchRecords(fetchRecords) > 0) { Response.Write("<script language=javascript>window.alert('取药成功!');</script>"); notFetchOrders.DataSource = DatabaseTool.ExecSqlReturnDataSet(String.Format("select* from orders where patient_num=\"{0}\" and isfetch=0 and type=1", patientNum.Text)); notFetchOrders.DataBind(); } else { Response.Write("<script language=javascript>window.alert('存在取药数量大于库存量失败的取药记录!');</script>"); notFetchOrders.DataSource = DatabaseTool.ExecSqlReturnDataSet(String.Format("select* from orders where patient_num=\"{0}\" and isfetch=0 and type=1", patientNum.Text)); notFetchOrders.DataBind(); } }
public MainWindow() { InitializeComponent(); // 设置当前线程的名称 Thread.CurrentThread.Name = "MainWindow"; this.DataContext = this; // 初始化数据库连接 dbTool = new DatabaseTool("monitor", "sa", "sa", "localhost"); nowTextBlock.Text = DateTime.Now.ToShortDateString(); nowText = nowTextBlock.Text; // 初始化节点树 initTree(); // 异步接收 e = new IPEndPoint(IPAddress.Any, 5999); u = new UdpClient(e); s = new UdpState(); s.e = e; s.u = u; }
public MainWindow() { InitializeComponent(); // 设置当前线程的名称 Thread.CurrentThread.Name = "MainWindow"; this.DataContext = this; // 初始化数据库连接 dbTool = new DatabaseTool("monitor", "sa", "sa", "localhost"); nowTextBlock.Text = DateTime.Now.ToShortDateString(); nowText = nowTextBlock.Text; // 初始化节点树 initTree(); // 异步接收 e = new IPEndPoint(IPAddress.Any, 5999); u = new UdpClient(e); s = new UdpState(); s.e = e; s.u = u; }
protected void user_department_SelectedIndexChanged(object sender, EventArgs e) { this.id = this.user_department.SelectedValue; this.user_department.DataSource = DatabaseTool.ExecSqlReturnTable("select * from department where d_number= " + id); this.user_department.DataTextField = "d_name"; this.user_department.DataValueField = "d_number"; user_department.DataBind(); }
protected void NativeProvinceList_SelectedIndexChanged(object sender, EventArgs e) { // Response.Write("<script>alert('我响应了!')</script>"); String proID = this.NativeProvinceList.SelectedValue; this.NativeCityList.DataSource = DatabaseTool.ExecSqlReturnTable("select * from city where province_num= " + proID); this.NativeCityList.DataTextField = "city_name"; this.NativeCityList.DataValueField = "number"; NativeCityList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["number"] == null) { Response.Write("<script language=javascript>window.alert('请先登录!');window.location.href=('login.aspx');</script>"); } session.Text = Session["number"].ToString(); DataTable dt = DatabaseTool.ExecSqlReturnTable("select * from device"); examination_num1.DataSource = dt; examination_num1.DataTextField = "d_num"; examination_num1.DataValueField = "d_num"; examination_num1.DataBind(); examination_num2.DataSource = dt; examination_num2.DataTextField = "d_num"; examination_num2.DataBind(); examination_num3.DataSource = dt; examination_num3.DataTextField = "d_num"; examination_num3.DataBind(); examination_num4.DataSource = dt; examination_num4.DataTextField = "d_num"; examination_num4.DataBind(); examination_num5.DataSource = dt; examination_num5.DataTextField = "d_num"; examination_num5.DataBind(); examination_num6.DataSource = dt; examination_num6.DataTextField = "d_num"; examination_num6.DataBind(); examination_num7.DataSource = dt; examination_num7.DataTextField = "d_num"; examination_num7.DataBind(); examination_num8.DataSource = dt; examination_num8.DataTextField = "d_num"; examination_num8.DataBind(); examination_num9.DataSource = dt; examination_num9.DataTextField = "d_num"; examination_num9.DataBind(); examination_num10.DataSource = dt; examination_num10.DataTextField = "d_num"; examination_num10.DataBind(); //不可编辑的医生编号从session中获取,即当前用户的编号 doctor1.Text = Session["doctorNum"].ToString(); doctor2.Text = Session["doctorNum"].ToString(); doctor3.Text = Session["doctorNum"].ToString(); doctor4.Text = Session["doctorNum"].ToString(); doctor5.Text = Session["doctorNum"].ToString(); doctor6.Text = Session["doctorNum"].ToString(); doctor7.Text = Session["doctorNum"].ToString(); doctor8.Text = Session["doctorNum"].ToString(); doctor9.Text = Session["doctorNum"].ToString(); doctor10.Text = Session["doctorNum"].ToString(); }
//插入医嘱 public static int InsertDoctorsAdvice(String doctorNum, String patientNum, String content, int type, String doctorName) { if (DatabaseTool.ExecSql(String.Format(INSERT_DOCTORSADVICE_SQL, doctorNum, patientNum, System.DateTime.Now.ToString(), content, type, doctorName))) { return(DatabaseTool.GetLastInsertId()); } else { return(-1); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["number"] == null) { Response.Write("<script language=javascript>window.alert('请先登录!');window.location.href=('login.aspx');</script>"); } System.Diagnostics.Debug.Write(Session["number"]); session.Text = Session["number"].ToString(); DataTable dt = DatabaseTool.ExecSqlReturnTable("select * from department"); room_department.DataSource = dt; room_department.DataTextField = "d_name"; room_department.DataBind(); }
public static int indentifyUser(String username, String password) { Object selectType = DatabaseTool.ExeclSqlReturnItem(String.Format(QUERY_USER_SQL, username, password), "type"); String type = selectType.ToString(); if (type.Equals("-1")) { return(-1); } else { return(int.Parse(type)); } }
//添加用户 public static int AddUsers(String UserNum, String UserName, int type, String password, String sex, int age, String tel, String departNum) { if (DatabaseTool.ExeclSqlReturnItem(string.Format(QUERY_USERS_SQL, UserNum), "u_name").ToString().Equals("-1") == false) { return(-1); } if (DatabaseTool.ExecSql(String.Format(INSERT_USERS_SQL, UserNum, UserName, type, password, sex, age, tel, departNum))) { return(DatabaseTool.GetLastInsertId()); } else { return(-1); } }
//函数二用于插入药品订单 //函数二需要传入 患者编号、药品编号、数量、医生的编号、订单编号、类型(用于区分三类操作:药品是1 手术是2 检查是3) public static int AddOrder(String patientNum, String useNum, int amount, String doctorNum, String orderNum, int type) { String useName = (String)DatabaseTool.ExeclSqlReturnItem(String.Format("select * from medicine where m_num =\"{0}\"", useNum), "m_name"); Decimal price = (Decimal)DatabaseTool.ExeclSqlReturnItem(String.Format(SELECT_MEDICINE_PRICE_BYID, useNum), "price"); price *= amount; if (DatabaseTool.ExecSql(String.Format(INSERT_ORDER_SQL, patientNum, useNum, amount, doctorNum, orderNum, type, System.DateTime.Now.ToString(), "", price, useName, 0))) { return(DatabaseTool.GetLastInsertId()); } else { return(-1); } }
//添加设备 public static int AddDevice(String deviceNum, String deviceName, String manufacter, Decimal single_price, String dep_num) { if (DatabaseTool.ExeclSqlReturnItem(string.Format(QUERY_DEVICE_SQL, deviceNum), "d_name").ToString().Equals("-1") == false) { return(-1); } if (DatabaseTool.ExecSql(String.Format(INSERT_DEVICE_SQL, deviceNum, deviceName, manufacter, single_price, dep_num))) { return(DatabaseTool.GetLastInsertId()); } else { return(-1); } }
//添加病房 public static int AddRoom(String roomNum, String location, String departNum) { if (DatabaseTool.ExeclSqlReturnItem(string.Format(QUERY_ROOM_SQL, roomNum), "r_num").ToString().Equals("-1") == false) { return(-1); } if (DatabaseTool.ExecSql(String.Format(INSERT_ROOM_SQL, roomNum, location, departNum))) { return(DatabaseTool.GetLastInsertId()); } else { return(-1); } }
//添加药品 public static int AddMedicine(String medNum, String medName, String manufactor, Decimal price, Int32 amount, String type) { if (DatabaseTool.ExeclSqlReturnItem(string.Format(QUERY_MEDICINE_SQL, medNum), "m_name").ToString().Equals("-1") == false) { return(-1); } if (DatabaseTool.ExecSql(String.Format(INSERT_MEDICINE_SQL, medNum, medName, manufactor, price, amount, type))) { return(DatabaseTool.GetLastInsertId()); } else { return(-1); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["number"] == null) { Response.Write("<script language=javascript>window.alert('请先登录!');window.location.href=('login.aspx');</script>"); } session.Text = Session["number"].ToString(); doctor_num.Text = Session["doctorNum"].ToString(); doctor_name.Text = Session["number"].ToString(); DataTable dt = DatabaseTool.ExecSqlReturnTable("select * from patient where attending_physican_num=" + Session["doctorNum"].ToString()); patient_num.DataSource = dt; patient_num.DataTextField = "p_name"; patient_num.DataValueField = "p_number"; patient_num.DataBind(); }
public static DataTable ExecSqlReturnTable(String sql) //通过sql语句查询数据库中的数据,并将结果保存到DataSet数据集中,最终将该数据集中的查找结果的数据表返回 { try { MySqlConnection mySqlConnection = DatabaseTool.GetSqlConnection(); MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(sql, mySqlConnection); DataSet ds = new DataSet(); mySqlDataAdapter.Fill(ds); mySqlConnection.Close(); return(ds.Tables[0]); } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["number"] == null) { Response.Write("<script language=javascript>window.alert('请先登录!');window.location.href=('login.aspx');</script>"); } session.Text = Session["number"].ToString(); if (!IsPostBack) { DataTable dt = DatabaseTool.ExecSqlReturnTable("select * from department"); user_department.DataSource = dt; user_department.DataTextField = "d_name"; user_department.DataValueField = "d_number"; user_department.DataBind(); } }
/// <summary> /// Get Unit's Details /// </summary> private void GetDetails() { BusinessServices.Unit objUnit; DataTable dtbUnit; int intOrganisationID; //1. Get Unit details objUnit = new BusinessServices.Unit(); dtbUnit = objUnit.GetUnit(this.m_intUnitID); this.txtName.Text = dtbUnit.Rows[0]["Name"].ToString(); this.txtUnitID.Text = this.m_intUnitID.ToString(); if (dtbUnit.Rows[0]["Active"].ToString() == "True") { this.cboStatus.SelectedIndex = 0; } else { this.cboStatus.SelectedIndex = 1; } this.lblPathway.Text = dtbUnit.Rows[0]["Organisation"].ToString() + " > " + dtbUnit.Rows[0]["Pathway"].ToString(); DateTime dteOriginalDateUpdated = (DateTime)dtbUnit.Rows[0]["DateUpdated"]; this.OriginalDateUpdated = DatabaseTool.ToLongDateTimeString(dteOriginalDateUpdated); intOrganisationID = (int)dtbUnit.Rows[0]["OrganisationID"]; //2. Get Sub-Units tree DataSet dstUnits = objUnit.GetUnitsByOrganisation(intOrganisationID, "", "", "", this.m_intUnitID); string strUnits = UnitTreeConvert.ConvertXml(dstUnits); if (strUnits == "") { this.trvSubUnits.Visible = false; this.lblNoSubUnits.Visible = true; } else { this.trvSubUnits.Visible = true; this.lblNoSubUnits.Visible = false; this.trvSubUnits.LoadXml(strUnits); } }
//根据用户号查找用户 public static List <Users> QueryUsersByNum(String UserNum) { List <Dictionary <String, Object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(QUERY_USERS_SQL, UserNum)); List <Users> users = new List <Users>(); if (sqlResult == null || sqlResult.Count < 1) //如果结果为空,返回空对象 { return(users); } else { foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集,每一条都加入list { users.Add(Users.CreateUsers(dic)); } } return(users); }
public static List <Medicine> QueryMedicineByNum(String medicineNum) { List <Dictionary <String, Object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(QUERY_MEDICINE_SQL, medicineNum)); List <Medicine> medicine = new List <Medicine>(); if (sqlResult == null || sqlResult.Count < 1) //如果结果为空,返回空对象 { return(medicine); } else { foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集,每一条都加入list { medicine.Add(Medicine.createMedicine(dic)); } } return(medicine); }
public static List <Room> QueryRoomByNum(String roomNum) { List <Dictionary <String, Object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(QUERY_ROOM_SQL, roomNum)); List <Room> room = new List <Room>(); if (sqlResult == null || sqlResult.Count < 1) //如果结果为空,返回空对象 { return(room); } else { foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集,每一条都加入list { room.Add(Room.CreateRoom(dic)); } } return(room); }
//返回患者部分信息用于确认 public static List <PatientPart> SearchPartInformation(String ID) { List <Dictionary <String, object> > partInformation = DatabaseTool.ExecSqlReturn(String.Format(SELECT_PART_INFORMATION, ID)); List <PatientPart> patientParts = new List <PatientPart>(); if (partInformation == null || partInformation.Count < 1) { return(patientParts); } else { foreach (Dictionary <String, Object> dic in partInformation) //遍历结果集,每一条都加入list { patientParts.Add(PatientPart.CreatePatientPart(dic)); } return(patientParts); } }
public static List <Device> QueryDeviceByNum(String deviceNum) { List <Dictionary <String, Object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(QUERY_DEVICE_SQL, deviceNum)); List <Device> device = new List <Device>(); if (sqlResult == null || sqlResult.Count < 1) //如果结果为空,返回空对象 { return(device); } else { foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集,每一条都加入list { device.Add(Device.CreateDevice(dic)); } } return(device); }
private const String SELECT_DEVICE_PRICE_BYID = "select single_price from device where d_num=\"{0}\" "; //在设备表查价格 //重载函数 //函数一用于插入检查订单或者手术订单 //函数一需要传入 患者编号、手术或者检查的编号、医生的编号、订单编号、类型(用于区分三类操作:药品是1 手术是2 检查是3)、使用的时间 public static List <Order> QueryOrderByNum(String orderNum) { List <Dictionary <String, Object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(SELECT_ORDER_SQL, orderNum)); List <Order> order = new List <Order>(); if (sqlResult == null || sqlResult.Count < 1) //如果结果为空,返回空对象 { return(order); } else { foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集,每一条都加入list { order.Add(Order.CreateOrder(dic)); } } return(order); }
//查询取药记录 public static List <FetchRecords> QueryFetchByNum(String patientNum) { List <Dictionary <String, Object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(QUERY_FETCHRECORDS_SQL, patientNum)); List <FetchRecords> fetchRecords = new List <FetchRecords>(); if (sqlResult == null || sqlResult.Count < 1) //如果结果为空,返回空对象 { return(fetchRecords); } else { foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集,每一条都加入list { fetchRecords.Add(FetchRecords.CreateFetchRecords(dic)); } } return(fetchRecords); }
public static List <Department> QueryDepartmentByNum(String departmentNum) { List <Dictionary <String, Object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(QUERY_DEPARTMENT_SQL, departmentNum)); List <Department> department = new List <Department>(); if (sqlResult == null || sqlResult.Count < 1) //如果结果为空,返回空对象 { return(department); } else { foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集,每一条都加入list { department.Add(Department.CreateDepartment(dic)); } } return(department); }
//出院时查询医嘱 public List <DoctorsAdvice> QueryAdvicesByNum(String patientNum) { List <Dictionary <String, Object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(QUERY_DOCTORSADVICE_SQL, patientNum)); List <DoctorsAdvice> advices = new List <DoctorsAdvice>(); if (sqlResult == null || sqlResult.Count < 1) //如果结果为空,返回空对象 { return(advices); } else { foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集,每一条都加入list { advices.Add(DoctorsAdvice.CreateDoctorsAdvice(dic)); } } return(advices); }
// 将患者出院未出院字段改为已经出院,返回病人信息和费用 public static LeaveInformation LeaveHospital(String ID) { DatabaseTool.ExecSql(String.Format(UPDATE_PATIENT_CONDITION, ID)); //更新患者状态为已出院 DatabaseTool.ExecSql(String.Format(UPDATE_DISCHARGE_TIME, System.DateTime.Now.ToString(), ID)); //插入病人出院时间 //全部订单存放至orders List <Dictionary <String, Object> > sqlResult1 = DatabaseTool.ExecSqlReturn(String.Format(SELECT_ALL_ORDERS_BY_ID, ID)); List <Order> orders = new List <Order>(); foreach (Dictionary <String, Object> dic in sqlResult1) //遍历结果集,每一条都加入list { orders.Add(Order.CreateOrder(dic)); } //获取入院时间与出院时间,计算时间差 DateTime admissionTime = Convert.ToDateTime(DatabaseTool.ExeclSqlReturnItem(String.Format(SELECT_PATIENT_BY_ID, ID), "admission_time")); DateTime dischargeTime = Convert.ToDateTime(DatabaseTool.ExeclSqlReturnItem(String.Format(SELECT_PATIENT_BY_ID, ID), "discharge_time")); TimeSpan ts = dischargeTime.Subtract(admissionTime).Duration(); String dateDiff = ts.Days.ToString() + "天"; //获取全部医嘱存放至advices List <DoctorsAdvice> advices = new List <DoctorsAdvice>(); List <Dictionary <String, Object> > sqlResult2 = DatabaseTool.ExecSqlReturn(String.Format(SELECT_ALL_ADVICES_BY_ID, ID)); foreach (Dictionary <String, Object> dic in sqlResult2) //遍历结果集,每一条都加入list { advices.Add(DoctorsAdvice.CreateDoctorsAdvice(dic)); } //计算最终费用存放至totalPrice Decimal totalPrice = DatabaseTool.ExeclSqlDecimal(String.Format(SELECT_ALL_PRICE, ID)); //获取用户部分信息 PatientPartInformation partInformation = new PatientPartInformation(); List <Dictionary <String, Object> > sqlResult3 = DatabaseTool.ExecSqlReturn(String.Format(SELECT_PATIENT_BY_ID, ID)); foreach (Dictionary <String, Object> dic in sqlResult3) //遍历结果集,每一条都加入list { partInformation = PatientPartInformation.CreatePatientInformation(dic); } //新建信息对象,返回 LeaveInformation information = LeaveInformation.CreateLeavelInformation(advices, dateDiff, orders, totalPrice, partInformation); return(information); }
//按病人ID查找病人的操作 public static List <Patient> GetPatientsById(String ID) { //查询返回的是一个结果集,每一个结果集是一个主键为ID的多组对应关系 List <Dictionary <String, object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(SELECT_PATIENT_BY_ID, ID)); List <Patient> patient = new List <Patient>(); if (sqlResult == null || sqlResult.Count < 1) //如果结果为空,返回空对象 { return(patient); } else { foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集,每一条都加入list { patient.Add(Patient.CreatePatient(dic)); } } return(patient); }
//插入取药记录 public static int AddFetchRecords(List <FetchRecords> fetchRecords) { for (int i = 0; i < fetchRecords.Count; i++) { int nowAmout = Convert.ToInt32(DatabaseTool.ExeclSqlReturnItem(String.Format("select * from medicine", fetchRecords[i].MedcineNum), "amount")); nowAmout = nowAmout - fetchRecords[i].Amount; if (nowAmout < 0) { return(-1); } else { DatabaseTool.ExecSql(String.Format(INSERT_FETCHRECORDS_SQL, fetchRecords[i].Person, fetchRecords[i].medName, fetchRecords[i].PatientName, fetchRecords[i].Amount, fetchRecords[i].PatientNum, fetchRecords[i].FetchTime)); DatabaseTool.ExecSql(String.Format(UPDATE_MEDICINE_AMOUNT_SQL, nowAmout, fetchRecords[i].MedcineNum)); DatabaseTool.ExecSql(String.Format("update orders set isfetch=1 where order_num =\"{0}\" ", fetchRecords[i].OrderNum)); } } return(1); }