public void Update(AscmUnloadingPoint ascmUnloadingPoint)
{
try
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmUnloadingPoint>(ascmUnloadingPoint);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmUnloadingPoint)", ex);
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Save AscmUnloadingPoint)", ex);
throw ex;
}
}
public void Delete(AscmUnloadingPoint ascmUnloadingPoint)
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Delete <AscmUnloadingPoint>(ascmUnloadingPoint);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmUnloadingPoint)", ex);
throw ex;
}
}
public void Delete(int id)
{
try
{
AscmUnloadingPoint ascmUnloadingPoint = Get(id);
Delete(ascmUnloadingPoint);
}
catch (Exception ex)
{
throw ex;
}
}
public AscmUnloadingPoint Get(int id)
{
AscmUnloadingPoint ascmUnloadingPoint = null;
try
{
ascmUnloadingPoint = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmUnloadingPoint>(id);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmUnloadingPoint)", ex);
throw ex;
}
return(ascmUnloadingPoint);
}
public static void AscmUnloadingPointUpdate(AscmUnloadingPoint point)
{
try
{
String ConnectionString = " Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.16.9.191)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=md_ascm)));User Id=ascm;Password=AScm1240#;";
OracleConnection conn = new OracleConnection(ConnectionString);
conn.Open();
string modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string sql = "update ascm_unloading_point set status = '" + point.status + "', modifytime = '" + modifyTime + "' where id = " + point.id;
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
}
}
public void UpdateStatus(int id, string status, string sessionKey)
{
try
{
AscmUnloadingPoint ascmUnloadingPoint = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmUnloadingPoint>(id, sessionKey);
if (ascmUnloadingPoint == null)
{
throw new Exception("找不到卸货点");
}
ascmUnloadingPoint.status = status;
ascmUnloadingPoint.modifyTime = System.DateTime.Now.ToString("yyyy-MM-dd HH:ss");
DateTime dtServerTime = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentDate("AscmUnloadingPointLog", sessionKey);
AscmUnloadingPointLog ascmUnloadingPointLog = new AscmUnloadingPointLog();
ascmUnloadingPointLog.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ascmUnloadingPointLog.modifyTime = dtServerTime.ToString("yyyy-MM-dd HH:mm:ss");
ascmUnloadingPointLog.unloadingPointId = ascmUnloadingPoint.id;
ascmUnloadingPointLog.unloadingPointName = ascmUnloadingPoint.name;
ascmUnloadingPointLog.unloadingPointSn = ascmUnloadingPoint.sn;
ascmUnloadingPointLog.unloadingPointStatus = ascmUnloadingPoint.status;
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession(sessionKey).BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update(ascmUnloadingPoint, sessionKey);
if (ascmUnloadingPointLog != null)
{
YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmUnloadingPointLog, sessionKey);
}
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改状态失败(Update AscmUnloadingPoint Status)", ex);
throw ex;
}
}
public void UpdateStatus(int id, string status)
{
try
{
AscmUnloadingPoint ascmUnloadingPoint = Get(id);
if (ascmUnloadingPoint == null)
{
throw new Exception("找不到卸货点");
}
ascmUnloadingPoint.status = status;
ascmUnloadingPoint.modifyTime = System.DateTime.Now.ToString("yyyy-MM-dd HH:ss");
AscmUnloadingPointLog ascmUnloadingPointLog =
AscmUnloadingPointLogService.GetInstance().GetAddLog(ascmUnloadingPoint.id, ascmUnloadingPoint.name, ascmUnloadingPoint.sn, ascmUnloadingPoint.status, DateTime.Now);
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update(ascmUnloadingPoint);
if (ascmUnloadingPointLog != null)
{
YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmUnloadingPointLog);
}
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改状态失败(Update AscmUnloadingPoint Status)", ex);
throw ex;
}
}
