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