public ActionResult AcceptClick(PSS_PurchasePlanDetail obj) { int isOk = default(int); isOk = ipss_purchaseplandetailbll.Insert(obj); return(Content(isOk.ToString())); }
public int Delete(PSS_PurchasePlanDetail obj) { using (Conn) { string query = @"DELETE FROM PSS_PurchasePlanDetail WHERE ID = @ID"; return(Conn.Execute(query, obj)); } }
// public int Update(PSS_PurchasePlanDetail obj) // { // using (Conn) // { // string query = @"UPDATE PSS_PurchasePlanDetail // SET PurchaseNo=@PurchaseNo,PurchaseDate=@PurchaseDate, // Remark=@Remark,OperateNo=@OperateNo,OperateDate=@OperateDate,PurchaseStatus=@PurchaseStatus // WHERE PurchaseNo =@PurchaseNo"; // return Conn.Execute(query, obj); // } // } public int Insert(PSS_PurchasePlanDetail obj) { using (Conn) { string query = @"INSERT INTO PSS_PurchasePlanDetail VALUES(@PurchaseNo,@PhaCode,@OrginID,@PurchaseNum)"; return(Conn.Execute(query, obj)); } }
public int Delete(PSS_PurchasePlanDetail obj) { return(dal.Delete(obj)); }
public int Insert(PSS_PurchasePlanDetail obj) { return(dal.Insert(obj)); }