/// <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;
}
}
