public int Delete(PSS_InWarehouse obj)
{
using (Conn)
{
string query = @"DELETE FROM PSS_InWarehouse WHERE IWID = @IWID";
return(Conn.Execute(query, obj));
}
}
public int Insert(PSS_InWarehouse obj)
{
using (Conn)
{
string query = @"INSERT INTO PSS_InWarehouse
VALUES(@IWID,@IWWay,@CompanyID,@Receipts,@IWRemark,@IsIW,@IWDate,@OperateNo,@OperateDate)";
return(Conn.Execute(query, obj));
}
}
public int Update(PSS_InWarehouse obj)
{
using (Conn)
{
string query = @"UPDATE PSS_InWarehouse
SET IWID=@IWID,IWWay=@IWWay,CompanyID=@CompanyID,
Receipts=@Receipts,IWRemark=@IWRemark,IsIW=@IsIW,
IWDate=@IWDate,OperateNo=@OperateNo,OperateDate=@OperateDate
WHERE IWID =@IWID";
return(Conn.Execute(query, obj));
}
}
public ActionResult AcceptClick(PSS_InWarehouse obj)
{
string key = Request["key"];
int old_isiw = default(int);
int.TryParse(Request["old_isiw"], out old_isiw);
int isOk = default(int);
//key表示是否编辑的标识，1表示处于编辑状态 0表示增加状态
if (key == "1")
{
//由于入库状态是不可逆的，所以由未入库到入库时，会增加库存事务
if (obj.IsIW == 1 && old_isiw == 0)
{
//添加入库时间
obj.IWDate = DateTime.Now.ToString("G");
//通过记录获得对应的入库药品信息
Hashtable ht = new Hashtable();
ht.Add("IWID", obj.IWID);
IList list = ipss_inwarehousedetailbll.GetList(ht);
//添加对应的库存
foreach (Dto_InWarehouseDetail item in list)
{
PHA_Accounts a = ipha_accountsbll.GetEntity(item.PhaCode, item.OrginID.ToString());
a.Stock += item.InWarehouseCount;
ipha_accountsbll.Update(a);
}
}
isOk = ipss_inwarehousebll.Update(obj);
}
else
{
PSS_InWarehouse temp = ipss_inwarehousebll.GetEntity(obj.IWID.ToString());
if (temp == null)
{
HttpCookie cookie = Request.Cookies["user"];
obj.OperateNo = cookie.Values["Code"];
obj.OperateDate = DateTime.Now.ToString("G");
isOk = ipss_inwarehousebll.Insert(obj);
}
else
{
isOk = -1;
}
}
return(Content(isOk.ToString()));
}
public int Delete(PSS_InWarehouse obj)
{
return(dal.Delete(obj));
}
public int Insert(PSS_InWarehouse obj)
{
return(dal.Insert(obj));
}
public int Update(PSS_InWarehouse obj)
{
return(dal.Update(obj));
}
public ActionResult InWarehouseDetail(string IWID)
{
PSS_InWarehouse obj = ipss_inwarehousebll.GetEntity(IWID);
return(View(obj));
}
