public static void ConnectToData() { ISession session = ThreadLocalSession.CurrentSession(); string strVer = VersionData.GetVersion(); ThreadLocalSession.CloseCurrentSession(); }
public static void InsertOutLib(string User, string PumpName, string DrawType, string PumpClass) { ISession session = ThreadLocalSession.CurrentSession(); OutLib ol = new OutLib(); ol.User = User; ol.OutTime = DateTime.Now; ol.DrawType = DrawType; ol.PumpName = PumpName; ol.PumpType = PumpClass; ITransaction trans = session.BeginTransaction(); try { session.Save(ol); trans.Commit(); } catch (HibernateException he) { trans.Rollback(); } ThreadLocalSession.CloseCurrentSession(); }
private void button1_Click(object sender, System.EventArgs e) { if (textBox1.Text.Length == 0) { MessageBox.Show(this, "请输入语句!"); return; } ISession session = ThreadLocalSession.CurrentSession(); SqlConnection conn = session.Connection as SqlConnection; //IQuery query=session.CreateQuery(textBox1.Text); //IList list=query.List(); if (checkBox1.Checked) { SqlDataAdapter adapter = new SqlDataAdapter(textBox1.Text, conn); DataSet list = new DataSet(); adapter.Fill(list); dataGrid1.DataSource = list; } else { SqlCommand cmd = new SqlCommand(textBox1.Text, conn); cmd.ExecuteNonQuery(); } ThreadLocalSession.CloseCurrentSession(); }
public static FileType FindFileTypeById(int id) { ISession session = ThreadLocalSession.CurrentSession(); FileType ft = (FileType)session.Load(typeof(FileType), id); ThreadLocalSession.CloseCurrentSession(); return(ft); }
public static PumpType FindPumpTypeById(int id) { ISession session = ThreadLocalSession.CurrentSession(); PumpType pt = (PumpType)session.Load(typeof(PumpType), id); ThreadLocalSession.CloseCurrentSession(); return(pt); }
public static IList GetAllOutLibs() { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_Into = session.CreateCriteria(typeof(OutLib)); IList list = cri_Into.List(); ThreadLocalSession.CloseCurrentSession(); return(list); }
public static IList getPumpTypeName() { ISession session = ThreadLocalSession.CurrentSession(); IQuery qi_Pt = session.CreateQuery("select pt.TypeName from PumpType as pt"); IList list = qi_Pt.List(); ThreadLocalSession.CloseCurrentSession(); return(list); }
public static IList LoadDepartments() { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_PClass = session.CreateCriteria(typeof(Department)); IList list = cri_PClass.List(); ThreadLocalSession.CloseCurrentSession(); return(list); }
public static IList GetIntoLibPumpNames() { ISession session = ThreadLocalSession.CurrentSession(); IQuery qi = session.CreateQuery("select distinct il.PumpName from Product.IntoLib as il "); IList list = qi.List(); ThreadLocalSession.CloseCurrentSession(); return(list); }
public static IList LoadPumpType() { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_Pt = session.CreateCriteria(typeof(PumpType)); IList list = cri_Pt.List(); ThreadLocalSession.CloseCurrentSession(); return(list); }
public static IList GetOutLibByPumpName(string PumpName) { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_Into = session.CreateCriteria(typeof(OutLib)); cri_Into.Add(Expression.Like("PumpName", @"%" + PumpName + @"%")); IList list = cri_Into.List(); ThreadLocalSession.CloseCurrentSession(); return(list); }
public static IList GetOutLibByUserName(string User) { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_Out = session.CreateCriteria(typeof(OutLib)); cri_Out.Add(Expression.Eq("User", User)); IList list = cri_Out.List(); ThreadLocalSession.CloseCurrentSession(); return(list); }
public static IList GetUsers() { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_PClass = session.CreateCriteria(typeof(Department)); //cri_PClass.Add(Expression.Eq("ID",7)); Department dep = (Department)cri_PClass.List()[0]; ThreadLocalSession.CloseCurrentSession(); return(dep.Users); }
public static string GetVersion() { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_Ver = session.CreateCriteria(typeof(GVersion)); IList versions = cri_Ver.List(); GVersion gv = (GVersion)versions[0]; ThreadLocalSession.CloseCurrentSession(); return(gv.Version); }
public static IList GetIntoLibByProductNo(string ProductNo) { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_Into = session.CreateCriteria(typeof(IntoLib)); cri_Into.Add(Expression.Eq("ProductNo", ProductNo)); IList list = cri_Into.List(); ThreadLocalSession.CloseCurrentSession(); return(list); }
public static IList GetIntoLibByFileName(string FileName) { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_Into = session.CreateCriteria(typeof(IntoLib)); cri_Into.Add(Expression.Like("FileName", "%" + FileName + "%")); IList list = cri_Into.List(); ThreadLocalSession.CloseCurrentSession(); return(list); }
public static bool IsUserExists(string Username) { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_PClass = session.CreateCriteria(typeof(_User)); cri_PClass.Add(Expression.Eq("Name", Username)); IList list = cri_PClass.List(); ThreadLocalSession.CloseCurrentSession(); return(list.Count > 0); }
public static PumpType FindPumpTypeByName(string pumpType) { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_Pt = session.CreateCriteria(typeof(PumpType)); cri_Pt.Add(Expression.Eq("TypeName", pumpType)); IList list = cri_Pt.List(); PumpType ft = (PumpType)list[0]; ThreadLocalSession.CloseCurrentSession(); return(ft); }
public static _User GetUserFromUserID(string UserID) { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_PClass = session.CreateCriteria(typeof(_User)); cri_PClass.Add(Expression.Eq("UserID", UserID)); IList list = cri_PClass.List(); ThreadLocalSession.CloseCurrentSession(); _User user = (_User)list[0]; return(user); }
public static void ConnectToData() { ISession session = ThreadLocalSession.CurrentSession(); IDbConnection conn = session.Connection; IDbCommand cmd = conn.CreateCommand(); cmd.CommandText = "set names 'gb2312'"; cmd.ExecuteNonQuery(); //IQuery query = session.CreateSQLQuery("set names 'utf8'"); //IList list=query.List(); //string strVer=VersionData.GetVersion(); ThreadLocalSession.CloseCurrentSession(); }
public static void DeletePumpType(PumpType pt) { ISession session = ThreadLocalSession.CurrentSession(); ITransaction tx = session.BeginTransaction(); try { session.Delete(pt); tx.Commit(); } catch (HibernateException ex) { tx.Rollback(); } ThreadLocalSession.CloseCurrentSession(); }
private void button1_Click(object sender, System.EventArgs e) { if (textBox1.Text.Length == 0) { MessageBox.Show(this, "请输入语句!"); return; } ISession session = ThreadLocalSession.CurrentSession(); IQuery query = session.CreateQuery(textBox1.Text); IList list = query.List(); ThreadLocalSession.CloseCurrentSession(); dataGrid1.DataSource = list; }
public static void MoveToDep(_User user, Department dep) { ISession session = ThreadLocalSession.CurrentSession(); ITransaction tx = session.BeginTransaction(); try { user.Department = dep; session.Update(user); tx.Commit(); } catch (HibernateException ex) { tx.Rollback(); } ThreadLocalSession.CloseCurrentSession(); }
public static int GetDepartIdFromName(string DepName) { int result = -1; ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_PClass = session.CreateCriteria(typeof(Department)); cri_PClass.Add(Expression.Eq("DepartmentName", DepName)); IList list = cri_PClass.List(); if (list.Count > 0) { Department dep = (Department)list[0]; result = dep.ID; } ThreadLocalSession.CloseCurrentSession(); return(result); }
public static void InsertFileType(string TypeName) { ISession session = ThreadLocalSession.CurrentSession(); FileType ft = new FileType(); ft.Type = TypeName; ITransaction tx = session.BeginTransaction(); try { session.Save(ft); tx.Commit(); } catch (HibernateException ex) { tx.Rollback(); } ThreadLocalSession.CloseCurrentSession(); }
public static string GetVersion() { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_Ver = session.CreateCriteria(typeof(GVersion)); IList versions = cri_Ver.List(); GVersion gv; if (versions.Count >= 1) { gv = (GVersion)versions[0]; } else { return("1.0"); } ThreadLocalSession.CloseCurrentSession(); return(gv.Version); }
public static void DeleteUser(string UserID) { ISession session = ThreadLocalSession.CurrentSession(); ICriteria cri_User = session.CreateCriteria(typeof(hbm._User)); cri_User.Add(Expression.Eq("UserID", UserID)); IList list = cri_User.List(); _User user = (_User)list[0]; ITransaction tx = session.BeginTransaction(); try { session.Delete(user); tx.Commit(); } catch (HibernateException ex) { tx.Rollback(); } ThreadLocalSession.CloseCurrentSession(); }
public static void SaveUser(string ID, string Name, string Sex, string Pass, Department dep) { ISession session = ThreadLocalSession.CurrentSession(); _User user = new _User(); user.UserID = ID; user.Name = Name; user.Sex = Sex; user.Password = Pass; user.Department = dep; ITransaction tx = session.BeginTransaction(); try { session.Save(user); tx.Commit(); } catch (HibernateException ex) { tx.Rollback(); } ThreadLocalSession.CloseCurrentSession(); }
public static void SaveNewUser(string Username) { if (!IsUserExists(Username)) { _User user = new _User(); user.UserID = "1"; user.Name = Username; user.Sex = "m"; user.Password = "******"; ISession session = ThreadLocalSession.CurrentSession(); ITransaction tx = session.BeginTransaction(); try { session.Save(user); tx.Commit(); } catch (HibernateException ex) { tx.Rollback(); } ThreadLocalSession.CloseCurrentSession(); } }
private void button1_Click(object sender, EventArgs e) { ISession session = ThreadLocalSession.CurrentSession(); IDbConnection conn = session.Connection; //IQuery query=session.CreateQuery(textBox1.Text); //IList list=query.List(); string strTemp = ""; if (rbToday.Checked) { strTemp = "select * from intolib where to_days(inputtime) = to_days(now())"; } if (rbWeek.Checked) { strTemp = "select * from intolib where week(inputtime,1) = week(now(),1) and year(inputtime) = year(now())"; } if (rbMonth.Checked) { strTemp = "select * from intolib where month(inputtime) = month(curdate()) and year(inputtime) = year(now())"; } //string strSql = "select * from intolib where datesub(currentdate(),interval 1 " + strTemp + ")<=inputtime"; string strSql = strTemp; if (rbLastMonth.Checked) { strSql = "select * from intolib where month(inputtime)=month(curdate())-1 and year(inputtime)=year(now())"; } if (rbAll.Checked) { strSql = "select * from intolib"; } //SqlDataAdapter adapter = new SqlDataAdapter(strSql, conn); ISQLQuery adapter = session.CreateSQLQuery(strSql); //DataTable dt = new DataTable(); //adapter.Fill(dt); IList intolibs = adapter.AddEntity(typeof(IntoLib)).List(); ThreadLocalSession.CloseCurrentSession(); listView1.Items.Clear(); foreach (object o in intolibs) { IntoLib il = o as IntoLib; ListViewItem item = new ListViewItem(); item.Text = il.id.ToString(); item.SubItems.Add(il.InputTime.ToString()); item.SubItems.Add(il.User); item.SubItems.Add(il.PumpType); item.SubItems.Add(il.PumpName); item.SubItems.Add(il.DrawType); item.SubItems.Add(il.FileName); item.SubItems.Add(il.Version.ToString()); listView1.Items.Add(item); } }