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);
}
}
