public static void SaveInLibRecord(string user, string PumpType, string PumpName, string fileName, string DrawType)
{
ISession session = ThreadLocalSession.CurrentSession();
IntoLib il = new IntoLib();
il.User = user;
il.InputTime = DateTime.Now;
il.PumpType = PumpType;
il.PumpName = PumpName;
il.FileName = fileName;
il.DrawType = DrawType;
ITransaction trans = session.BeginTransaction();
try
{
session.Save(il);
trans.Commit();
}
catch (HibernateException ex)
{
trans.Rollback();
}
ThreadLocalSession.CloseCurrentSession();
}
public static string GetPumpClass(string pumpName)
{
string result = "";
ISession session = ThreadLocalSession.CurrentSession();
ICriteria cri_PClass = session.CreateCriteria(typeof(PumpClass));
cri_PClass.Add(Expression.Eq("PumpName", pumpName));
IList list = cri_PClass.List();
if (list.Count > 0)
{
PumpClass pc = (PumpClass)list[0];
result = pc.PumpGClass;
}
ThreadLocalSession.CloseCurrentSession();
return(result);
}
public static void SavePumpClass(string pName, string pClassName)
{
ISession session = ThreadLocalSession.CurrentSession();
PumpClass pc = new PumpClass();
pc.PumpName = pName;
pc.PumpGClass = pClassName;
ITransaction ts = session.BeginTransaction();
try
{
session.Save(pc);
ts.Commit();
}
catch (HibernateException he)
{
ts.Rollback();
}
ThreadLocalSession.CloseCurrentSession();
}
