Beispiel #1
0
 public int Delete(PHA_Accounts obj)
 {
     using (Conn)
     {
         string query = @"DELETE FROM PHA_Accounts WHERE PhaCode=@PhaCode AND OrginID = @OrginID";
         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()));
        }
Beispiel #3
0
 public int Insert(PHA_Accounts obj)
 {
     using (Conn)
     {
         string query = @"INSERT INTO PHA_Accounts VALUES(
                                                             @PhaCode,
                                                             @OrginID,
                                                             @CompanyID,
                                                             @Stock,
                                                             @InWarehousePrice,
                                                             @RetailPrice,
                                                             @WholesalePrice,
                                                             @RetailSum,
                                                             @WholesaleSum,
                                                             @InWarehouseSum
                                                          )";
         return(Conn.Execute(query, obj));
     }
 }
Beispiel #4
0
 public int Update(PHA_Accounts obj)
 {
     using (Conn)
     {
         string query = @"UPDATE PHA_Accounts SET 
                                                     PhaCode = @PhaCode,
                                                     OrginID = @OrginID,
                                                     CompanyID = @CompanyID,
                                                     Stock = @Stock,
                                                     InWarehousePrice = @InWarehousePrice,
                                                     RetailPrice = @RetailPrice,
                                                     WholesalePrice = @WholesalePrice,
                                                     InWarehouseSum = @InWarehouseSum,
                                                     RetailSum = @RetailSum,
                                                     WholesaleSum = @WholesaleSum
                                               WHERE 
                                                     PhaCode = @PhaCode AND
                                                     OrginID = @OrginID";
         return(Conn.Execute(query, obj));
     }
 }
        public ActionResult AcceptClick(PHA_Accounts obj)
        {
            string key  = Request["key"];
            int    isOk = default(int);

            //key表示是否编辑的标识,1表示处于编辑状态 0表示增加状态
            if (key == "1")
            {
                isOk = ipha_accountsbll.Update(obj);
            }
            else
            {
                PHA_Accounts temp = ipha_accountsbll.GetEntity(obj.PhaCode, obj.OrginID.ToString());
                if (temp == null)
                {
                    isOk = ipha_accountsbll.Insert(obj);
                }
                else
                {
                    isOk = -1;         //存在相同的记录,出错。
                }
            }
            return(Content(isOk.ToString()));
        }
Beispiel #6
0
 public int Insert(PHA_Accounts obj)
 {
     return(dal.Insert(obj));
 }
Beispiel #7
0
 public int Delete(PHA_Accounts obj)
 {
     return(dal.Delete(obj));
 }
Beispiel #8
0
 public int Update(PHA_Accounts obj)
 {
     return(dal.Update(obj));
 }