/// <summary> /// 获取指定记录 /// <param name="id">Id值</param> /// </summary> public ProProductonDetail Get(int PDId) { ProProductonDetail returnValue = null; MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdGetProProductonDetail = cmdGetProProductonDetail.Clone() as MySqlCommand; _cmdGetProProductonDetail.Connection = oc; try { _cmdGetProProductonDetail.Parameters["@PDId"].Value = PDId; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdGetProProductonDetail.ExecuteReader(); if (reader.HasRows) { reader.Read(); returnValue = new ProProductonDetail().BuildSampleEntity(reader); } } finally { oc.Close(); oc.Dispose(); oc = null; _cmdGetProProductonDetail.Dispose(); _cmdGetProProductonDetail = null; GC.Collect(); } return(returnValue); }
/// <summary> /// 修改指定的数据 /// <param name="e">修改后的数据实体对象</param> /// <para>数据对应的主键必须在实例中设置</para> /// </summary> public void Update(ProProductonDetail e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdUpdateProProductonDetail = cmdUpdateProProductonDetail.Clone() as MySqlCommand; _cmdUpdateProProductonDetail.Connection = oc; try { if (oc.State == ConnectionState.Closed) { oc.Open(); } _cmdUpdateProProductonDetail.Parameters["@PDId"].Value = e.PDId; _cmdUpdateProProductonDetail.Parameters["@Price"].Value = e.Price; _cmdUpdateProProductonDetail.Parameters["@PNum"].Value = e.PNum; _cmdUpdateProProductonDetail.Parameters["@PCode"].Value = e.PCode; _cmdUpdateProProductonDetail.Parameters["@CreateTime"].Value = e.CreateTime; _cmdUpdateProProductonDetail.Parameters["@UserId"].Value = e.UserId; _cmdUpdateProProductonDetail.Parameters["@PId"].Value = e.UserId; _cmdUpdateProProductonDetail.ExecuteNonQuery(); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdUpdateProProductonDetail.Dispose(); _cmdUpdateProProductonDetail = null; GC.Collect(); } }
/// <summary> /// 添加数据 /// <param name="es">数据实体对象数组</param> /// <returns></returns> /// </summary> public bool Insert(ProProductonDetail e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdInsertProProductonDetail = cmdInsertProProductonDetail.Clone() as MySqlCommand; bool returnValue = false; _cmdInsertProProductonDetail.Connection = oc; try { if (oc.State == ConnectionState.Closed) { oc.Open(); } _cmdInsertProProductonDetail.Parameters["@Price"].Value = e.Price; _cmdInsertProProductonDetail.Parameters["@PNum"].Value = e.PNum; _cmdInsertProProductonDetail.Parameters["@PCode"].Value = e.PCode; _cmdInsertProProductonDetail.Parameters["@CreateTime"].Value = e.CreateTime; _cmdInsertProProductonDetail.Parameters["@UserId"].Value = e.UserId; _cmdInsertProProductonDetail.Parameters["@PId"].Value = e.Pid; returnValue = _cmdInsertProProductonDetail.ExecuteNonQuery() > 0?true:returnValue; return(returnValue); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdInsertProProductonDetail.Dispose(); _cmdInsertProProductonDetail = null; } }
/// <summary> /// 添加入库单 /// </summary> /// <param name="ppd"></param> /// <returns></returns> public JsonResult AddProductonDetail(int pid, int num, float price) { var Res = new JsonResult(); AdvancedResult <ProProductonDetail> result = new AdvancedResult <ProProductonDetail>(); ProProductonDetail ppd = new ProProductonDetail(); try { if (CacheManagerFactory.GetMemoryManager().Contains(token)) { if (!CheckUserFunction("2011")) { result.Error = AppError.ERROR_PERMISSION_FORBID; Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); } ppd.PCode = DateTime.Now.ToString("yyyymmddhhmmssfff");//采购批次号 ppd.PNum = num; ppd.Price = price; ppd.UserId = CurrentUser.UserId; ppd.IsPay = 1; ppd.CreateTime = DateTime.Now; ppd.PId = pid; ppd.EntId = CurrentUser.EntId; result.Id = ProProductonDetailAccessor.Instance.Insert(ppd); result.Data = ppd; if (result.Id > 0) { result.Error = AppError.ERROR_SUCCESS; ProProduction pro = ProProductionAccessor.Instance.Get(pid); ProProductionAccessor.Instance.UpdateStockCount(pid, pro.StockCount + num); } else { result.Error = AppError.ERROR_FAILED; } } else { result.Error = AppError.ERROR_PERSON_NOT_LOGIN; } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); }
/// <summary> /// 添加入库单 /// </summary> /// <param name="ppd"></param> /// <returns></returns> public RespResult AddProductonDetail(ProProductonDetail ppd) { RespResult result = new RespResult(); try { result.Error = ProProductonDetailAccessor.Instance.Insert(ppd) ? AppError.ERROR_SUCCESS : AppError.ERROR_FAILED; } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } return(result); }
/// <summary> /// 添加数据 /// <param name="es">数据实体对象数组</param> /// <returns></returns> /// </summary> public int Insert(ProProductonDetail e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdInsertProProductonDetail = cmdInsertProProductonDetail.Clone() as MySqlCommand; int returnValue = 0; _cmdInsertProProductonDetail.Connection = oc; try { if (oc.State == ConnectionState.Closed) { oc.Open(); } _cmdInsertProProductonDetail.Parameters["@Price"].Value = e.Price; _cmdInsertProProductonDetail.Parameters["@PNum"].Value = e.PNum; _cmdInsertProProductonDetail.Parameters["@PCode"].Value = e.PCode; _cmdInsertProProductonDetail.Parameters["@CreateTime"].Value = e.CreateTime; _cmdInsertProProductonDetail.Parameters["@UserId"].Value = e.UserId; _cmdInsertProProductonDetail.Parameters["@PId"].Value = e.PId; _cmdInsertProProductonDetail.Parameters["@EntId"].Value = e.EntId; _cmdInsertProProductonDetail.Parameters["@IsPay"].Value = e.IsPay; _cmdInsertProProductonDetail.ExecuteNonQuery(); returnValue = Convert.ToInt32(_cmdInsertProProductonDetail.LastInsertedId); return(returnValue); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdInsertProProductonDetail.Dispose(); _cmdInsertProProductonDetail = null; } }