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