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