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 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 ContentResult UnloadingPointSave(AscmUnloadingPoint ascmUnloadingPoint_Model, int? id)
{
JsonObjectResult jsonObjectResult = new JsonObjectResult();
try
{
string userName = string.Empty;
if (User.Identity.IsAuthenticated)
{
userName = User.Identity.Name;
}
if (ascmUnloadingPoint_Model.name == null || ascmUnloadingPoint_Model.name.Trim() == "")
throw new Exception("卸货点名称不能为空");
string name = ascmUnloadingPoint_Model.name.Trim();
AscmWarehouse ascmWarehouse = AscmWarehouseService.GetInstance().Get(ascmUnloadingPoint_Model.warehouseId);
if (ascmWarehouse == null)
throw new Exception("仓库不能为空");
AscmUnloadingPoint ascmUnloadingPoint = null;
if (id.HasValue)
{
ascmUnloadingPoint = AscmUnloadingPointService.GetInstance().Get(id.Value);
if (ascmUnloadingPoint == null)
throw new Exception("保存卸货点失败！");
}
else
{
ascmUnloadingPoint = new AscmUnloadingPoint();
int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmUnloadingPoint");
ascmUnloadingPoint.id = ++maxId;
ascmUnloadingPoint.createUser = userName;
ascmUnloadingPoint.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
}
object object1 = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select count(*) from AscmUnloadingPoint where id<>" + ascmUnloadingPoint.id + " and warehouseId='" + ascmWarehouse.id + "' and name='" + name + "'");
if (object1 == null)
throw new Exception("查询异常！");
int count = 0;
if (int.TryParse(object1.ToString(), out count) && count > 0)
throw new Exception("仓库【" + ascmWarehouse.id + "】已存在卸货点名称");
ascmUnloadingPoint.name = name;
ascmUnloadingPoint.ascmWarehouse = ascmWarehouse;
ascmUnloadingPoint.warehouseId = ascmWarehouse.id;
ascmUnloadingPoint.controllerId = ascmUnloadingPoint_Model.controllerId;
ascmUnloadingPoint.controllerAddress = ascmUnloadingPoint_Model.controllerAddress;
if (!string.IsNullOrEmpty(ascmUnloadingPoint_Model.direction))
ascmUnloadingPoint.direction = ascmUnloadingPoint_Model.direction.Trim();
if (!string.IsNullOrEmpty(ascmUnloadingPoint_Model.location))
ascmUnloadingPoint.location = ascmUnloadingPoint_Model.location.Trim();
ascmUnloadingPoint.status = ascmUnloadingPoint_Model.status;
ascmUnloadingPoint.ip = ascmUnloadingPoint_Model.ip;
ascmUnloadingPoint.enabled = ascmUnloadingPoint_Model.enabled;
if (!string.IsNullOrEmpty(ascmUnloadingPoint_Model.description))
ascmUnloadingPoint.description = ascmUnloadingPoint_Model.description.Trim();
if (!string.IsNullOrEmpty(ascmUnloadingPoint_Model.memo))
ascmUnloadingPoint.memo = ascmUnloadingPoint_Model.memo.Trim();
ascmUnloadingPoint.modifyUser = userName;
ascmUnloadingPoint.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (id.HasValue)
AscmUnloadingPointService.GetInstance().Update(ascmUnloadingPoint);
else
AscmUnloadingPointService.GetInstance().Save(ascmUnloadingPoint);
jsonObjectResult.result = true;
jsonObjectResult.id = ascmUnloadingPoint.id.ToString();
//jsonObjectResult.entity = ascmUnloadingPoint;
jsonObjectResult.message = "";
}
catch (Exception ex)
{
jsonObjectResult.message = ex.Message;
}
string sReturn = JsonConvert.SerializeObject(jsonObjectResult);
return Content(sReturn);
}
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;
}
}
