/// <summary>
/// 更新数据
/// </summary>
public bool UpdateOrder(EmsModel.OrderInfo EmsModel, List <EmsModel.OrderEquipDetail> list)
{
using (SqlTransaction trans = dbHelper.BeginTransaction())
{
int count = Update(trans, EmsModel);//修改订单状态
for (int i = 0; i < list.Count; i++)
{
list[i].Type = Convert.ToByte(EmsModel.Status);
count += new EmsDAL.OrderEquipDetail().Update(trans, list[i]);
}
if (count < list.Count)
{//如果没有全部修改
//回滚
trans.Rollback();
return(false);
}
else
{
//提交
trans.Commit();
return(true);
}
}
}
/// <summary>
/// 订单归还
/// </summary>
/// <param name="listModer"></param>
/// <param name="orderNo"></param>
/// <param name="orderType"></param>
/// <param name="DetailType"></param>
/// <returns></returns>
public bool UpdateOrderEscheat(string strID, string orderID, int orderType, int DetailType)
{
using (SqlTransaction trans = dbHelper.BeginTransaction())
{
int count = 0;
try
{
//更新订单详情
count += new EmsDAL.OrderEquipDetail().UpdateType(trans, strID, orderID);
count += UpdateStatus(trans, orderType, orderID);//修改订单状态
}
catch (Exception)
{
//回滚
trans.Rollback();
count = 0;
//写入日志
//throw;
}
if (count < 1)
{//如果没有修改
//回滚
trans.Rollback();
return(false);
}
else
{
//提交
trans.Commit();
return(true);
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateOrder(EmsModel.OrderInfo Model)
{
EmsModel.OrderEquipDetail MOD = new EmsModel.OrderEquipDetail();
MOD.OrderId = Model.Id;
List <EmsModel.OrderEquipDetail> list = new EmsDAL.OrderEquipDetail().GetListByPage(MOD, 1, 999);
return(dal.UpdateOrder(Model, list));
}
public bool OtherLend(List <EmsModel.OrderEquipDetail> listModer, string LoanName, string Creator, string orderNo, int orderType, int DetailType)
{
using (SqlTransaction trans = dbHelper.BeginTransaction())
{
int count = 0;
try
{
EmsModel.OrderInfo order = new EmsModel.OrderInfo();
order.OrderNo = "WJ" + DateTime.Now.ToString("yyMMdd");
order.LoanName = LoanName;
order.ExperimentId = 0;
order.Type = Convert.ToByte(orderType);
order.Status = 0;
order.Creator = Creator;
order.CreateTime = DateTime.Now;
order.IsDelete = 0;
EmsDAL.OrderInfo orderDAL = new OrderInfo();
int num = orderDAL.Add(trans, order);
order.Id = num;
count += orderDAL.Update(trans, order);
foreach (var item in listModer)
{
count += new EmsDAL.OrderEquipDetail().Add(trans, item);
}
//count = UpdateStatus(trans, orderType, orderNo);//修改订单状态
}
catch (Exception)
{
//回滚
trans.Rollback();
count = 0;
//写入日志
//throw;
}
if (count < 1)
{//如果没有修改
//回滚
trans.Rollback();
return(false);
}
else
{
//提交
trans.Commit();
return(true);
}
}
}
/// <summary>
/// 订单借出
/// </summary>
/// <param name="listModer"></param>
/// <param name="orderNo"></param>
/// <param name="orderType"></param>
/// <param name="DetailType"></param>
/// <returns></returns>
public bool UpdateOrderLend(List <EmsModel.OrderEquipDetail> listModer, string orderNo, int orderType, int DetailType, EmsModel.OrderInfo mod)
{
using (SqlTransaction trans = dbHelper.BeginTransaction())
{
int count = 0;
try
{
int orderid = Add(trans, mod);
foreach (var item in listModer)
{
item.OrderId = orderid;
count += new EmsDAL.OrderEquipDetail().Add(trans, item);
}
}
catch (Exception)
{
//回滚
trans.Rollback();
count = 0;
//写入日志
//throw;
}
if (count < 0)
{//如果没有修改
//回滚
trans.Rollback();
return(false);
}
else
{
//提交
trans.Commit();
return(true);
}
}
}
/// <summary>
/// 获取订单设备
/// </summary>
/// <param name="Mod">查询条件</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">页容量，每页显示条数</param>
/// <returns></returns>
public EmsModel.JsonModel GetOrderEquipList(Hashtable ht)
{
EmsDAL.OrderEquipDetail DALOED = new EmsDAL.OrderEquipDetail();
BLLCommon com = new BLLCommon();
try
{
DataTable dt = DALOED.GetData(ht);
//定义JSON标准格式实体中
JsonModel jsonModel = null;
if (dt.Rows.Count == 0)
{
jsonModel = new JsonModel()
{
Status = "no",
Msg = "无数据"
};
return(jsonModel);
}
//将分页数据实体封装到JSON标准实体中
jsonModel = new JsonModel()
{
Data = com.DataTableToList(dt),
Msg = "",
Status = "ok",
BackUrl = ""
};
return(jsonModel);
}
catch (Exception ex)
{
JsonModel jsonModel = new JsonModel();
jsonModel.Status = "error";
jsonModel.Msg = ex.ToString();
return(jsonModel);
}
}
public EmsModel.JsonModel CreateOrder(Hashtable ht)
{
try
{
//string[] Str = ht["YSelectStr"].ToString().Split(',');//
//订单编号前缀
string prefix = "";
if (ht["Type"].ToString() == "0")
{
prefix = "SY";
}
else if (ht["Type"].ToString() == "1")
{
prefix = "YJ";
}
EmsDAL.OrderEquipDetail ModelOrderEquipDetail = new EmsDAL.OrderEquipDetail();
//订单赋值
EmsModel.OrderInfo ModelOrderInfo = new EmsModel.OrderInfo();
ModelOrderInfo.OrderNo = prefix;
ModelOrderInfo.LoanName = ht["LoanName"].ToString();
ModelOrderInfo.ExperimentId = Convert.ToInt32(ht["ExperimentId"]);
ModelOrderInfo.Type = Convert.ToByte(ht["Type"]);
ModelOrderInfo.Status = 0;
ModelOrderInfo.Creator = ht["Creator"].ToString();
ModelOrderInfo.CreateTime = DateTime.Now;
ModelOrderInfo.IsDelete = 0;
//修改实验“是否生成订单”状态
EmsDAL.PlanExperiment DALPE = new EmsDAL.PlanExperiment();
EmsModel.PlanExperiment ModelPE = DALPE.GetData(ht["ExperimentId"].ToString())[0];
ModelPE.Status = 1;//将实验状态赋值为“已生成订单”
//事务
using (SqlTransaction trans = dal.GetTran())
{
try
{
//添加订单
int orderId = dal.Add(trans, ModelOrderInfo);
if (orderId <= 0)
{
//回滚
trans.Rollback();
//定义JSON标准格式实体中
JsonModel jsonModel1 = new JsonModel();
jsonModel1.Status = "no";
jsonModel1.Msg = "订单生成失败";
return(jsonModel1);
}
//修改订单编号
ModelOrderInfo.Id = orderId;
ModelOrderInfo.OrderNo = prefix + DateTime.Now.ToString("yyMMddHHmmss") + orderId;
int UpdateReturn = dal.Update(trans, ModelOrderInfo);
if (UpdateReturn != 1)
{
//回滚
trans.Rollback();
//定义JSON标准格式实体中
JsonModel jsonModel1 = new JsonModel();
jsonModel1.Status = "no";
jsonModel1.Msg = "订单生成失败";
return(jsonModel1);
}
//修改实验状态
int UpdatePEReturn = DALPE.Update(trans, ModelPE);
if (UpdatePEReturn != 1)
{
//回滚
trans.Rollback();
//定义JSON标准格式实体中
JsonModel jsonModel1 = new JsonModel();
jsonModel1.Status = "no";
jsonModel1.Msg = "订单生成失败";
return(jsonModel1);
}
#region 添加订单设备详情
////生成订单
//int AddCount = 0;
//int SuccessCount = 0;
////循环添加设备
//foreach (string item in Str)
//{
// int EquipKindId = Convert.ToInt32(item.Substring(0, item.IndexOf("-")));
// int Count = Convert.ToInt32(item.Substring(item.IndexOf("-") + 1, item.IndexOf(":") - item.IndexOf("-") - 1));
// string InstrumentEquip = item.Substring(item.IndexOf(":") + 1);
// //更新需要添加的设备数量
// AddCount += Count;
// //每个设备添加一条数据
// for (int i = 0; i < Count; i++)
// {
// //model赋值
// EmsModel.OrderEquipDetail model = new EmsModel.OrderEquipDetail();
// model.OrderId = orderId;
// model.InventoryKindId = EquipKindId;
// model.EquipId = "";
// model.InstrumentEquip = InstrumentEquip;
// model.EquipDetailName = "";
// model.Type = 0;
// int ret = ModelOrderEquipDetail.Add(trans, model);
// if (ret > 0)
// {
// SuccessCount++;
// }
// }
//}
//if (AddCount != SuccessCount)
//{
// //回滚
// trans.Rollback();
// //定义JSON标准格式实体中
// JsonModel jsonModel1 = new JsonModel();
// jsonModel1.Status = "no";
// jsonModel1.Msg = "订单生成失败";
// return jsonModel1;
//}
//else
//{
// //提交
// trans.Commit();
//}
#endregion
//提交
trans.Commit();
}
catch (Exception)
{
//回滚
trans.Rollback();
throw;
}
}
//定义JSON标准格式实体中
JsonModel jsonModel = new JsonModel();
jsonModel.Status = "ok";
jsonModel.Msg = "订单生成成功";
return(jsonModel);
}
catch (Exception ex)
{
JsonModel jsonModel = new JsonModel();
jsonModel.Status = "error";
jsonModel.Msg = ex.ToString();
return(jsonModel);
}
}
